Join us for our *FREE LIVE TRAINING* that teaches the building blocks of automation: www.garethpronovost.com/webinar-registration

As always, you doing amazing job with explanation of how Airtable works. Thank you Gareth.

@GarethPronovost

4 жыл бұрын

Thanks for watching!

Great videos. Informative, direct and how to. No fluff. If I create a form to collect email data, can I search the data to find a specific email instead of just searching on originator or date?

Airtable added conditional logic to their forms now. This was very helpful

@GarethPronovost

4 жыл бұрын

Yes indeed! Very excited that they included this in their April 2020 update, but there are still things I wish there forms could do. I recently posted a more advanced form video here if you're looking for ideas: kzread.info/dash/bejne/o4SfvLCfcabclps.html

@ensmith210

4 жыл бұрын

Thank you! Will check out.

Thank you Gareth! Very helpful. I have a question concerning multiple form views. I have built multiple forms to feed into the same table and I want to be able to see which form a person filled out so that I can group them. Is there a way to automatically fill the table with that information?

Very helpful video. If you don't mind, I have these notes: Your front cam covered about %25 from the screen. Add a cover/logo/redirect all only if you pay. I have 14 days pro. trial and cannot practice these things! This video has a lot of youtube ADs, really annoying. But this video is a great tutorial for building forms. (:

@GarethPronovost

Жыл бұрын

Thanks for the feedback!

Superb video. Very helpful!

@GarethPronovost

3 жыл бұрын

Really grateful to you for watching and commenting 🙏

Very helpful. Thanks!

@GarethPronovost

2 жыл бұрын

Glad it was helpful!

Very helpful, Gareth! Thanks!!

@GarethPronovost

4 жыл бұрын

Thanks Dana!

That's really very helpful.

@GarethPronovost

3 жыл бұрын

Glad to hear that- thanks for watching!

Great video. The prefill portion was illuminating. My question - in this example is it possible to select more than one client in the form? I'm a book publicist and often create forms for people to request different books from me. Rather than create a separate drop-down/list menu (field), I'd like to use my linked records to select multiple books. Thanks.

@GarethPronovost

2 жыл бұрын

You can make that option available when you build your linked relationship. In my case, I said that only one linked record could exist at a time, but you can allow multiple records to link. By doing so, you could then submit a form linked to multiple clients. 😊

Hi Gareth, great video - thanks! Is it possible to prefill more than one field? How would this be added to the formula? Thanks

@GarethPronovost

4 жыл бұрын

Hey Katie - great question, can't believe I didn't mention this! Yes, you can prefill multiple fields. After the formula is complete for one field, just add an ampersand and prefill again. For example: concatenate("ORIGINAL_URL?prefill_Client=", {Client}, "&prefill_Email=", {Email}) Kind of hard to visualize it here, you can check Airtable Support Docs as well for more examples: support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form

Hi, this video is really helpful and informative. May I ask if the subject header such as account receivable can the font be changed into a different color? Thank you!

@GarethPronovost

3 жыл бұрын

Hey Steph, thanks for watching! I don't think you can change the color of the font in the table headers. However, you can get fancy by using a text generator to add bold, italics, or similar font changes.

Great job as always! Can I ask you if there is any video where you explain how to make the booking system that you use on the section of your website ( "Complimentary Airtable Consultation " )? Is it made with Airtable? Thank you again : )

@GarethPronovost

4 жыл бұрын

Hey Pablo! The booking system definitely *integrates* with my Airtable database, but the booking system is created with Calendly (www.calendly.com). As a meeting is created in Calendly, that information is then automatically created/updated in my Airtable. Check out this video here for a bit of a walkthrough: kzread.info/dash/bejne/qmGfj7Zrk9HKZco.html

@pavloba07

4 жыл бұрын

@@GarethPronovost Thank you so much Gareth!!!

Hi Gareth, very helpful video! I'm wondering if there is a way to create multiple records by submitting one form?

@GarethPronovost

3 жыл бұрын

If using an Airtable form, then a form submission only creates one record in one table. However, you can use a third party form software and then build automations in Zapier that create multiple records from a single form submission... it's advanced, but possible!

Very informative! Is there a better form platform with pre filled data that allows for bi-directional data integration with Airtable?

@GarethPronovost

4 жыл бұрын

I use JotForm for most of my form needs. Did a video on an advanced use-case here if you want to check them out! kzread.info/dash/bejne/o4SfvLCfcabclps.html

Great video as always! Question - Because the personalized link gets kind of long, is it possible to add a field for a shortened url (example via bitly) that would automatically shorten it?

@GarethPronovost

4 жыл бұрын

I've tested this a couple of times and it's worked using bitly. That said, what I typically do is embed the link in an email using HTML. This way, they never have to see the link, but it still holds all the relevant data!

@Sieva04

4 жыл бұрын

@@GarethPronovost Good point! I'm thinking someday I might want to track clicks and know bitly offers a link usage analysis, so it could be useful. I'm guessing there's a zap to shorten the link.

Hi Gareth, You said you can't hide the clients with this prefill option. But you actually can. In the form view you just move that field out to hide it. The prefill link still works as if it was there, and prevents a client from seeing other clients.

@stevejoslyn

2 жыл бұрын

The only caveat is the client wouldn't be able to see that it's being setup for them. Since the field is hidden. It would be great for Airtable to bring in Lookup fields that show up in the form.

@GarethPronovost

2 жыл бұрын

That's great to hear! I'll have to test this myself ASAP. I don't remember hearing about this upgrade/update - I wonder when they added this feature. 🤔

@stevejoslyn

2 жыл бұрын

@@GarethPronovost I think it’s always been there. Just no one thought to hide it but still use it for prefill links.

@GarethPronovost

2 жыл бұрын

@@stevejoslyn - just wanted to let you know I tried this but was unable to replicate your results 9t still didn't work for me). I'll post a video showcasing this soon. If there's something special you're doing to get it to work I'd love to know!

@stevejoslyn

2 жыл бұрын

@@GarethPronovost Okay, I also recreated it and failed. The prefill still works after you hide it in the form view. I even made the other fields conditional on the prefilled field being "not empty". But now I realise the record is completed without the prefill data. So hiding works, but you don't get the Client. Its funny that the form still allows the record to be completed despite it breaking the conditional rules.😕

Thank you for these videos. Can you add a form within a form? IE, we have users, those users can add assets to their profile, but we keep the assets in a separate table. So I want to do: Person X details other details Asset: - Asset name - Asset details Submit

@GarethPronovost

2 жыл бұрын

Hey Jacob, I think you're looking for some advanced form functionality that isn't possible inside the native Airtable form. However, you can super power JotForm and Airtable to do some more advanced stuff. Check this video out for some ideas: kzread.info/dash/bejne/lJOrpNWFlL2teZc.html

If members of our organization are adding to a database via the form, is there a way that it can be marked as new information so that I can approve it? I know that there is the option to have them email me, but for example one person added 20 items to the database and I got 20 emails!! I just would like to be able to see if things are all correct.

@GarethPronovost

3 жыл бұрын

Certainly, you'll likely want to correct this with an automation. You can make it so that newly created records receive a checkbox or specific status. Then go into your form and turn off the email you receive when the form is submitted.

Hey Gareth! I have a question, it possible to divide the form in sections? How?

@GarethPronovost

2 жыл бұрын

Not with an Airtable form, only with more advanced form software like jotform

Is it possible to customize forms by adding css or html code for creating theme, backround, different font , image without upgrading account.

@GarethPronovost

3 жыл бұрын

Great question - unfortunately the Airtable forms don't allow for this even on a paid account. To get this feature, you'd need to use a third-party form software and automate the data captured with your Airtable database.

Is it possible to create the "New Client" while filling up the form. So basically instead of choosing the Client from the list we can create the new client (by adding the required info)?

@GarethPronovost

3 жыл бұрын

Every Airtable form creates data in one table only, so you'd need a form specifically for creating the new Client. Alternatively, you can use a third party form tool, build one long form, and then automate the data into the appropriate tables within Airtable.

@nocodetalks

3 жыл бұрын

@@GarethPronovost What is name of the third party form tool?

@GarethPronovost

3 жыл бұрын

@@nocodetalks any 3rd party form software would work. I prefer JotForm, but there are many others such as Typeform, ZoHo Forms, aida forms, etc.

Does anyone know how to create a new page? For the airtable survey for?

@GarethPronovost

4 жыл бұрын

You can create a new form by building a new Airtable view and choose "Form"

How do I make the forms wider? I haven't found an option or a way to do it. It just looks way to close and leaves white space on both left and right. Please help me if anyone knows about it.

@GarethPronovost

3 жыл бұрын

Are you trying to embed the form on a webpage? Or are you using the stock form URL?

@mayudm

3 жыл бұрын

@@GarethPronovost Stock form URL

@GarethPronovost

3 жыл бұрын

@@mayudm I don't think you can resize the form from there, sorry!

Update for future viewers. Airtable does support conditional forms as of April 2021.

@GarethPronovost

3 жыл бұрын

Very true, thanks Cloud!

Can we change the color of the SUBMIT button from blue to BLACK?

@GarethPronovost

2 жыл бұрын

I don't think so - the forms in Airtable don't allow for that much customization. However, my preference for more robust form building is JotForm (jotform.com) and they allow for this!

Ok but where is the url to start this? It cannot be seen in the window. Please help and you are giving all off us an exciting knowledge to us☺️☺️. Thank you

@GarethPronovost

3 жыл бұрын

Do you mean how to get Airtable? It's airtable.com Each form gets its own unique URL that you can find by sharing the form!

@jyotirdiptadas3989

3 жыл бұрын

@@GarethPronovost I got it but the problem is with the free version Is there any way to get the paid version free as I doing a startup in India

@GarethPronovost

3 жыл бұрын

I don't know much about free accounts, I'd suggest reaching out to their customer support to see how flexible they are.

Would you recomend any forms software with conditional logic wich could be integrate with airtable?

@SciJoy

4 жыл бұрын

If you look at Gareth's latest video, AirTable just updated for conditional logic.

@josedanielfreitezolivar2477

4 жыл бұрын

@@SciJoy Hi thanks for your help..!

@GarethPronovost

4 жыл бұрын

Thanks for the assist Joy! Yes, Airtable did just release conditional logic with their forms, which is very exciting and has been a long time coming. However, there are more robust form needs that still aren't met by Airtable's forms. One example is logic jumps (going to a certain part of the form based on answers). Another example is conditional submission pages (going to a different page depending on responses). For these uses I like JotForm and Typeform - these are my go-to form software choices. However, if your use-cases aren't this robust, then Airtable forms will probably get the job done just fine!

@josedanielfreitezolivar2477

4 жыл бұрын

@@GarethPronovost So thanksfull..!

Hi Gareth. I'd like to know if we're able to then display the data from the form for the client after they submit. For instance, give them a summary like ' Dear GARETH PRONOVOST, your payment was received via ACH on 1/12/2022. Thanks for your business.

@GarethPronovost

2 жыл бұрын

Hi! Yes, you can do this, but not on the redirect page that's shown after the form is submitted. Instead, you can build an automation that sends this information (maybe an email after the form is submitted, for example). There is a redirect page option in Airtable forms, but it isn't dynamic, meaning it can only direct to ONE page.

@misse2449

2 жыл бұрын

@@GarethPronovost Thanks for your response. I was actually looking at using Airtable with Figma, but to have the App take the user to a new page on the App after they submit the form. And the data is to be pulled directly from the records ( record ID, maybe?) and inserted within the text to be displayed on that next page. Seems like a tall order, maybe?

@GarethPronovost

2 жыл бұрын

@@misse2449 I can't really speak to Figma, but I'd suggest looking into Softr. This would allow your users to log into your app and view their own data. In this case, you could absolutely redirect them to a specific page after they took an action.

@misse2449

2 жыл бұрын

@@GarethPronovost Will definitely look into Softr. Thanks!

@misse2449

2 жыл бұрын

I've looked at it now and for some reason, it's not making a lot of sense to my beginner's mind. Just one question to go from where I am to the next step at least, please. Is it possible to export a form created in Airtable into Figma so that when someone fills the form in Figma, the information they're entering goes straight into my Airtable records? Thanks in advance.

Can we set password to the form so that only my sales team can fill that?

@GarethPronovost

4 жыл бұрын

Yes, you can restrict access with a password, or to a specific email domain.

Question: is it possible to create a page of my website connected to my Airtable and create a kind of form where I can search results?

@GarethPronovost

2 жыл бұрын

Hi Stefano - I don't think you'd want to use a form to search your results. Instead check out the views feature in Airtable which allows you to filter your existing data. Yes, it's possible to create a page of your website and to embed Airtable in that - this embedded view could also be filtered with searches as described above.

@StefanoLBP

2 жыл бұрын

@@GarethPronovost the point is that I don’t want people enter inside the Airtable because they can create a mess, that’s why I want to know how allow them to search for results without be inside my Airtable. Any suggest?

@StefanoLBP

2 жыл бұрын

@@GarethPronovost the point is that I am the one who build the database and I cannot allow people in the office to mess up with Airtable TABS. I know how to manage the views and how to use filters but, and here is the problem, I need my boss to search what he looking for without login inside Airtable. First because he is a dummy with computers and there is a risk he delete something, Second I need something user friendly to get results. Any suggestion? Any app around?

Well now Airtable Features Conditional Logic…

@GarethPronovost

Жыл бұрын

True! New improvement every day! IMO the conditional logic in Airtable forms isn't very robust yet, but it's a great start!

Thank you so much. Just discover your blog, Im a new subscriber now. Hope you can help me with this: I would like to email o send a whatsapp message (or another app maybe) to all the persons who submitt my form. I has created a view filtering the Information that has registered today, but the form is not the only way where the Data Base receives information. Great video

@GarethPronovost

3 жыл бұрын

Sure you can do this with an automation. Either trigger from a new form submission (just form entries) or trigger from a new record (

@taboaren

3 жыл бұрын

@@GarethPronovost thx Gareth, but I can't see that option. Just for Google Forms, not Airtable forms