On2Air Help Center > 
On2Air Forms - JotForm Start a free trial
You can use On2Air Formulas to live calculate data on a form, like adding quantities, calculating totals, displaying data from your base, and more.
The Airtable Formulas you currently have in your base won’t update live on a form due to Airtable API limitations, so you will need to substitute your Airtable formula with an On2Air Formula to calculate your data.
Here are some common calculations you can use that are a similar replacement for Airtable Formulas. They are based on EXCEL formulas.
CONCATENATE
SUM
AVERAGE
MIN
MAX
JOIN
ARRAYJOIN
To see the entire list of formulas available - https://formulajs.info/functions/