Select Page
Auto-Create On2Air Form Embed Codes for Each Record in Your Table in Airtable

Auto-Create On2Air Form Embed Codes for Each Record in Your Table in Airtable

🔴 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’

image
  • Open up the Form Settings and make note of the Form ID
image
  • 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

image
  • 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
image
  • 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.
image
  • 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
image