Airtable's native form does not have record editing capabilities. We have two ways of providing this functionality:
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:
Temporary records may trigger Airtable automations
Attachment fields will always appear empty on the form when loaded, even when they already contain files in the original record. Any attachment uploaded through this method will be added to the existing attachments.
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.