Select Page
Help Center
On2Air Actions
On2Air Actions

On2Air Actions

On2Air: Actions is an Airtable automation and workflow tool with pre-made functions to connect your Airtable data to other Airtable bases and with over 2,500 software tools used in your business. Functions such as a document generator, financial calculations, default values, bulk modify records, same table backlinks, find duplicates, and many more!

>
On2Air Actions
On2Air Actions
 - On2Air Actions is currently closed to new registrations

Function - Arrays
Function - Arrays
‣
Array Functions Available
  • Extract/Convert to String - Extract data from Attachment, Collaborator, or Button fields to store info into separate text fields
  • Items in One List But Not in Others - Extract values from one field that are not found in multiple other fields and add it to another field. This is useful for searching fields and finding any values that are not present and adding it to another field.
  • Unique Arrays - Search 1 or multiple fields for unique data and store the unique values in another field. Useful for filtering out duplicates.
  • Combine Arrays - Store data from multiple fields into a single field. Some duplicates may be in final results. Use the Unique Arrays function if don't want duplicates in your output.
  • Select Random Item(s) - Select a random count of items from all fields provided
  • Slice a subset from the array - Extract a subset of data from an range of data to store separately and add to a different field
  • Reverse Array - Reverse the order of your field data and store in another field
  • Sort Arrays - Sort the array (range of data) and store newly sorted data in another field
  • Count Items - Determine the count of all items across all fields. You can store the data in a text or number field.
  • Extract/Convert to String - Extract data from Attachment, Collaborator, or Button fields to store info into separate text fields
  • Items in One List But Not in Others - Extract values from one field that are not found in multiple other fields and add it to another field. This is useful for searching fields and finding any values that are not present and adding it to another field.
  • Unique Arrays - Search 1 or multiple fields for unique data and store the unique values in another field. Useful for filtering out duplicates.
  • Combine Arrays - Store data from multiple fields into a single field. Some duplicates may be in final results. Use the Unique Arrays function if don't want duplicates in your output.
  • Select Random Item(s) - Select a random count of items from all fields provided
  • Slice a subset from the array - Extract a subset of data from an range of data to store separately and add to a different field
  • Reverse Array - Reverse the order of your field data and store in another field
  • Sort Arrays - Sort the array (range of data) and store newly sorted data in another field
  • Count Items - Determine the count of all items across all fields. You can store the data in a text or number field.
Function - Attachments
Function - Attachments
‣
Attachment Functions Available
  • Convert URLs to Attachments - Convert URL to an attachment and add to an Attachment field
  • Extract URLs from Attachments - Extract full URLs from attachments and add the URL to another field
  • Calculate Filesize Sum - Calculate the total file size of all attachments from a single Attachment field
Function - Math
Function - Math
‣
Math Functions Available

Function - Finance
Function - Finance
‣
Finance Functions Available

Core Actions

Core Action - Create a Trigger
Core Action - Create a Trigger
Core Action - Create an Update Action
Core Action - Create an Update Action
Core Action - Create a Search Action
Core Action - Create a Search Action

Template Guides for Google Functions

Google Docs Function - Template Guide
Google Docs Function - Template Guide
Google Sheets Function - Template Guide
Google Sheets Function - Template Guide
Google Slides Function - Template Guide
Google Slides Function - Template Guide
Pre-Made Templates
Pre-Made Templates
On2Air Documents vs. Airtable Documents
On2Air Documents vs. Airtable Documents

Add Multiple Records to a Document or Creating Multi-Page Documents
Add Multiple Records to a Document or Creating Multi-Page Documents

Additional

Zapier Bulk Items Work Around
Zapier Bulk Items Work Around
How to Transfer from the Legacy On2Air: Actions to the New On2Air: Actions
How to Transfer from the Legacy On2Air: Actions to the New On2Air: Actions
FAQ: On2Air Actions
FAQ: On2Air Actions

Have a Feature Request or Feedback?

Need to Chat?

Chat with us. If we’re online, we’ll get back to you as soon as possible.

Leave Video Feedback?

Need to show an issue or question with us? Video is a great way to provide useful feedback

Want a Demo?

We would love to walk you through a demo of our apps and help get things started for you on the right foot.