On2Air Pricing

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. Includes features not included in basic Airtable forms.

ESSENTIAL

$29.99/month

10 Forms, 10 On2Air Fields per form
Fields Types: Select, Subselect, Placeholder

PROFESSIONAL

$49.99/month

50 Forms, 25 On2Air Fields per form
Fields Types: Select, Subselect, Placeholder

PREMIUM

$79.99/month

100 Forms, 50 On2Air Fields per form
Fields Types: Select, Subselect, Placeholder

On2Air: Backups

Automated backups of your data in your Airtable bases. Create scheduled backups of data stored in Airtable and export your information to Dropbox, Box, or G Drive.

ESSENTIAL

$29.99/month

15 Bases, 250K Records, 25K Attachments
Monthly or Weekly Backup Schedule

PROFESSIONAL

$49.99/month

50 Bases, 1Mil Records, 500K Attachments
Monthly, Weekly, or Daily Backup Schedule

PREMIUM

$79.99/month

250 Bases, 5Mil Records, 1Mil Attachments
Monthly, Weekly, Daily, Hourly Backup Schedule

amplify logo

On2Air: Amplify

Dashboard for your Airtable records. Display records and data in any way that works for you and view multiple tables. Create custom dashboard views, view documents in full screen, and hide or display record fields.

ESSENTIAL

$29.99/month

5 Bases, 25 Amplify apps per base, 5 Users
 

PROFESSIONAL

$49.99/month

10 Bases, 100 Amplify apps per base, 20 Users

PREMIUM

$79.99/month

20 Bases, 400 Amplify apps per base, 40 Users

On2Air: Schemas

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

ESSENTIAL

$29.99/month

10 Bases, 2 Years of History

PROFESSIONAL

$49.99/month

25 Bases, 5 Years of History

PREMIUM

$79.99/month

50 Bases, 10 Years of History

Free

1 Schema, No History

On2Air: Actions

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

ESSENTIAL

$29.99/month

25 Actions and 10K Monthly Credits

PROFESSIONAL

$49.99/month

50 Actions and 50K Monthly Credits

PREMIUM

$79.99/month

100 Actions and 100K Monthly Credits

See Actions Available

Core Actions Available

Trigger Action


Triggers allow you to initiate a process for automatically updating, modifying, or deleting single or multiple records in bulk to or from Airtable. Triggers can be used in Airtable Automations, Airtable Scripting, Zapier (over 2,500 other apps), or a Custom App.

Update Action

On2Air Action Updates allows you to update, create, or delete single or multiple Airtable records. You can use updates in your Airtable Automations, Airtable Scripting, Zapier, or a Custom app.

Search Action

A Search Action is a way to 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.

Function Types Available for Google

Google Docs Create/Export – Automated Documents

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 Slides Create/Export – Automated Documents


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 Sheets Create/Export – Automated Documents


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

Default Values

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 Field

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

JSON Field

Save Record Fields as JSON in a single Notes field

Arrays

Manipulate Arrays (Collections of your Airtable data)

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.

Attachments

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

Field Diff Log

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

 

Math Functions

Perform an extensive variety of math equations in your records

Math Function Options:

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

Convert to Another Unit – Convert units to a different unit
(Length, Surface area, Volume, Liquid Volume, Angles, Time, Frequency, and more)

Statistical Formula – Perform statistical functions on your records

Finance Functions

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

Table Import – Import Data from a URL into a Table

Export – Export Data from a Table to a URL

Single Table Linked Records Sync (Backlinks) – 
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 (VLOOKUP)
Lookup values from another table based on a field match and set in each triggered record. Similar to a VLOOKUP() call.

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

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.

ESSENTIAL

$29.99/month

10 Code Blocks, 20 Scripts, 50 Snippets

PROFESSIONAL

$49.99/month

25 Code Blocks, 50 Scripts, 100 Snippets

PREMIUM

$79.99/month

50 Code Blocks, 100 Scripts, 250 Snippets

Each app also has a Starter plan available for $100/year. View the specific app page to see details on the Starter plan

Clark Construction

Netflix

Novo Nordisk

Franklin Templeton Investments

Anyline

Primal

Altius

Founder City Project

Venture Dev Center

Medelita

UC Denver

Enalyzer

StrataBlue

SHI

Hawaii VA Loans

TCV

Coastguard Maraetai

Triplemint

Plussa Energy

Onify

Empower Her

Congregation Shamrei Emunah

Hare Krishna Movement

CD Baby

nc3D

Katonah Yoga

I Sold My House

Northwest Hospitality

Tax Justice Network

Writing Pad

Reaction Concepts

Global Citizen Year

I Sold My House

Venture

EOS

Flat

Cyber Bytes INC.

Message LAB

Minerva