This extension generates a unique URL for every record in your table. When one of those links is clicked, it’ll open an Airtable Form that’s prefilled with the record data. The user can then modify/update whatever they like. When they click submit, that record on Airtable will get instantly updated (and the submitted record gets deleted). It all happens behind the scenes automatically without leaving a trace of the form submissions.
💡This extension is ideal if you need some people to update records in your table, without giving them access to your base.
- Can have up to 10 forms (could be in different tables/bases).
- Can limit which fields can be edited.
- Fields are pre-populated with the existing data before editing.
- Records are updated instantly after form submission.
- Doesn’t require other 3rd party integrations (e.g. Zapier/Integromat)
- Form requires minimal setup (no need to setup another table nor mapping multiple fields/select options)
- Supports limiting linked record selection to a view.
- Ability to redirect users to a custom page after record is updated. (e.g. your website) 🆕
- Unlimited records updates.
How to Setup
- Attachments: the extension allows adding new attachments to a field, but doesn’t allow removing existing ones.
- Auto-number: the extension requires creating a temporary record, which would effect the auto-number field’s sequential order. So if your workflow relies on it, our other extension ‘Single Record Editor‘ would be a better option for you.
If you’re looking for a similar extension that does not require a PRO Airtable account, see our other extension.
After I submit the form a new record is created, but the original one is not updated!
1. The form redirect URL is incorrect. Double check it.
2. The ‘Record to update’ field has limited field permissions. Make sure to keep it ‘Editors and up’.
3. The ‘Record to update’ field is not included in the form or hidden with “Conditional form fields” feature. Make sure it’s always visible in order for it to be pre-filled.
I’m being taken to the wrong form. What’s going on?
All you need is to double check:
1. The form URL in the extension settings page.
2. The formula field in the table itself.
3. The formula redirect URL.
What most likely is happening is that one of these three things is incorrect.
Some field names are missing from the imported list. How can I add them?
Field names are automatically detected when you run the script. However, if a field is added after the script run, it must be ran again in order to show up in miniExtensions.
After I submit the form and get redirected, I get an error!
Make sure all field names in your extension settings match the ones in your form exactly. Probably one is missing.
The record is being updated correctly, but in the same time some other fields that are not in the form are being deleted!
Make sure all field names in your extension settings match the ones in your form exactly. If there are fields that are included in the settings, but are not in the form, their values will then be deleted. Remove them from miniExtensions settings.
When some multi-select options are selected in form, they don’t get saved in Airtable, why?
Because the values have commas in them. You have to remove the commas from those option values. Commas are not supported in multi-select field options.
I see duplicate records and older ones are not being removed, why?
There are two ways that this can happen: a user did not wait for the redirect to happen after the Airtable form, or an error occurred during the redirect. In the second case, the error would be clearly shown to the user, so they would know that the record was not updated. However, the first case is more likely what’s going on.
Unfortunately, Airtable takes a few seconds before redirecting, and if someone closes the page while that’s happening, then the user never actually makes it to miniExtensions, so we wouldn’t know that a record was just created.
After I submit the form, I’m getting this error ‘You are not authorized to perform this operation’.
2 possible reasons:
1. You got an incorrect API key for your Airtable account. Try to update it please. You probably clicked on ‘Re-generate API key’ in Airtable account page by mistake.
2. Check form field permissions. They can’t have any restrictions.