Choose a record to update
Let users choose the record they want to update in Fillout and update it with a custom form.
Overview
Fillout lets you create update forms to update existing records in Airtable, SmartSuite, Notion and other databases. By default, however, Fillout requires you to pass in the record ID to update in the URL. With the approach described below, you can have your users
choose which record they would like to update
.How it works
1. Create an “update” form
Follow the steps here to create an “update” form. Make sure to select
Update record
on the integration and to publish the form.![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fhttps%253A%252F%252Fprod-files-secure.s3.us-west-2.amazonaws.com%252F2a7ed980-5add-4b51-82ab-889415f57134%252F98d5cdb1-4c69-452a-b9b6-0313379c1a3d%252FUntitled.png%3Ftable%3Dblock%26id%3De515a496-0a6f-4f7f-b30c-b8270562ab6b%26cache%3Dv2&w=3840&q=75)
2. Create another form to choose the record
Create another form. This is the main form you will send your respondents to so that they can choose the record to update.
In the form, add a linked record picker that links to the Airtable you would like to update. For example, if your first form updates a Product Inventory table, create this form tied to a different table that has a linked relation with Product Inventory. In this form, add a record picker to choose from those products:
![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fhttps%253A%252F%252Fprod-files-secure.s3.us-west-2.amazonaws.com%252F2a7ed980-5add-4b51-82ab-889415f57134%252F93477e73-6ef1-409b-bc9a-8ef251bb7844%252FUntitled.png%3Ftable%3Dblock%26id%3D9a1a6e0d-85df-40eb-ba25-05f39506d9da%26cache%3Dv2&w=3840&q=75)
3. Connect the forms together
Navigate to the ending page of your record chooser form and set your update form as the New form to redirect to.
![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fattachment%253Aaf85992c-dd70-4e1b-bd5d-7f61497755ab%253AScreenshot_2025-02-11_at_4.58.47_PM.png%3Ftable%3Dblock%26id%3D1970ee47-667b-80c6-a155-de46b6d49c69%26cache%3Dv2&w=3840&q=75)
Finally, pass the record ID to update the update form. Click
Set URL parameters
to choose the ID
parameter of your update form and map it to your record picker field’s Record ID
.![notion image](/_next/image?url=https%3A%2F%2Fwww.notion.so%2Fimage%2Fattachment%253A374e7fb2-ffd8-412f-b78c-f36f23c3cbde%253AScreenshot_2025-02-11_at_5.44.54_PM.png%3Ftable%3Dblock%26id%3D1970ee47-667b-802c-9250-c4b8b020ea5a%26cache%3Dv2&w=3840&q=75)
Tip: If you don’t want to create records in your first form, you can always set a condition for when the integration is run (set a condition that is never true).
That’s it! You can now send respondents to your picker form to choose a record. Once they submit that form, they’ll be automatically redirected to the update form, which will be pre-filled with the record they chose.