Create a Trigger Action- Zapier
A Trigger is an action you complete in Airtable which initiates a single record or multiple records to be updated or deleted using On2Air. You can then use this Trigger in Zapier to connect with any other software your company uses.
You initiate a Trigger by making a change in your Airtable base table, such as selecting a checkbox, changing a date, changing text, or adding an attachment. This change will update or delete other specified fields in your table.
Learn more about On2Air: Actions
In this article
Before Creating a Trigger
How To Create a Trigger
Trigger Types
Single Record Updated
Multiple Records Updated
Single Record To Be Deleted
Multiple Records To Be Deleted
Trigger Configurations
Enable Trigger
History Log
Configure Your Trigger in Zapier
Before Creating a Trigger
Before using Triggers, we recommend you first:
Connect to Your Airtable Account
Create a Zapier API Key in On2Air
How To Create a Trigger
There are two ways to create a Trigger
From the All Actions page
Click New Action in the top right-hand side of the screen
Select a Trigger type
Click Add Configuration
OR
Click Triggers in the side menu
Click New Trigger
Select Your Trigger Type
Click Add Configuration
Trigger Types
Single Record Updated - Triggers an update when a single Airtable record or a newly created record meets your specified criteria
Multiple Records Updated - Triggers an update of multiple records when any record or newly created records meets your specified criteria. Can be used to Bulk process data.
Single Record To Be Deleted - Triggers a deletion when a single Airtable record or a newly created record meets your specified criteria
Please note, this will NOT trigger when you Delete a Record from Airtable by right-clicking and selecting Delete record. Must be deleted by using a Trigger mode type.
Multiple Records To Be Deleted - - Triggers a deletion of multiple records at once when any record or newly created records meets your specified criteria. Can be used to Bulk process data.
Please note, this will NOT trigger when you Delete a Record from Airtable by right-clicking and selecting Delete record. Must be deleted by using a Trigger mode type.
Trigger Configurations
Single Record Updated
Multiple Records Updated Trigger
Single Record To Be Deleted
Multiple Records To Be Deleted
Airtable Connection
Select your Airtable Connection - Choose the Airtable account you want to use
Airtable Source
Select Your Base - Choose your desired base
Select Your Table - Choose your table
Select Your View - Choose your view (Optional)
Default is all views
Selected Fields - The fields you want returned to your table or to another sequence after trigger process is complete - (Default is All Fields)
Add one or multiple fields
If none selected, all fields will be retrieved
Sort Fields - Sort how the results are ordered
Ascending (ASC) or Descending (DESC)
You can add one or multiple options
You can reorder fields by clicking the bars icon next to the field
Trigger Mode
Trigger Mode Options
Trigger Mode - The mode type for the field in your base being watched for updates, changes, or deletions. Determines how your trigger starts and processes
Options
Checkbox
Field Updated
Date
Formula
Last Modified Time
Mode Types
Checkbox - A checkbox field monitored to initiate the trigger
Mode Configuration (Checkbox)
Checkbox Field - The Airtable checkbox field you want to monitor
Trigger On - Determines if the trigger is initiated when the checkbox field is Checked or Unchecked
Each time the trigger is processed, On2Air automatically reverts your field to its original state
If your trigger is the checkbox field being Checked, once you have Checked the field and the sequence is complete, your field will automatically be reverted back to the Unchecked state
Example: Select the Checkbox in your table to begin the trigger sequence
Field Updated - A specific field monitored for changes in order to update and sync data to a second field
Mode Configuration (Field Updated)
Updated Field - The field being monitored to initiate the trigger
This can be any Airtable field type
If using a Multi-Line Text field, the Comparison Field must also be a Multi-Line Text Field
Currently, cannot be a Rich-Text formatted field (Airtable bug)
Comparison Field - The field being updated/changed once the trigger is processed
Must be an Airtable text field type
If using a Multi-Line Text field in the Updated Field, the Comparison Field must also be Multi-Line Text
Example: Watch Airtable field Updated Field Trigger for changes. Sync Airtable field Updated Field Comparison to display same data as Updated Field Trigger
Date - The specific Date field being monitored for changes in order to update and sync the date to a second Date field type or Text field type
Also works with Formula fields - Be sure your formula contains valid date formatting
Triggers once the date and time specified has passed
Ex: If Date is 8/15/20 11:30AM, it will process AFTER 11:30AM has passed on 8/15/20, even though the fields are out of sync because you changed the date
Mode Configuration (Date)
Date Field - The Date field being monitored to initiate the trigger
Must be an Airtable Date field type
Comparison Field - The Date field type or Text field type being updated/changed once the trigger is processed
Must be an Airtable Date field type or a Text field type
Example: Watch Airtable field Date Trigger for changes. Sync Airtable field Date Comparison to display same date and time as Date Trigger
Formula (Advanced) - Create your own custom formula to initiate a trigger
Mode Configuration (Formula)
Formula - Add your own custom formula
Will trigger every time the formula is TRUE - You need to change the state back to FALSE to ensure it only runs when needed
Last Modified - Watch for a change to a Last Modified Time Airtable field type to initiate a trigger
Last Modified Time field type in Airtable allows you to watch for changes to any field or to a specific field (You must determine this in your Airtable field)
Zapier currently watches and triggers for the last modified timestamp
Mode Configuration (Last Modified)
Last Modified - The Last Modified Time Field in your table you want to monitor and use for updates/changes
Buffer - The amount of time between when the Last Modified Time field changes and when the trigger begins
Useful when typing in a text field and Airtable automatically saves your text which changes the last modified field. The buffer time prevents the trigger from running too quickly.
Options
30 Seconds
1 Minute
2 Minutes
5 Minutes
10 Minutes
30 Minutes
1 Hour
More Options
Last Updated Field (only displays for Updated Triggers, not Deleted Triggers) - A date field in your table to display the most recent timestamp your trigger was processed
This will update with the new timestamp each instance your trigger is processed
Advanced Options
Maximum Records - Choose the maximum records returned and processed per trigger execution
Each time Zapier checks for a change, this determines how many records are processed and returned
Options
ALL (Default)
1
10
25
50
100
200
500
1000
Backfill Fields - Use any other Airtable field from your table in another step in your sequence workflow - (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
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 trigger on (Default 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
Click Save Update Details
Enable Trigger
Once all configurations are set
Toggle Enable (green) to enable your Trigger
Delete Trigger
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 Trigger 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
Click Create Zap
Choose App & Event
Choose App
Search for the On2Air app
Select the On2Air app
Choose Trigger Event
Select Perform On2Air Trigger
Click Continue
Choose Account
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
Customize Trigger
App
Choose Actions
Actions Trigger - Displays a list of the Triggers you have Enabled in On2Air: Actions
Select the Trigger you want to use
You can also click Configure to configure your Trigger in On2Air
Advanced Settings
Trigger Only Once - Set to Yes if you only want to record to trigger 1 time
Response As JSON String - Set to Yes if you want the response as a JSON string instead of an object
Click Continue
Find Data
Click Test Your Trigger to ensure it’s set up correctly
Click Continue
A Trigger is an action you complete in Airtable which initiates a single record or multiple records to be updated or deleted using On2Air. You can then use this Trigger in Zapier to connect with any other software your company uses.
You initiate a Trigger by making a change in your Airtable base table, such as selecting a checkbox, changing a date, changing text, or adding an attachment. This change will update or delete other specified fields in your table.
Learn more about On2Air: Actions
In this article
Before Creating a Trigger
How To Create a Trigger
Trigger Types
Single Record Updated
Multiple Records Updated
Single Record To Be Deleted
Multiple Records To Be Deleted
Trigger Configurations
Enable Trigger
History Log
Configure Your Trigger in Zapier
Before Creating a Trigger
Before using Triggers, we recommend you first:
Connect to Your Airtable Account
Create a Zapier API Key in On2Air
How To Create a Trigger
There are two ways to create a Trigger
From the All Actions page
Click New Action in the top right-hand side of the screen
Select a Trigger type
Click Add Configuration
OR
Click Triggers in the side menu
Click New Trigger
Select Your Trigger Type
Click Add Configuration
Trigger Types
Single Record Updated - Triggers an update when a single Airtable record or a newly created record meets your specified criteria
Multiple Records Updated - Triggers an update of multiple records when any record or newly created records meets your specified criteria. Can be used to Bulk process data.
Single Record To Be Deleted - Triggers a deletion when a single Airtable record or a newly created record meets your specified criteria
Please note, this will NOT trigger when you Delete a Record from Airtable by right-clicking and selecting Delete record. Must be deleted by using a Trigger mode type.
Multiple Records To Be Deleted - - Triggers a deletion of multiple records at once when any record or newly created records meets your specified criteria. Can be used to Bulk process data.
Please note, this will NOT trigger when you Delete a Record from Airtable by right-clicking and selecting Delete record. Must be deleted by using a Trigger mode type.
Trigger Configurations
Single Record Updated
Multiple Records Updated Trigger
Single Record To Be Deleted
Multiple Records To Be Deleted
Airtable Connection
Select your Airtable Connection - Choose the Airtable account you want to use
Airtable Source
Select Your Base - Choose your desired base
Select Your Table - Choose your table
Select Your View - Choose your view (Optional)
Default is all views
Selected Fields - The fields you want returned to your table or to another sequence after trigger process is complete - (Default is All Fields)
Add one or multiple fields
If none selected, all fields will be retrieved
Sort Fields - Sort how the results are ordered
Ascending (ASC) or Descending (DESC)
You can add one or multiple options
You can reorder fields by clicking the bars icon next to the field
Trigger Mode
Trigger Mode Options
Trigger Mode - The mode type for the field in your base being watched for updates, changes, or deletions. Determines how your trigger starts and processes
Options
Checkbox
Field Updated
Date
Formula
Last Modified Time
Mode Types
Checkbox - A checkbox field monitored to initiate the trigger
Mode Configuration (Checkbox)
Checkbox Field - The Airtable checkbox field you want to monitor
Trigger On - Determines if the trigger is initiated when the checkbox field is Checked or Unchecked
Each time the trigger is processed, On2Air automatically reverts your field to its original state
If your trigger is the checkbox field being Checked, once you have Checked the field and the sequence is complete, your field will automatically be reverted back to the Unchecked state
Example: Select the Checkbox in your table to begin the trigger sequence
Field Updated - A specific field monitored for changes in order to update and sync data to a second field
Mode Configuration (Field Updated)
Updated Field - The field being monitored to initiate the trigger
This can be any Airtable field type
If using a Multi-Line Text field, the Comparison Field must also be a Multi-Line Text Field
Currently, cannot be a Rich-Text formatted field (Airtable bug)
Comparison Field - The field being updated/changed once the trigger is processed
Must be an Airtable text field type
If using a Multi-Line Text field in the Updated Field, the Comparison Field must also be Multi-Line Text
Example: Watch Airtable field Updated Field Trigger for changes. Sync Airtable field Updated Field Comparison to display same data as Updated Field Trigger
Date - The specific Date field being monitored for changes in order to update and sync the date to a second Date field type or Text field type
Also works with Formula fields - Be sure your formula contains valid date formatting
Triggers once the date and time specified has passed
Ex: If Date is 8/15/20 11:30AM, it will process AFTER 11:30AM has passed on 8/15/20, even though the fields are out of sync because you changed the date
Mode Configuration (Date)
Date Field - The Date field being monitored to initiate the trigger
Must be an Airtable Date field type
Comparison Field - The Date field type or Text field type being updated/changed once the trigger is processed
Must be an Airtable Date field type or a Text field type
Example: Watch Airtable field Date Trigger for changes. Sync Airtable field Date Comparison to display same date and time as Date Trigger
Formula (Advanced) - Create your own custom formula to initiate a trigger
Mode Configuration (Formula)
Formula - Add your own custom formula
Will trigger every time the formula is TRUE - You need to change the state back to FALSE to ensure it only runs when needed
Last Modified - Watch for a change to a Last Modified Time Airtable field type to initiate a trigger
Last Modified Time field type in Airtable allows you to watch for changes to any field or to a specific field (You must determine this in your Airtable field)
Zapier currently watches and triggers for the last modified timestamp
Mode Configuration (Last Modified)
Last Modified - The Last Modified Time Field in your table you want to monitor and use for updates/changes
Buffer - The amount of time between when the Last Modified Time field changes and when the trigger begins
Useful when typing in a text field and Airtable automatically saves your text which changes the last modified field. The buffer time prevents the trigger from running too quickly.
Options
30 Seconds
1 Minute
2 Minutes
5 Minutes
10 Minutes
30 Minutes
1 Hour
More Options
Last Updated Field (only displays for Updated Triggers, not Deleted Triggers) - A date field in your table to display the most recent timestamp your trigger was processed
This will update with the new timestamp each instance your trigger is processed
Advanced Options
Maximum Records - Choose the maximum records returned and processed per trigger execution
Each time Zapier checks for a change, this determines how many records are processed and returned
Options
ALL (Default)
1
10
25
50
100
200
500
1000
Backfill Fields - Use any other Airtable field from your table in another step in your sequence workflow - (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
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 trigger on (Default 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
Click Save Update Details
Enable Trigger
Once all configurations are set
Toggle Enable (green) to enable your Trigger
Delete Trigger
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 Trigger 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
Click Create Zap
Choose App & Event
Choose App
Search for the On2Air app
Select the On2Air app
Choose Trigger Event
Select Perform On2Air Trigger
Click Continue
Choose Account
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
Customize Trigger
App
Choose Actions
Actions Trigger - Displays a list of the Triggers you have Enabled in On2Air: Actions
Select the Trigger you want to use
You can also click Configure to configure your Trigger in On2Air
Advanced Settings
Trigger Only Once - Set to Yes if you only want to record to trigger 1 time
Response As JSON String - Set to Yes if you want the response as a JSON string instead of an object
Click Continue
Find Data
Click Test Your Trigger to ensure it’s set up correctly
Click Continue
Published on: 05 / 28 / 2020