Use Your Form to ‘Update Existing Airtable Records Only’

🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

You can use your form to ‘Update Existing Records Only’ - This form will not allow a user to Create new records

💡

Other Form Options: Use Your Form to ‘Create OR Update Airtable Records’ Use Your Form to ‘Create New Records Only’

• Update Configuration
• 🎥How to Update Airtable Records Video Tutorial
• Update Form Setup
• Update Records with a URL or Button from Your Airtable Base

Update Configuration

🎥How to Update Airtable Records Video Tutorial

Update Form Setup

• In the Record Create/Edit Options, set your form to either Update Existing Records Only or Create or Update Records

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 - DEFAULT and Recommended
• Match with URL Prefill

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.

Update Records with a URL or Button from Your Airtable Base

This will show you how to Update records in Airtable with On2Air Forms and a Formula or Button field in your Airtable base.

• Build your form with the fields you want on your form

• Click Share Form

• Choose the Update option and choose Airtable Link/Button

• Copy the Formula
• Add a Button or Formula field to your table in Airtable that’s the same as the Form source
• Paste the formula into your Airtable button or formula field

• If you used a Button field, you’ll see a dynamic button with the specific record URL created for every record in your table

• If you used a Formula field, you’ll see a list of dynamic URLs for each record

• When you click the Button or URL in a record, you’ll see the entire record with all the data (depending on your Permissions and Field Display Mode)

• You can use this URL to share with others to update a record or you can use internally to quickly update records