With this option, you can use your form to both Create or Update Airtable Records.
Update records
This will show you how to Update single records
- Build your form with the fields you want on your form
- Click Share Form
- Copy the URL - the value after form/ is your form ID
- Add a Formula Field in your Airtable base
- Add this formula, replacing the FORM ID with your On2Air Form ID
"https://on2air.com/form/FORMID/" & RECORD_ID()
- You’ll then see a dynamic URL created for every record in your table
- You can use this URL to share with others to update a record using the fields you added to your form
Create Records
- Build your form with the fields you want on your form
- Click Share Form
- Copy the URL or share it with others to create new records
Create Configuration
Set up the configuration for allowing a form user to create new Airtable records
Defaults Record ID - If you want to add default values to every new form submission, you can enter the Record ID of an Airtable Record that contains the default values. Any new form submissions will contain the values from the record you enter here.
How to View Record IDs in Airtable
Use Dynamic Defaults Record - Enable If you want to add default values to new form submissions based on what the form user chooses, you can enter multiple Record IDs of Airtable Records with your default values. New form submissions will contain the default values depending on what the form user chooses and which Record ID you map as the default.
Default Record URL Prefill Key - Enter in the default Record URL Prefill Key
Example: defaults (URL is www.yoururl.com?defaults=<recid>)
URL Prefill Value is Record ID - Enable if the URL Param Value is the Airtable Record ID
Default Param Field
Case Sensitive Match - Enable if the Default Param Field needs to match exactly, including upper case, lower case, or other case
Related: How to Add Default Values to Your Form Submissions
Update Configuration
Set up the configuration for how existing records are matched in Airtable
How to Perform Match on Record to Update
Choose how the updated record will be matched in Airtable
- Use Record ID in URL Path
- Match with URL Param
Use Record ID in URL Path
Record Not Found/Invalid Message
- Use this to display a message if the record is not found or is invalid. Click the icon to open the message box. You can use the formatting options in the message box, Markdown, or WYSIWYG.
Match with URL Prefill
Update Match Field Prefill Key
Update Match Field
Case Sensitive
- Enable if Match Field needs to match exactly, including upper case, lower case, or other case
Record Not Found/Invalid Message
- Use this to display a message if the record is not found or is invalid. Click the icon to open the message box. You can use the formatting options in the message box, Markdown, or WYSIWYG.