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
First, choose Airtable on the "Integrations" tab:
Then specify that you want to
updatethe existing 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
formulafield and copy the formula Fillout provides on the integration page.
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-filledfor 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.
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
And then we can display this button in an Airtable interface, for users to easily edit the record