Gareth I have to turn in a fully functional Airtable for an educational proyect and for a possible job position. From the bottom of my heart thank you. Your videos make it real easy and simple to learn how to get a database going and it goes straight to the point. Thank you very much
Awesome. Thank you. I agree with others I wish I had you as a teacher in every single one of every class that I have ever taken through school in college I like your pace, I like how you do not linger on any one subject If you taught for five minutes, it would take a lot of other teachers. 15 minutes to say the same thing lol. Thank you so much. I’m glad I just found you and I’m signing up. I had downloaded Airtable before, but I thought it was this stupid, generic spreadsheet that couldn’t help me much. You are opening my eyes to the possibilities now. Thank you so much
Thank you Gareth. I am going through all your videos one by one. Really very useful. And just got email from you about the airtable crash course and it's so well written. Got inspired by your story. Thanks
Hi Gareth, thank you for the video, is there no way of keeping single select on the field itself, but at be able create a new option not already on the list when filling the form? unfortunately, i use single select feature in other views, and i dont want to turn it off for everything just to be abel to use it on the form view
I use an Airtable form that allows me to select any outstanding Order ID/Item ID/Item Name combinations to a receiving database. It works except EXCEPT the wrapping of the "Order ID/Item ID/Item Name" field does NOT wrap in the form so you can't see what you are selecting. Is there any solution/suggestion for this? (And thank you - your videos are wonderful!)
Thank you, Gareth, for this and all the other instructional videos you have posted. They have been very helpful to me. My question is: Can you add questions to an Airtable form that has already collected data? With other words, will the added questions cause any problems to the "old" data?
Hi - I think you're asking if it's possible to add new fields to a form, is that right? If so, then YES! You can always add new fields/tables to your Airtable databases without destroying pre-existing data. The old data will simply have blank answers for these new questions!
Great video as usual!!. May I ask you what screen recording software do you use? The zoom function is great and manages to keep our attention throughout the video.
¿Cómo puedo obtener el link de cada formulario que se llena y así poder enviarlos a las personas para que editen la información que en ciertos casos puede ser incorrecta?
The link for each form is available in the form setup. you can send them manually to people using email/Slack/etc. or you can build an automation within Airtable to send the links
@@GarethPronovost I'm aware of Formstack, Jotform, Typeform, and Google forms, so those might be good to include. I'd love to learn if there are more out there.
I think you're looking for a form within a form... sounds like you want to see information about linked records as you navigate the form. For this I'd recommend 3rd party options since Airtable can't handle this natively. You might check out www.fillout.com/?ref=gapconsulting (we'll have a video coming out for this shortly, stay tuned!)
Okay i have since found out that yes this is all possible, but, can you answer this please - for a multiple choice Q, most other forms allow an 'other' option where they can type in their own option. Is this possible?
Hi! An "other" option is available if you create a long text field as a separate field to your multi-select field. In the multi-select field, create an option called "other" - then build a condition in your new long text field that only allows it to appear on the form if/when someone clicks "other" It's a conditional element on your form that will only show up when someone selects the "other" option and will allow them to fill out some text. Hope this helps! 🙌
Hi Gareth! Thanks for this video. A question before I tackle building my own form - I need a whole questionnaire to get to know all about a person. Is this just as easy to do?
Gareth, this is a great video. I have learned alot from you from not even knowing what Airtable was to have a pretty complicated airtable database at present. What I want to do now is use a webform to add someone to my database while having them select certain from predetermined drop down fields. When they are done, I want them to receive an email to the email address they have provided with one of multiple PDFs. Is this possible?
Totally possible. You'd build an automation to send the email triggering from a received form. The "path" of the automation would choose which PDF they get!
Hi, Is there a way to create a form in which it will be possible to choose a option based on category I choosen? First field "Car company" I choose for ex. Audi So in the next field I can choose types like: A1, A2, A3, A4, R8....... But if I would choose diffrent complany in first field for example Ford in next field I will have option to choose related with Ford like Mondeo, Focus .... Is it possible to create such a form? Im willing to upgrade my account to pro version even. THX!
I am also interested to know of forms will do a solution like this. I want it for inventory input so if I choose lamp it will give me special fields to input the shade dimensions and the height of the base at the top of socket and top and bottom of neck for example. Then if I choose a bed it's a whole other set of measurements to input.
Thank you Gareth, I am fairly new to Airtable and learning a lot from your videos. I also use Jotform and I have a question about integrating the two. I need to create a dynamic dropdown in a field that is dependent on what is selected in another dropdown. I am planning to do this in Jotform using my Airtable base. Do I need Zapier for this?
Hi Monika! It sounds like you might need to build some conditional dependencies within your form - check out this video with some options: ua-cam.com/video/b_wBsLdZGI4/v-deo.html This is an extra tool that takes JotForm + Airtable to the next level! 🙌
Hi, good video. Quick q, can you have formula fields in forms, for example that calculates a total based on 2 values you input further up the form? Thank you
Hi Rocky, you can't have the formula field in the form itself, but it can calculate the total when the form is submitted with 2 other values. The only fields that can go into a form are editable fields, and a formula is not editable. But it can def do the calculation in your Airtable base after the form is received! 💪
Hey Luis, thanks for watching! For custom projects, please start with our project application here (www.garethpronovost.com/development-application) Once approved, we'll invite you to chat with our team for an intro/discovery call 💪
Gareth, I am trying to create a form, that is used by +100 different affiliates of mine. The first question on that form is a dropdown menu of the names of every affiliate I have. Is it possible for me to generate a unique link to GIVE to my affiliate so that when they share that link with their customers the dropdown will be PRE-SELECTED and fixed to their name only? If this makes sense, it would be awesome for a simple response or even a tutorial
Thanks for watching - yes you'll want to explore how to prefill forms in Airtable. You might start with this tutorial here (ua-cam.com/video/uYyVzOypUms/v-deo.html) I've shared the timestamp where we dive into the prefill capabilities. The only hiccup here is that the folks who fill out the form could choose to change this data. In a perfect world, I'd recommend that you prefill the form, but keep it hidden! This isn't possible to do in an Airtable form, but it is possible if you use a 3rd-party form tool. My recommendation for this is JotForm - here's a video that shows you how! ua-cam.com/video/qPkZNfACvf8/v-deo.html
Hey Gareth! Thanks for the video. I hope you can help me decide, I wanna work with air table but I have some concerns with price "per seat", I'm not sure if I fully understand it. Because I have team members that only submit some data into the database.. but not really work within it, and also don't want to give them the main user and password to access ALL the data. I was thinking on giving forms to them. Will it bill me as another collaborator? For each person filling the form? Is there a work around to pay only for one seat. But Have some people adding some info to some tables?
If people only enter data through forms, they will not be billed as collaborators. If they access your data in an Airtable Interface or are added to your database directly, they will incur charges per license depending on the plan you are on. Note that they can access data or interfaces with read-only access and WILL NOT incur a charge. Only if they have commenter permissions or better will you be billed for them.
As a new user of Airtable, how do you let a user use a form without having to 'enter' the database with all its options? How do I save a form and how do I activate the form?
You don't need to save a form, any changes you make are instantly available in the public URL. Each form is activated automatically and can be shared by using the share link or embedded on a website! Users submit data in the form without logging into Airtable, so they don't need to be users ✅
Great video. Thanks Gareth! I had a couple of questions. Can AT Form send an automated email to the applicant's email address after they submit their form? Also, if this and other functions are beyond AT's form builder, which 3rd party apps do you recommend that work well with AT? I'd like to automate as much of the info from the form into my table as possible. THanks again!
Hi Jacob, yes Airtable can do this, provided the email address is something that you are asking in the form. Check out the automation feature in Airtable (we have many videos on the topic, as do others). Sometimes you will need to go beyond Airtable, depending on the complexity of your form and how you want to store the data. For more complex forms, my preference is JotForm or TypeForm. From there, you'll want to push the data into Airtable, so you'll likely want Zapier or Make for automation. If you haven't already, you may want to check out our fundamental automation training: garethpronovost.com/webinar-registration
Do you know anything about the upgraded form building experience. Each time I select it, I edit the form but I don't see it in my base and have no idea how to access it. Any thoughts?
@@GarethPronovost I just learned that forms can be both in the interface or in form view. I was not aware of this. Still have to spend some time to understand how the form works in interface.
Ge my *Airtable Crash Course* that will help you "think in Airtable": www.garethpronovost.com/airtable-crash-course
Dude, these airtable videos are top notch.
Thanks mate 🤝
Gareth I have to turn in a fully functional Airtable for an educational proyect and for a possible job position. From the bottom of my heart thank you. Your videos make it real easy and simple to learn how to get a database going and it goes straight to the point. Thank you very much
I'm glad to be able to help! 🙌
Awesome. Thank you.
I agree with others
I wish I had you as a teacher in every single one of every class that I have ever taken through school in college
I like your pace, I like how you do not linger on any one subject
If you taught for five minutes, it would take a lot of other teachers. 15 minutes to say the same thing lol.
Thank you so much. I’m glad I just found you and I’m signing up.
I had downloaded Airtable before, but I thought it was this stupid, generic spreadsheet that couldn’t help me much. You are opening my eyes to the possibilities now.
Thank you so much
you are one of the best instructors i've seen yet.
So thankful I could help! 🙏
I was not gonna watch this, thinking I already knew forms, but I'm glad I did... Lots of tips! Thanks GP!
Glad to hear! Always good to build a strong foundation 💪
Excellent teaching style and extremely clear. Thank you, Gareth.
Thanks for watching, glad to be of service!
Thank you Gareth. I am going through all your videos one by one. Really very useful. And just got email from you about the airtable crash course and it's so well written. Got inspired by your story. Thanks
Very glad to help, thanks for watching!
I can´t thank you enough for this video! My boss let me with this task, and this video helped A LOT! THANKS!
Hooray! 🙌 glad to help!
Hi Gareth, thank you for the video, is there no way of keeping single select on the field itself, but at be able create a new option not already on the list when filling the form? unfortunately, i use single select feature in other views, and i dont want to turn it off for everything just to be abel to use it on the form view
I use an Airtable form that allows me to select any outstanding Order ID/Item ID/Item Name combinations to a receiving database. It works except EXCEPT the wrapping of the "Order ID/Item ID/Item Name" field does NOT wrap in the form so you can't see what you are selecting. Is there any solution/suggestion for this? (And thank you - your videos are wonderful!)
Thank you, Gareth, for this and all the other instructional videos you have posted. They have been very helpful to me.
My question is: Can you add questions to an Airtable form that has already collected data? With other words, will the added questions cause any problems to the "old" data?
Hi - I think you're asking if it's possible to add new fields to a form, is that right? If so, then YES! You can always add new fields/tables to your Airtable databases without destroying pre-existing data. The old data will simply have blank answers for these new questions!
Excellent video, thank you. Is it possible to collect address/location via airtable form?
You can ask for an address in a text field, but it's not possible to autopopulate geodata with an Airtable form at this time
Great video as usual!!. May I ask you what screen recording software do you use? The zoom function is great and manages to keep our attention throughout the video.
Of course, I record my screen with Camtasia and also use it to edit the videos
¿Cómo puedo obtener el link de cada formulario que se llena y así poder enviarlos a las personas para que editen la información que en ciertos casos puede ser incorrecta?
The link for each form is available in the form setup. you can send them manually to people using email/Slack/etc. or you can build an automation within Airtable to send the links
Gareth, can you please make a video summarizing the pros and cons of various form creation tools?
Hey Jamie, interesting topic! I'll add it to the queue. Are there particular form software you'd like to see included?
@@GarethPronovost I'm aware of Formstack, Jotform, Typeform, and Google forms, so those might be good to include. I'd love to learn if there are more out there.
@@jrr4475 the list of options for form software is extensive, but these three are a great place to start!
How do you deal with Lookup with a Form? Such that you can view/search a record and view details about it?
I think you're looking for a form within a form... sounds like you want to see information about linked records as you navigate the form. For this I'd recommend 3rd party options since Airtable can't handle this natively. You might check out www.fillout.com/?ref=gapconsulting (we'll have a video coming out for this shortly, stay tuned!)
Just finished the video! Can you tell me if check boxes and multiple choice is possible? and can you have two different uploads required field?
Okay i have since found out that yes this is all possible, but, can you answer this please - for a multiple choice Q, most other forms allow an 'other' option where they can type in their own option. Is this possible?
Hi! An "other" option is available if you create a long text field as a separate field to your multi-select field. In the multi-select field, create an option called "other" - then build a condition in your new long text field that only allows it to appear on the form if/when someone clicks "other"
It's a conditional element on your form that will only show up when someone selects the "other" option and will allow them to fill out some text.
Hope this helps! 🙌
Hi Gareth! Thanks for this video. A question before I tackle building my own form - I need a whole questionnaire to get to know all about a person. Is this just as easy to do?
Saw your other question and I'm assuming you started exploring the forms a bit. Yes, it's pretty easy to set up!
Gareth, this is a great video. I have learned alot from you from not even knowing what Airtable was to have a pretty complicated airtable database at present. What I want to do now is use a webform to add someone to my database while having them select certain from predetermined drop down fields. When they are done, I want them to receive an email to the email address they have provided with one of multiple PDFs. Is this possible?
Totally possible. You'd build an automation to send the email triggering from a received form. The "path" of the automation would choose which PDF they get!
Hi,
Is there a way to create a form in which it will be possible to choose a option based on category I choosen?
First field "Car company" I choose for ex. Audi
So in the next field I can choose types like: A1, A2, A3, A4, R8.......
But if I would choose diffrent complany in first field for example Ford in next field I will have option to choose related with Ford like Mondeo, Focus ....
Is it possible to create such a form? Im willing to upgrade my account to pro version even.
THX!
I am also interested to know of forms will do a solution like this. I want it for inventory input so if I choose lamp it will give me special fields to input the shade dimensions and the height of the base at the top of socket and top and bottom of neck for example. Then if I choose a bed it's a whole other set of measurements to input.
Thank you Gareth, I am fairly new to Airtable and learning a lot from your videos. I also use Jotform and I have a question about integrating the two. I need to create a dynamic dropdown in a field that is dependent on what is selected in another dropdown. I am planning to do this in Jotform using my Airtable base. Do I need Zapier for this?
Hi Monika! It sounds like you might need to build some conditional dependencies within your form - check out this video with some options: ua-cam.com/video/b_wBsLdZGI4/v-deo.html
This is an extra tool that takes JotForm + Airtable to the next level! 🙌
Can we add different dropdowns based on different inputs selected in previous entry ?
Not in Airtable's native forms, but you can with an advanced form software. Check our videos for a tool called Fillout!
Hi, good video. Quick q, can you have formula fields in forms, for example that calculates a total based on 2 values you input further up the form? Thank you
Hi Rocky, you can't have the formula field in the form itself, but it can calculate the total when the form is submitted with 2 other values. The only fields that can go into a form are editable fields, and a formula is not editable. But it can def do the calculation in your Airtable base after the form is received! 💪
@@GarethPronovost Thanks Gareth. Top man💪💪.
Gareth! As always, thanks for the great content! What is the best way to reach out to you or your team for consultation on a project?
Hey Luis, thanks for watching! For custom projects, please start with our project application here (www.garethpronovost.com/development-application)
Once approved, we'll invite you to chat with our team for an intro/discovery call 💪
Gareth,
I am trying to create a form, that is used by +100 different affiliates of mine. The first question on that form is a dropdown menu of the names of every affiliate I have. Is it possible for me to generate a unique link to GIVE to my affiliate so that when they share that link with their customers the dropdown will be PRE-SELECTED and fixed to their name only?
If this makes sense, it would be awesome for a simple response or even a tutorial
Thanks for watching - yes you'll want to explore how to prefill forms in Airtable. You might start with this tutorial here (ua-cam.com/video/uYyVzOypUms/v-deo.html) I've shared the timestamp where we dive into the prefill capabilities.
The only hiccup here is that the folks who fill out the form could choose to change this data. In a perfect world, I'd recommend that you prefill the form, but keep it hidden! This isn't possible to do in an Airtable form, but it is possible if you use a 3rd-party form tool. My recommendation for this is JotForm - here's a video that shows you how! ua-cam.com/video/qPkZNfACvf8/v-deo.html
Hey Gareth! Thanks for the video. I hope you can help me decide, I wanna work with air table but I have some concerns with price "per seat", I'm not sure if I fully understand it. Because I have team members that only submit some data into the database.. but not really work within it, and also don't want to give them the main user and password to access ALL the data. I was thinking on giving forms to them. Will it bill me as another collaborator? For each person filling the form? Is there a work around to pay only for one seat. But Have some people adding some info to some tables?
If people only enter data through forms, they will not be billed as collaborators.
If they access your data in an Airtable Interface or are added to your database directly, they will incur charges per license depending on the plan you are on. Note that they can access data or interfaces with read-only access and WILL NOT incur a charge. Only if they have commenter permissions or better will you be billed for them.
How do you get the form to a client for them to complete?
You can send the link via email, or embed the form on a website 👌
As a new user of Airtable, how do you let a user use a form without having to 'enter' the database with all its options? How do I save a form and how do I activate the form?
You don't need to save a form, any changes you make are instantly available in the public URL. Each form is activated automatically and can be shared by using the share link or embedded on a website! Users submit data in the form without logging into Airtable, so they don't need to be users ✅
@@GarethPronovost Thanks! Found it.
Great video. Thanks Gareth! I had a couple of questions. Can AT Form send an automated email to the applicant's email address after they submit their form? Also, if this and other functions are beyond AT's form builder, which 3rd party apps do you recommend that work well with AT? I'd like to automate as much of the info from the form into my table as possible. THanks again!
Hi Jacob, yes Airtable can do this, provided the email address is something that you are asking in the form. Check out the automation feature in Airtable (we have many videos on the topic, as do others).
Sometimes you will need to go beyond Airtable, depending on the complexity of your form and how you want to store the data. For more complex forms, my preference is JotForm or TypeForm. From there, you'll want to push the data into Airtable, so you'll likely want Zapier or Make for automation.
If you haven't already, you may want to check out our fundamental automation training: garethpronovost.com/webinar-registration
@@GarethPronovost thanks!
Do you know anything about the upgraded form building experience. Each time I select it, I edit the form but I don't see it in my base and have no idea how to access it. Any thoughts?
Are you building this form in the Airtable interface, or in the form view?
@@GarethPronovost I just learned that forms can be both in the interface or in form view. I was not aware of this. Still have to spend some time to understand how the form works in interface.
Very helpful
Thanks for watching!
Nice video!
Thanks!
Can't thank you enough...
Thanks for watching
Dude you need to keep it short. Too much things about you in the video