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.
1. Switch your form to update mode
First, choose
Airtable
on the Integrations tab.Then specify that you want to
Update record
.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.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: 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:And then we can display this button in an Airtable interface, for users to easily edit the record.