This extension allows you to create a form for your users to edit existing records in Airtable. You would select the fields that you’d like to be included in the form. The extension will then generate a unique URL for every record in your table using a formula field. You can share those URLs with anyone. When a URL is clicked, it will load your form with all the selected fields pre-filled already. The user would be able to edit whatever they want. Once they hit save, the record would be instantly updated on Airtable.
The extension allows you to do almost anything that you can do with Airtable Form, plus many extra features. Our goal is to add every possible feature in one powerful, yet easy to use tool. If you are looking for a specific feature to be added, reach out to us!
Demo
This is a sample form as an example. It will open in a new tab.
💡The form can also be embedded inside a webpage!
Overall Features
- Multi-purpose: updating existing records and creating new ones.
- No limits: unlimited form submissions/updates.
- Multiple Forms: you can create many different forms.
- Disable Editing: lock some fields to be read-only or “disabled”.
- Conditional Fields: show some fields only when certain requirements are met.
- Prefill Hidden Fields: form can be pre-filled using
prefill_parameters (including hidden fields!) - Duplicate Prevention: you can prevent duplicate records with the same value.
- Image option: you can add an image in any field.
- Custom Styling: an option to customize cover image, logo, colors of backgrounds, borders, buttons..etc.
- Custom Confirmation Page: choose a custom success message (thank you screen) or a redirect URL on completion.
- Create another record: after form submission, you have the option to add another record from scratch or make another copy of the previous record.
- User Identification: an option to collect the user’s location and IP address.
- CAPTCHA: human validation to protect your form against bots. 🆕
- Password Protection: forms can optionally be password-protected.
- Stripe Checkout: collect payments with Stripe! 🆕
- White-labeled: no miniExtensions branding.
- Full Support: priority live chat support.
Field Specific Features
- Field Type Support: all field types are supported.
- Single line text: optional character limit.
- Long text: optional character limit.
- Email field: input format validation.
- Number field: input format validation.
- URL field: input format validation.
- Date field: an option to be auto-filled with today’s date by default.
- Linked Record: add new linked records.
- Linked Record: the ability to add/edit/preview linked records with details (line items). 🆕
- Linked Record: add linked records to a form by scanning a barcode. 🆕
- Linked Record: hide existing linked records.
- Lookup: show lookup fields.
- Barcode: scan barcodes (and QR codes).
- Attachment: add signatures.
- Attachment: the ability to annotate images.
- Formula: calculation inside the form.
If you click on the sample view below, you’ll see the table that’s used for the demo above.
once the form is created, can it be embedded into a website?
Yes, you can embed the form on your own website.
Is there a way to make a form that pulls fields from multiple tables?
It is not possible to add fields from another table. You can however use lookup fields. This allows you to show information on a linked record that is in a different table.
Is there a way to automatically record who is filling the form?
If you’re trying to identify the person who submitted the form, we have an extension that allows you to create a login page for your form. That way you can track who exactly made the submission.
Where can I find documentation for additional styling in CSS?
Adding custom styling in CSS is not supported unfortunately. Please let us know if there is any specific element that you would like to customize and our team will see if it’s possible to add options to control it.
The display of a date field doesn’t match the formatting in Airtable. In Airtable it is “European” but in the miniExtensions form it is MM-DD-YYYY.
That would change the date formatting on Date fields to DD/MM/YYYY rather than MM/DD/YYYY. You need to change the field settings in Airtable. Select the European format. If you had just changed the field format, you would need to re-run the sync script again in order to see the updated date format.
I want a simple way for our team to update existing records without having to use the grid view of contacts. I was expecting to have a form that you could look up the contact by Client Name and then add/update fields.
The form doesn’t work that way out of the box. What you want is this extension.
I want to use this to send to an Airtable database of students email addresses to ask them if they have received a university interview. Is it possible to have a unique form for each person so pre-filled with their name? The problem I’ve had in the past with a normal form is that we get multiple entries and the responses aren’t hooked to the actual database so I can’t follow up with those who haven’t replied yet.
Our form supports editing records. That’s exactly what you need.
How many of those forms can I have per base and per table?
There is no limit on how many forms you can have.
Can you help with how to use this extension to update existing records?
If you would like to update existing records with our miniExtensions form, you would need to add the formula field to generate the editing URLs. Please watch the video that we have. It shows you step-by-step of how to set this up.
Is it possible after the submit to reopen the same form?
To redirect the user back to the same form, select “success message” for “Action After Save”, and then enable “Redirect to New Form in 5 Seconds”
We have a WP website and we want to autofill the logged-in user data when they click on the form link.
Our form does support prefilling data. What you would need to do is to pass the user parameters to the form URL. And that’s something you would have to figure out in WordPress itself.
I get this error message: “You are not authorized to perform this operation”. How do I resolve this?
There are a few possible reasons for getting this error:
Do the form users need to have editing access in Airtable in order to save changes?
No, miniExtensions users don’t need to have accounts or any access to your Airtable.
I’d like to prefill multiple fields. What is the syntax?
The syntax is the same one that is used in Airtable Form. So for example you would have to repeat the word ‘prefill’ in every parameter.
Can I create a form that includes fields from several tables in the same base?
Yes, for more for information about including fields from different tables in your form, please check out this page.
I was hoping to embed this on my site, but it won’t allow javascript. Any way to get around this?
You can use some website like this one that allows you to generate a standard iframe code: https://iframe-generators.com
My embedded form is not showing me the barcode scanner. How can I fix this?
I’m getting an error that says: “You should provide a valid api key to perform this operation”. How can I fix this?
Go to airtable.com/account to find your Airtable API key then paste that key in the “Airtable User API Key” field on the extension page.
Can I use my custom domain for the form?
It’s not currently possible to set up a custom domain for our extensions, but we made them in a way so that they’re easy to embed in any webpage.
Is there a way to allow users to replace a file after submitting a form?
You can allow people to update their record by either sharing with them a form editing URL or allowing them to login into a portal.
How do they access the form if they didn’t get a confirmation email?
If you would like to send people a confirmation email, you would have to do it with another tool like Airtable automations or Zapier. We don’t offer any solution for sending emails unfortunately. Another alternative would be to ask people to login into a “miniExtensions portal” to update their answers.
Is there a way to create a form where half the answers go to one table and the other half go to another table in the same base?
Yes, our form has the ability to create linked records inside the form. These records could be in different tables. You can find more information about this feature here.
Is it possible to create a record with a form and after submitted redirect to a nice (automatic) unique record page of that same record? which combination of extensions should I use for this? I’m lost with so many options, I’ve checked and checked but none seem to match this behavior.
Yes, you would need to set up this extension. Then you would need to redirect the form to the formula field that contains the record preview URL.