miniExtensions Form (recommended): A powerful Airtable form alternative with 100+ features, including record editing. This is a far more versatile option, so it's recommended for almost all use cases!

Update records using an existing Airtable form: You can use our Update Records with Airtable Form automation to allow record updates with existing Airtable forms. Only use this option if rebuilding your form as a miniExtensions Form is not an option. This workaround relies on creating temporary records, that are then automatically deleted, so comes with a few caveats:

You can also add a lookup page to your Airtable form, by turning on that option in the automation's configuration. This way you can allow users to look up the appropriate record to edit based on fields defined in the configuration. When a matching record is found, it will be loaded into the Airtable form. This functionality can also be used to add functionality similar to Save & Continue mode to an Airtable form. A user could look up their record, fill out part of the form and submit. They could then repeat this process at a later date until the form is fully filled out. The miniExtensions Form is still the recommended option in this case, but this automation provides an alternative for those that do not wish to rebuild their existing Airtable form.

Create the Update Records with Airtable Form automation and select the base and table used by your existing Airtable form.

In Airtable, add a single line text field to hold the original record ID, and include that field in your Airtable form. Use a writable text field, not a RECORD_ID() formula field. The generated update link fills and hides this field for the user.

Under Setup, paste your published Airtable form link into Airtable Form URL. Set Record ID Field to the text field you added.

Under Airtable Form Fields, select the editable fields from that form that should be prefilled and updated.

Under URL, copy Airtable Form Redirect URL exactly, including {record_id}, and use it as the Airtable form’s after-submission redirect. For the Airtable controls, follow only the Setting up your Airtable Form section of our integration guide. Use this automation’s redirect URL, not the miniExtensions Form URL shown in that guide’s example.

With Enable Lookup Mode off, copy the formula under Record Update URL into a new Airtable formula field. Open the generated link for the record you want to edit; do not start with the ordinary Airtable form link.

Test with a disposable record: open its generated link, change a value, submit the form and let the redirect finish. Check that the original record was updated and the temporary submission record was removed before sharing links with users.