Create an Update - Zapier
Action Updates allows you to update, create, or delete single or multiple Airtable records. You can use Zapier to push data into those fields from another app (either the On2Air app or any third-party app). An Update is used after the first step in your zap.
Learn more about On2Air: Actions
In this article
Before Creating an Update
How To Create an Update
Update Types
Update (Insert) Single Record
Create New Single Record
Delete Single Record
Update (Insert) Multiple Records
Delete Multiple Records
Create New Multiple Records
Update Configurations
Enable Update
History Log
Configure Your Update in Zapier
Before Creating an Update
Before using Updates, we recommend you first:
Connect to Your Airtable Account
Create a Zapier API Key in On2Air
How To Create an Update
There are two ways to create an Update
From the All Actions page
Click New Action in the top right-hand side of the screen
Select an Updates Type
Click Add Configuration
OR
Click Updates in the side menu
Click New Update
Select Your Updates Type
Click Add Configuration
Update Types
Update (Insert) Single Record - Performs an update to a single Airtable record or creates a new record, if desired
Create New Single Record - Creates a new single record (No Updates)
Delete Single Record - Automatically delete first matching record and return the record when criteria is met
Update (Insert) Multiple Records - Performs a bulk update to Airtable records or create new records, if desired
Delete Multiple Records - Automatically delete any matching records and return them in bulk when criteria is met
Create New Multiple Records - Creates multiple new records (No Updates)
Update Configurations
Airtable Connection
Select your Airtable Connection - Choose your Airtable account
Configuration Details
Select Your Base - Choose your desired base
Select Your Table - Choose your table
Lookup Field (Displays in Update (Insert) Updates and Delete Updates) - Field used for the comparison match and lookup
(Advanced) You can leave blank if you plan to use the Record ID
Field Values (Displays for Update (Insert) Updates and Create New Updates) - Fields made available to update
Chose one or more fields
Default Create Value (Displays for Update (Insert) Updates and Create New Updates) - Enter a default name to be used when creating a new record in your field
Useful if you don’t want to have blank fields when creating new records
Last Runtime (Displays in Create New Updates and Update (Insert) Updates) - A date field in your table to display the most recent timestamp your update was processed
This will update with the new timestamp each instance your update is processed
Advanced Options
Matching Style (Displays in Delete Updates) - Determines how your Lookup Field matches updates
Options
Exact Match - Must be an exact match to update and delete (Default)
Contains -. Contains any value from the field
Does Not Contain - Does not contain any value
Does Not Match - Does not match any value
Case Sensitive (Displays in Delete Updates and_** Update/Insert Updates) - Determines whether matches should be case sensitive (On by Default)
Backfill Fields - Use any other Airtable field from your table in another step in your sequence workflow whether they contain a value or not - (Default and Recommended is On/Green)
This setting is available due to the Airtable API not returning the field data
Flatten Output - Remove extraneous data from certain Airtable fields - (Default and Recommended is On/Green)
When returning data, the Airtable API attaches additional, unnecessary information to some fields, such as attachments and collaborator
Retrieve Full Data - Retrieve all data from update and return for use in other fields or steps (On by Default)
Create Unfound Records (Displays in Update (Insert) Updates) - If looking for a match to update and no match is found, insert data as a new record (On by Default)
Lock Fields on Name - Uses the actual text Name of the field you chose in Mode Configuration instead of the Unique field ID to watch for changes to update on (Default and Recommended is Off - Default watches for the Unique field ID)
Name is useful if you want to create a duplicate field and watch the name instead of the ID
Attachment Mode (Displays in Update (Insert) Updates and Create New Updates)
Append - Add attachment as new with current attachments
Overwrite - Overwrite current attachment with new attachment
Click Save Update Details
Enable Update
Once all configurations are set
Toggle Enable (green) to enable your Update
Delete Update
Click Delete Trigger
Click Yes, I want to delete this action
WARNING: This action cannot be undone
History Log
History Log Coming Soon!
Configure Your Update in Zapier
Accept App Invitation
Once you sign up for On2Air: Actions, you will receive a link from the Openside team to add the On2Air app to your Zapier account
Click the link
An invitation screen will be displayed
Select Accept Invite and Build a Zap
Create A Zap
Before using Updates, you must have a previous step in your Zap. In this example, we have a Trigger from On2Air as the first step.
Click the + icon below the first step in your Zap
Choose App & Event
Choose App
Search for the On2Air app
(In our example, it’s already chosen due to our first step)
Select the On2Air app
Choose Action Event
Select Perform On2Air Update
Click Continue
Choose Account (Not Connected to On2Air)
If you have not connected your On2Air account to Zapier, follow the next steps. If you have already connected to On2Air, skip to the Customize Update step.
Click Sign in to On2Air
Another window will open displaying Allow Zapier to access your On2Air Account
You will need to enter the Zapier API Key you created earlier in the field
To view your API Key or to create a Zapier API Key, click Create/Select an API Key to your On2Air account here
Copy your API Key
Paste your API Key in the field
Click Yes, continue
Your On2Air account is now connected to Zapier
Click Continue
Choose Account (Already Connected to On2Air)
Choose your On2Air account
Click Continue
Customize Update
App
Choose Actions
Actions Update - Displays a list of the Updates you have Enabled in On2Air: Actions
Select the Action you want to use
You can also click Configure to configure your Update in On2Air
Lookups
Lookup Record by Field - Choose the field you want to use as the lookup field for the update
Fields
Update Fields - Add the data you want sent back to your records and updated in Airtable
You configured these fields as options in the Field Values section in On2Air
Advanced Settings
Response As JSON String - Set to Yes if you want the response as a JSON string instead of an object
Click Continue
Send Data
Click Test & Continue
Click the Send Data dropdown to ensure it’s set up correctly
Click Done Editing
Here’s the final result in Airtable
Action Updates allows you to update, create, or delete single or multiple Airtable records. You can use Zapier to push data into those fields from another app (either the On2Air app or any third-party app). An Update is used after the first step in your zap.
Learn more about On2Air: Actions
In this article
Before Creating an Update
How To Create an Update
Update Types
Update (Insert) Single Record
Create New Single Record
Delete Single Record
Update (Insert) Multiple Records
Delete Multiple Records
Create New Multiple Records
Update Configurations
Enable Update
History Log
Configure Your Update in Zapier
Before Creating an Update
Before using Updates, we recommend you first:
Connect to Your Airtable Account
Create a Zapier API Key in On2Air
How To Create an Update
There are two ways to create an Update
From the All Actions page
Click New Action in the top right-hand side of the screen
Select an Updates Type
Click Add Configuration
OR
Click Updates in the side menu
Click New Update
Select Your Updates Type
Click Add Configuration
Update Types
Update (Insert) Single Record - Performs an update to a single Airtable record or creates a new record, if desired
Create New Single Record - Creates a new single record (No Updates)
Delete Single Record - Automatically delete first matching record and return the record when criteria is met
Update (Insert) Multiple Records - Performs a bulk update to Airtable records or create new records, if desired
Delete Multiple Records - Automatically delete any matching records and return them in bulk when criteria is met
Create New Multiple Records - Creates multiple new records (No Updates)
Update Configurations
Airtable Connection
Select your Airtable Connection - Choose your Airtable account
Configuration Details
Select Your Base - Choose your desired base
Select Your Table - Choose your table
Lookup Field (Displays in Update (Insert) Updates and Delete Updates) - Field used for the comparison match and lookup
(Advanced) You can leave blank if you plan to use the Record ID
Field Values (Displays for Update (Insert) Updates and Create New Updates) - Fields made available to update
Chose one or more fields
Default Create Value (Displays for Update (Insert) Updates and Create New Updates) - Enter a default name to be used when creating a new record in your field
Useful if you don’t want to have blank fields when creating new records
Last Runtime (Displays in Create New Updates and Update (Insert) Updates) - A date field in your table to display the most recent timestamp your update was processed
This will update with the new timestamp each instance your update is processed
Advanced Options
Matching Style (Displays in Delete Updates) - Determines how your Lookup Field matches updates
Options
Exact Match - Must be an exact match to update and delete (Default)
Contains -. Contains any value from the field
Does Not Contain - Does not contain any value
Does Not Match - Does not match any value
Case Sensitive (Displays in Delete Updates and_** Update/Insert Updates) - Determines whether matches should be case sensitive (On by Default)
Backfill Fields - Use any other Airtable field from your table in another step in your sequence workflow whether they contain a value or not - (Default and Recommended is On/Green)
This setting is available due to the Airtable API not returning the field data
Flatten Output - Remove extraneous data from certain Airtable fields - (Default and Recommended is On/Green)
When returning data, the Airtable API attaches additional, unnecessary information to some fields, such as attachments and collaborator
Retrieve Full Data - Retrieve all data from update and return for use in other fields or steps (On by Default)
Create Unfound Records (Displays in Update (Insert) Updates) - If looking for a match to update and no match is found, insert data as a new record (On by Default)
Lock Fields on Name - Uses the actual text Name of the field you chose in Mode Configuration instead of the Unique field ID to watch for changes to update on (Default and Recommended is Off - Default watches for the Unique field ID)
Name is useful if you want to create a duplicate field and watch the name instead of the ID
Attachment Mode (Displays in Update (Insert) Updates and Create New Updates)
Append - Add attachment as new with current attachments
Overwrite - Overwrite current attachment with new attachment
Click Save Update Details
Enable Update
Once all configurations are set
Toggle Enable (green) to enable your Update
Delete Update
Click Delete Trigger
Click Yes, I want to delete this action
WARNING: This action cannot be undone
History Log
History Log Coming Soon!
Configure Your Update in Zapier
Accept App Invitation
Once you sign up for On2Air: Actions, you will receive a link from the Openside team to add the On2Air app to your Zapier account
Click the link
An invitation screen will be displayed
Select Accept Invite and Build a Zap
Create A Zap
Before using Updates, you must have a previous step in your Zap. In this example, we have a Trigger from On2Air as the first step.
Click the + icon below the first step in your Zap
Choose App & Event
Choose App
Search for the On2Air app
(In our example, it’s already chosen due to our first step)
Select the On2Air app
Choose Action Event
Select Perform On2Air Update
Click Continue
Choose Account (Not Connected to On2Air)
If you have not connected your On2Air account to Zapier, follow the next steps. If you have already connected to On2Air, skip to the Customize Update step.
Click Sign in to On2Air
Another window will open displaying Allow Zapier to access your On2Air Account
You will need to enter the Zapier API Key you created earlier in the field
To view your API Key or to create a Zapier API Key, click Create/Select an API Key to your On2Air account here
Copy your API Key
Paste your API Key in the field
Click Yes, continue
Your On2Air account is now connected to Zapier
Click Continue
Choose Account (Already Connected to On2Air)
Choose your On2Air account
Click Continue
Customize Update
App
Choose Actions
Actions Update - Displays a list of the Updates you have Enabled in On2Air: Actions
Select the Action you want to use
You can also click Configure to configure your Update in On2Air
Lookups
Lookup Record by Field - Choose the field you want to use as the lookup field for the update
Fields
Update Fields - Add the data you want sent back to your records and updated in Airtable
You configured these fields as options in the Field Values section in On2Air
Advanced Settings
Response As JSON String - Set to Yes if you want the response as a JSON string instead of an object
Click Continue
Send Data
Click Test & Continue
Click the Send Data dropdown to ensure it’s set up correctly
Click Done Editing
Here’s the final result in Airtable
Published on: 05 / 28 / 2020