On2Air: Actions

On2Air: Actions is an Airtable automation and workflow tool with integrations and pre-made functions to connect your Airtable data to other Airtable bases and with over 2,500 software tools used in your business.

Create automated business processes with 33 pre-made no code functions and 20 actions, such as automated documents, financial calculations, default values, copy field values, and many more!

Products

Functions Available

Automatically generate documents in Google Docs using your Airtable data. You can create single or multi-page documents and upload them back to your base as a PDF or Doc file. Useful for Invoices, Quotes, Form Entries, Contracts, and more.

Automatically generate documents in Google Sheets using your Airtable data. You can create single or multi-page documents and upload them back to your base as a PDF or Sheets file. Useful for Reports, Presentations, Charts, Inventory, Form Entries, and more.

Automatically generate documents in Google Slides using your Airtable data. You can create single or multi-page documents and upload them back to your base as a PDF or Slides file. Useful for Reports, Presentations, Marketing Material, Inventory Catalogs, Flyers, Form Entries, and more.

Create or Copy a new Google Drive folder and all its contents to a new Google Drive folder location.

Sync Airtable Data into a Google Sheet – Used for full table syncing

Automation to modify multiple or single records using a scheduled automation, Airtable automation, Airtable Scripting, or Zapier.

Learn more

Search your Airtable base and return single or multiple records for use in Airtable Automations, Airtable Scripting, Other Apps in Zapier, or a Custom App

Learn more

Update, Create, or Upsert Data

Perform an Update/Create/Upsert any time a record triggers.

Learn more

Set Default Values to fill in empty fields every time a new record is created. Great for creating templated records.

Copy the value from one field to another field. This can also copy over multiple fields at a time.

Keep a Log of Changes to a Field

Keep a running log of changes to any field within a Long Text Field. Track changes made to fields.

Save Record Fields as JSON in a single Notes field

Process Images and Attachments

You can convert URLs to Attachments, extract URLs from Attachments, and calculate the filesize sum in an attachment field.

See Attachment Functions
  • 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

Manipulate Arrays of Data

Compare field data by finding unique values (useful for detecting duplicates), count items across fields, find random data, and many more array options. See the entire list of Array options below.

See Array Functions
  • 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 a 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.

Perform an extensive variety of math equations in your records.

Write math equations (Basic uses, Algebra, Complex numbers, Expressions, Fractions, and more), Change incoming number formats to a different format, convert units,  and create statistical formulas.

Learn More

See Math Functions
  • Write Math Equation – Perform an extensive variety of math equations in your records(Algebra, Basic usage, Bignumbers, Chaining, Complex numbers, Expressions, Fractions, and more)

  • Format Numerical Number – Format incoming numbers and output as a different format(Standard, Currency, Decimal, Ft Units, Percent, or your own custom format)

  • Convert to Another Unit – Convert units to a different unit (Length, Surface area, Volume, Liquid Volume, Angles, Time, Frequency, Mass, Electric Current, Temperature, Amount of Substance, Luminous intensity, Force, Energy, Power, Pressure, Electricity and magnetism, Binary)

  • Statistical Formula – Perform statistical functions on your records***(*Mean, Median, Max ,Min, Mode, Product, Standard Deviation, Sum, Variance, Median Absolute Deviation)

Perform Financial Calculations on Records

Use financial calculations such as Present value of an investment, calculate Payments, determine the Internal rate of return for a series of cash flows, and more financial options.

Learn more

See Finance Functions
  • Present Value – Returns the present value of an investment, or the total amount that a series of future payments is worth now.

 

  • Future Value – Returns the future value of an investment based on periodic, equal, payments and a constant interest rate.

 

  • Payment – Calculates the payment for a loan based on a constant stream of equal payments and a constant interest rate.

 

  • Interest Payment – Returns the calculated interest portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.

 

  • Principal Payment – Returns the calculated principal portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.

 

  • Rate – Returns the interest rate per period for a loan or investment.

 

  • Net Present Value – Returns the net present value of an investment based on a constant rate of return and a series of future payments/investments (as negative values) and income/return (as positive values).

 

  • Internal Rate of Return – Returns the internal rate of return for a series of cash flows. NOTE: There must be at least one negative and one positive value as part of the cash flow. Cash flows are assumed to be due in the same order they are arranged in the cash flow values array.

Sync Linked Records in the Same Table

If using a Linked Record to the same table, Airtable does not automatically create the backlink field like it does with linked records between 2 tables. This fixes that by auto-populating the backlink fields.

Learn more

Export Data from a table in your base to a URL

Grab data from a table in your Airtable base and send it to a URL.

Import Data from a URL into a Table

Bring data from a URL into your table in Airtable

Lookup Values from Another Table

Lookup values from another table based on a field match and set in each triggered record. Similar to a VLOOKUP() call.

We are regularly adding new functions!

Create connections between Airtable and any other tools used in your business without coding. From financials to marketing to sales platforms, On2Air: Actions connects with over 2,500 other tools to ensure your Airtable data flows wherever you need it to be. Currently connects to Zapier. Integration with Integromat coming soon.

Define step-by-step actions for specific tables, views, and fields. Maximize your business using the most vital information you need to see at a glance.

Do more with your data beyond the current Airtable options. 

Go deeper with your workflows and use formulas to create customized values and outputs.

Use additional options to clear unused values, update empty records, or overwrite stale data. Keep your information fresh and current.

When data is changed in one app, ensure the content is updated in another. Sync finely-tuned business information on a large scale.

See the entire list of Functions available

View more details about each Function on our Support site

Function Types Available for Google Drive

Google Docs Create/Export

Create a new Google Docs file or Create a Google Docs file using data from your Airtable record. Additionally, you can store the URL of the newly created file in an Airtable field, save the file to a folder, and/or export the file to an Attachments field.

 

Google Sheets Create/Export

Create a new Google Sheets file or Create a Google Sheets file using data from your Airtable record. Additionally, you can store the URL of the newly created file in an Airtable field, save the file to a folder, and/or export the file to an Attachments field.

 

Google Slides Create/Export

Create a new Google Slides file or Create a Google Slides file using data from your Airtable record. Additionally, you can store the URL of the newly created file in an Airtable field, save the file to a folder, and/or export the file to an Attachments field.

 

Google Drive – Create Folders

Create or Copy a new Google Drive folder and all its contents to a new Google Drive folder location

 

Google Sheets Table Sync

Sync Airtable Data into a Google Sheet – Used for full table syncing

 

______________________________________

Function Types Available for Record Processing

 

Set Default Values to be used fill in empty fields (ex: on record creation) – This will not fill in records with information already in a field.

 

Copy the value from one field to another field (can copy over multiple fields)

 

Save Record Fields as JSON in a single Notes field

 

Arrays

 

Manipulate Arrays

 

Array Function Options:

  • 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.

Process Images and Attachments

 

Attachment Function Options:

 

  • 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

Keep a running log of changes to any fields within a Long Text Field

 

Perform an extensive variety of math equations in your records

 

Math Function Options:

  • Write Math Equations – Perform an extensive variety of math equations in your records
    (Algebra, Basic usage, Bignumbers, Chaining, Complex numbers, Expressions, Fractions, and more)
  • Format Numerical Number – Format incoming numbers and output as a different format
  • Convert to Another Unit – Convert units to a different unit
  • (Length, Surface area, Volume, Liquid Volume, Angles, Time, Frequency, and more)
Finance

 

Perform Financial Calculations on Records

 

Finance Function Options:

  • Present Value – Returns the present value of an investment, or the total amount that a series of future payments is worth now.
  • Future Value – Returns the future value of an investment based on periodic, equal, payments and a constant interest rate.
  • Payment – Calculates the payment for a loan based on a constant stream of equal payments and a constant interest rate.
  • Interest Payment – Returns the calculated interest portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.
  • Principal Payment – Returns the calculated principal portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.
  • Rate – Returns the interest rate per period for a loan or investment.
  • Net Present Value – Returns the net present value of an investment based on a constant rate of return and a series of future payments/investments (as negative values) and income/return (as positive values).
  • Internal Rate of Return – Returns the internal rate of return for a series of cash flows. NOTE: There must be at least one negative and one positive value as part of the cash flow. Cash flows are assumed to be due in the same order they are arranged in the cash flow values array.

 

______________________________________

 

Function Types Available for Table Management

 

Import Data from a URL into a Table

 

Export Data from a Table to a URL

 

If using a linked record to the same table, Airtable does not automatically create the backlink field like it does with linked records between 2 tables. This fixes that by auto-populating the backlink fields.

 

______________________________________

 

Function Types Available for Base Management

 

Lookup values from another table based on a field match and set in each triggered record. Similar to a VLOOKUP() call.

 

Perform an Update/Create/Upsert any time a record triggers

 

App Highlights

Pre-Made Function Tasks for Your Airtable Records, Tables, and Bases

Use pre-made functions to convert URLs into Attachments to store in your Attachment field, import data from a URL into a table in your Airtable base, create simple and complex math equations, and many more.

Use a Variety of Functions for Complex and Simple Tasks

Whether simple or complex, use functions for a variety of calculations and tasks.

No-Code and Easy to Use

Simple setup with step-by-step instructions. Pre-made tasks that only need quick connections to your bases, tables, and records.

Connect Airtable To All Your Business Tools

Create connections between Airtable and any other tools used in your business without coding. From financials to marketing to sales platforms, On2Air: Actions connects with over 2,500 other tools to ensure your Airtable data flows wherever you need it to be.

Initiate Workflow Processes Automatically

Move your business data automatically from one app to another. Eliminate frustration and hours of manual data entry. Spend more time on running your business and taking care of customers and clients.

Create, Search, and Update Your Airtable Data Seamlessly

Create, search, delete, and update single or multiple records or entire fields, tables, or views. Use specialized options to lookup and maintain your essential company data on a granular level.

See a full list of Action connector features
  • Integrates with Zapier to connect to over 2,500 other apps
  • Sync and send data between your Airtable bases
  • Send data to Airtable or to any other software you use
  • Triggers, Searches, and Updates available
  • Process multiple records at one time in bulk
  • Process single records
  • Add new records
  • Delete records
  • Update records
  • Send records to other bases or workspaces
  • Conditional actions – Actions will run only if certain criteria are met
  • Trigger on Checkbox, Field Updated, Date, Formula, Last Modified Time
  • Use custom formulas if needed
  • Multiple plans available
  • Access to the entire On2Air Apps Toolkit to make your Airtable experience even better (Actions, Backups, Forms, Schemas, Scripts, 1 in Development )

Premium Customer Service and Support

We're Airtable experts and we're here to help. We've been building Airtable apps and Airtable business systems for years.

customer support

Pricing

On2Air Actions

Essentials

$29.99

/month

OR

 $299.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 25 Actions and Functions of Your Choice – See 60+ available actions and functions
  • 10K Monthly Credits*
  • Automation Integrations: Specific Schedule, Airtable Automations, Airtable Scripting, Zapier, Webhooks, Custom App
  • Basic API Limits
  • Excellent Customer Service
*How Credits Work

Each Action/Function is counted towards your overall Usage Limits as determined by your subscription plan according to the following:

  • Only processed records count as usage. If no records are found, then no credits are used.
  • Each time an action or function is run with matching records, it will be counted as a credit in the following manner (unless otherwise stated in the specific action/function):

– 1 credit is used each time a function processes at least 1 record.

If more than 100 records are processed in same function call, then a credit will be used for each additional 100 recordsets.

Examples:

If a function processes anywhere from 1-100 records, only 1 credit will be used.

If a function processes 200 records, then 2 credits will be used.

If a function processes 450 records, then 5 credits will be used ( 1 credit for records 1-100, 1 for records 101-200, 1 for records 201-300, 1 for records 301-400, and 1 for records 401-450)

Each plan allows for a specific number of Actions/Functions and a specific amount of credits.

Example: The Professional Tier allows up to 50 action functions and 50,000 monthly credits.

This means you can set up 50 action functions and use up to 50,000 credits every month.

Professional

$49.99

/month

OR

 $499.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 50 Actions and Functions of Your Choice – See 60+ available actions and functions
  • 50K Monthly Credits*
  • Automation Integrations: Specific Schedule, Airtable Automations, Airtable Scripting, Zapier, Webhooks, Custom App
  • Medium API Limits
  • Excellent Customer Service
*How Credits Work

Each Action/Function is counted towards your overall Usage Limits as determined by your subscription plan according to the following:

  • Only processed records count as usage. If no records are found, then no credits are used.
  • Each time an action or function is run with matching records, it will be counted as a credit in the following manner (unless otherwise stated in the specific action/function):

– 1 credit is used each time a function processes at least 1 record.

If more than 100 records are processed in same function call, then a credit will be used for each additional 100 recordsets.

Examples:

If a function processes anywhere from 1-100 records, only 1 credit will be used.

If a function processes 200 records, then 2 credits will be used.

If a function processes 450 records, then 5 credits will be used ( 1 credit for records 1-100, 1 for records 101-200, 1 for records 201-300, 1 for records 301-400, and 1 for records 401-450)

Each plan allows for a specific number of Actions/Functions and a specific amount of credits.

Example: The Professional Tier allows up to 50 action functions and 50,000 monthly credits.

This means you can set up 50 action functions and use up to 50,000 credits every month.

Premium

$79.99

/month

OR

 $799.99/year 

Billed Annually
(Save 16% and Get 2 Months Free)

  • 100 Actions and Functions of Your Choice – See 60+ available actions and functions
  • 100K Monthly Credits*
  • Automation Integrations: Specific Schedule, Airtable Automations, Airtable Scripting, Zapier, Webhooks, Custom App
  • High API Limits
  • Premium Customer Service
*How Credits Work

Each Action/Function is counted towards your overall Usage Limits as determined by your subscription plan according to the following:

  • Only processed records count as usage. If no records are found, then no credits are used.
  • Each time an action or function is run with matching records, it will be counted as a credit in the following manner (unless otherwise stated in the specific action/function):

– 1 credit is used each time a function processes at least 1 record.

If more than 100 records are processed in same function call, then a credit will be used for each additional 100 recordsets.

Examples:

If a function processes anywhere from 1-100 records, only 1 credit will be used.

If a function processes 200 records, then 2 credits will be used.

If a function processes 450 records, then 5 credits will be used ( 1 credit for records 1-100, 1 for records 101-200, 1 for records 201-300, 1 for records 301-400, and 1 for records 401-450)

Each plan allows for a specific number of Actions/Functions and a specific amount of credits.

Example: The Professional Tier allows up to 50 action functions and 50,000 monthly credits.

This means you can set up 50 action functions and use up to 50,000 credits every month.

We also have a Starter plan for $99/ year that includes 10 Actions/Functions and 2,500 credits – Get Started

Customers

“Openside enabled our business to function property for a long time without having to to think about building our own software, and that is pretty invaluable. Their On2Air: Actions <-> Airtable integration is amazing, we use it very often and are very happy with the results”
(see their story here)

John Parker, CTO

“Openside has allowed us to bridge the gap between Airtable and the many other tools we use. It has saved us time and effort in creating multiple steps in Zapier, and has enabled us to consolidate many actions into one step. It has also allowed us to do more with Airtable to power our initiatives.”
(see their story here)

Aparna Kothary, Director of Technology

“Openside has provided a reliable solution to our business that has saved us countless hours by helping us to automate different steps associated with helping and tracking our customers as they move through our process to sell their home with our service”
(see their story here)

Kris Lippi, Owner & Broker

“With the help of Openside’s products and services, we saw over 70% improvement in efficiency of our business process and workflows” (see their story here)

Gabe Amey, CEO

FAQ

What is On2Air: Actions?

On2Air: Actions is an advanced automation tool to integrate and connect your Airtable data with any other software tools used in your business. Create powerful business processes with almost 20 additional action options beyond the standard Airtable action connectors. Connect your Airtable data to over 2,500 other apps. On2Air: Actions is the solution you need to optimize your systems and enhance the information flow between Airtable and other apps.

What is an Action?

An Action is a series of steps you create to connect and perform tasks related your Airtable data with another software platform or online app. You can create, sync, search, update, or delete data in either Airtable or the corresponding app.

How do I create Actions and Functions?

Read the On2Air: Actions App Overview to set up your first action.

How many Actions can I have?

Choose the plan that works for you. From a single action to many actions, we have pricing plans to fit your needs.

Why do I have to enter my Airtable API key?

In order to use this product, we need to connect to your Airtable data which requires entering your API key into our connector and Zapier. While we do have access to your API key, we do not store it on our systems. It is only stored on Zapier’s systems, similar to the existing connector.

What pricing plans are available?

We have price plans for multiple use-cases. View our plans here.

More On2Air Apps for Airtable

amplify logo

On2Air: Amplify

A brand new way to view your Airtable data. With custom views, a full-screen viewer, record customizer, editor, and dashboard, On2Air: Amplify will change the way you use Airtable!

On2Air: Forms

Create and configure advanced forms using your Airtable data completely integrated with a third-party form’s powerful features, including prefilled data, search, and more. 

On2Air: Actions

An advanced connector to integrate your Airtable data with any other software,  including over 2,500 apps with 15+ additional action options beyond the standard Airtable actions.

On2Air: Backups

An automated backup solution for your Airtable bases. Create scheduled backups of data stored in Airtable and export your information to Dropbox, Box, or G Drive.

On2Air: Schema

A generated diagram to visualize your Airtable base structure and track changes to meta information for all tables, views, fields, and relationships. 

On2Air: Scripts

Create, edit, maintain, and integrate multiple scripts from a single codebase and sync across multiple Airtable bases, integrated with Airtable’s Scripting block.