FormTab forms now support Calculation field types that allow you to perform mathematical operations live within your forms.
Calculations can be performed on any number or date field, making them perfect for:
You can also add calculations to table rows and/or columns and perform calculations on calculations, which means you can build up complex formulae based on the values in your form and/or values you specify.
Calculations is an add-on to your FormTab account.
To view pricing and to activate Calculations, go to Add-On Options in your Account Settings.
It is possible to add calculation fields to your forms without activating the add-on. You can even preview the form in the form builder to test your calculations. However, if you publish your form, calculation fields will appear as text fields until the add-on is activated.
Sum Calculations provide a simple sum of the field values or fixed values you specify.
To add a Sum Calculation click or drag a Sum field to your form then click to open the settings panel.
Click ➕ to add a field to your calculation.
The result can be displayed as:
Arithmetic Calculations allow you to perform simple mathematical operations using the field values or fixed values you specify.
To add an Arithmetic Calculation click or drag an Arithmetic field to your form then click to open the settings panel.
Click ➕ to add a field to your calculation.
You can build up a calculation using as many fields as you like.
If you are using multiple values and operators, please be aware that calculations are performed using standard BEDMAS rules.
The result can be displayed as:
Timeframe calculations allow you to calculate and display the difference between two date/time fields.
To add a Timeframe Calculation click or drag a Timeframe field to your form then click to open the settings panel.
The result can be displayed as:
Percentage Calculations allow you to work out and display one value as a percentage of another.
To add a Percentage Calculation click or drag a Percentage field to your form then click to open the settings panel.
The result can be displayed as:
Calculations fields can be added to tables providing vast power and flexibility.
To add a Calculation field, click or drag a Calculation field to your table then click to open the settings panel.
For specific details on configuring your calculation, see the appropriate section.
Note, when adding fields to a table calculation, you can only select compatible fields from the table.
When calculations are performed, they are done on a row by row basis.
For additional functionality you can also add a Column Calculation to perform a Total of the values in that column.
You can add a Column Calculation to a table to provide a total for the values in that column.
Column calculations can be added to any column containing a Number, Slider or Calculation field.
Click to open the settings panel.
Choose ‘Total’ from Perform Column Calculation. This will add a footer row to your table and display the total value for the column.
If you want to use a Table field in a Calculation elsewhere in your form, you must be using a Column Calculation for that field.