🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com
You can automatically generate On2Air Forms embed codes for each record in your table. This is useful to allow each customer, client, or form user to update or view their own record data on a specific page.
In your form, ensure your form type is either ‘Update Existing Records’ or ‘Create or Update Existing Records’
- Open up the Form Settings and make note of the Form ID
- Open your Airtable base to the corresponding Table used as your form source
Example: My form table is Clients, so I’m in the Clients table
- Create a Formula field and paste the following formula. Where it says YOUR_FORM_ID, replace with your unique Form ID.
This formula will substitute the Record ID placeholder in the URL for the actual Record ID in your Airtable record
SUBSTITUTE('<iframe src="https://on2air.com/form/YOUR_FORM_ID/<RECORD_ID_HERE>" width="100%" height="500px" />',"<RECORD_ID_HERE>",RECORD_ID())
- Your Formula will now look like this. Click Save
- You should now see an iFrame embed code for each individual record in your table. You can copy this iFrame code into individual pages on your website and it will display the form with their specific Airtable data.
- You can further customize the size of your Embedded forms by editing the Formula and changing the width and height. Once you edit it in the Formula, it will change for every record. Once you paste the code into your website, you will need to manually make any size adjustments in that specific embed code.
- Website example for single record embedded