Use a form to update an existing record in Airtable

This video shows you how to set up an Airtable base that will automatically email a list of contacts and collect their RSVP responses. It uses automations and prefilled form fields to do that.

⭐️ Part of a business or enterprise team?

⭐️ Product Comparisons

⭐️ Airtable Basics

Chapters:
0:00 - Intro
0:46 - Setting up the table
5:28 - Prefilling the form
9:47 - Updating the RSVP with an Automation
12:06 - Send the RSVP with an automated email

[xlntmike]

I learned more from this video than any other. Thank you so much and looking forward to your wedding. Hope to meet half of the celebrities!

[AnuKumar-hlvv]

Another great video - I really like your attention to small details - moving the guest name field up, hiding the guest id in the form. These things go a long way!

[heatherbrand]

Just ran into this by chance - such a fun video, Julian! We are loving all the Airtable bases you built for us! If anyone reading these comments wants to contract outside Airtable help, Julian is your man!

[TALMAIsrael]

We use Airtable to manage our fellowship application and registration processes, and this has been incredibly helpful. Thanks for an easy to follow tutorial!

[larrymeyer]

Excellent video, so much better than the linked record method! This saved me from hours of additional agony trying to figure this out! Thank you!

[cristianopolese]

Thanks for your precious work, it's very useful! do you know if it can works also with new version of form? i'm tryn to, but from the new version of Airtable form, i have a different link, that prefill but does not update the record. Thanks in advance for your kindly reply

[hexadevi]

You just made me the coolest person in my Burning Man camp, thank you!!🖤

[MMcCarthyRealty]

Great video. Thanks. Hope you haven't retired from Youtube!

[happy]

Sir you just saved me so much time. Thank you for explaining this so simply and clearly!

[ShonaKamps]

Hey! Great video! Super helpful. I'm wondering if there is a workflow that updates fields in the main database, but if a field is left blank on the form to not overwrite the field in the main sheet. For instance, if Kanye decided to change his meal option but did not need to refill in the rest of the form and his previous preferences would not be overwritten. Thank you again for the video!

[TheCantwellAdvisory]

Great video, but is there a way to perform this process if I have a large number of fields and some of them have lengthy text and many multiple select options? Something that would exceed the 1, 600-character URL limitation?

[parameswaranp]

Thank you for the fantastic videos—they’ve been really helpful! I have a quick question: Is there a way to make prefilled details non-editable? For example, similar to hidden_guest_id=true, could we have something like readonly_guest_id=true or edit_guest_id=false? Additionally, is it possible to disable the link after the form is submitted? We need the form to be submitted only once, and if the link is clicked again, it should indicate that the form has already been submitted.

[marciaferreira]

Hi there, thank you for this. Just confirming, guests would need to create a airtable account to RSVP?

[ContentServices-bk]

Thank you for this great video. Question though, if you're using the form to update an already created record and field, how do you stop the tool from also recreating a new record at the same time?

[rileystephens]

In the formula column, can you make the formula/hyperlink read as text?

[VIPULDJHAVERI]

thanks for sharing your brilliancy
highly useful

[KeeriTramm]

Is there a way to prefill an attachment? I would love for users to be able to view and update their photo. Thank you!

[Fredjo]

Just great !! it's helping a lot ! THANKS.

[MattGoesRogue]

Brilliant video, thank you ever so much!

[danikadares]

Hi Julian! Thanks for such an informative video! I tested out the email automation and when I received it the personalized link is trailed by the code we entered in the formula. Do you happen to know how to fix this?