Select Page
How to Live Calculate Data on Your On2Air Form (Estimates, Quotes, and more)

How to Live Calculate Data on Your On2Air Form (Estimates, Quotes, and more)

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

You can live calculate data on a form using your Airtable data and user input. This allows the form user to see live calculations on the form for things such as Estimates, Quotes, Surveys, Quizzes, and more.

  • 🎥 How to Live Calculate Data on Your On2Air Form (Estimates, Quotes, and more)
  • Formulas and Calculations Available
  • Style Your Formula Output Value

Example: You want to create a form for Job Quotes. You can add each Quote Item to the form and you can the running total of the costs on the form

image
➡️
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.

🎥 How to Live Calculate Data on Your On2Air Form (Estimates, Quotes, and more)

Formulas and Calculations Available

You can use formulas based on Excel and Airtable

💡
See available Formulas and CalculationsFormulas and Calculations

Style Your Formula Output Value

Add some styling to your Formula/Calculation field with easy-to-use styles

💡
Style Your Forms and Fields - CSS Class StylingStyle Your Forms and Fields - CSS Class Styling