Update existing Airtable records with a form

Make a form that edits existing records from Airtable, and pre-fills fields with data from the record.

Tutorial video

Check out Gareth’s tutorial on using Fillout to update existing Airtable records.
Video preview
 

1. Switch your form to update mode

First, choose Airtable on the Integrations tab.
notion image
 
Then specify that you want to Update record.
notion image
 

2. Use a formula to specify the record to update

You'll now get a formula that defines a unique link for every record in your table.
Create a new formula field and copy the formula Fillout provides on the integration page.
notion image
 

3. Preview your form

That's it! Click Finish setup. Try out your form in Preview mode, or click one of your unique links to update a record after you’ve published your form!
 
Your form is automatically pre-filled for whichever record it is updating.
Note: selecting the record to update is provided as a convenience while in “preview” mode.
Note: selecting the record to update is provided as a convenience while in “preview” mode.
 
📝
Note: If you don’t provide an id in the unique URL, the form will create a new record instead.
 

Let users choose a record to update

Use this approach if you prefer to let users choose (in Fillout) which record they’d like to update.

Advanced next steps (optional)

You can use update forms in combination with products like Airtable interfaces, Softr, or Stacker. For example, instead of adding a formula in Step 2 above, we could have added a Button field:
notion image
 
And then we can display this button in an Airtable interface, for users to easily edit the record.
 
notion image
 

Airtable specific guides

Create new linked records in an Airtable form
🗂️
How to select and filter Airtable linked records in a dropdown
How to create an Airtable form
How to create an Airtable form
✒️
Add signatures to Airtable with a form
🗄️
Working with linked record pickers
🚫
Prevent duplicate submissions in Airtable
Create multiple Airtable records with a form
Create multiple Airtable records with a form