Skip to content

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)

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

You can use formulas based on Excel and Airtable

💡

See available Formulas and CalculationsFormulas and Calculations

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