Select Page
How to Set Up a Formula in On2Air Formula

How to Set Up a Formula in On2Air Formula

🔴 On2Air Forms has been shutdown to focus on our On2Air Backups Airtable app Learn more about automated Airtable backups - on2air.com

You can use On2Air Formulas to live calculate values on your Form and use as a replacement for an Airtable formula.

➡️
The Airtable Formulas and Rollups you currently have in your base won’t update live on a form due to Airtable API limitations. For any value you want calculated live on a form, you’ll need to substitute your Airtable formula with an On2Air Formula to calculate the data.

Creating a Formula with On2Air Formulas

  • Add the On2Air Formula to your form
  • First, choose your formula - See all Formulas and CalculationsFormulas and Calculations available
  • Next, add your formula name and an open parentheses
  • Click Insert Variable to add an Airtable field to your formula
  • Close the parentheses

Example:

SUM({Budget Items::Fixed Cost})
image

Formula Output Format

You can choose how you want your formula to display once calculated

Output Format Options

  • Text - Displays as basic text
  • Number - Displays as a number
  • Date/DateTime - Displays as a Date or DateTime
  • Rating - Display as Star Ratings
  • URL - Display as a URL
  • Duration - Display as Duration - 00:00
  • Boolean - Display as True/False
  • Collaborator - Display as Collaborator/User
  • Button - Display as a Button
  • Standard - Display in Standard format

Variables in Formulas

Variables are used to insert and use values from your Airtable base.

The format for variables is:

FIELD NAME - Used for fields on the current form

TABLE NAME::FIELD NAME - Used for fields in other linked records on your form. This allows you to use fields from your other tables linked on the form

The fields listed in the Variables dropdown will be any field you have on the form, plus any fields listed in the Display Configuration of your Linked Record fields. This allows you to use fields from other tables.

image

If you need to add additional fields to your Variables from your Linked Record Fields

  • Choose your Linked Record field
  • Open the Display Configuration

image
  • By Display Fields, click Add/Remove Fields
  • Add the fields you want to see in your Variables list
    • You can still hide these fields on your form, in your linked record table, and in the search lookup by clicking on each field in the Display Fields and adjusting the settings. Adding them to the Display Configuration just allows you to use them anywhere else in the form

image
  • Click Done
  • Your new fields will be listed in the Variables list

Empty Text

- Message to display if the formula value is empty

image

Styling

Template - Provide a custom template to wrap your formula value in. Use {{VALUE}} as placeholder for the formula value.

Example: If you want to add the $ symbol to your final value, type ${{VALUE}}. Your final value will have a $ in front

image

CSS Class Styling

You can use styling in your formula field to change the font size, change the color of the text or background, and multiple other customization options