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.

Use Fillout to update records in Airtable with automatically pre-filled forms

1. Switch your form to update mode

First, choose Airtable on the "Integrations" tab:
notion image
 
Then specify that you want to update the existing 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. That’s it! The result:

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.

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