Calculated fields automatically work out a value from other fields on your form, saving providers from having to calculate totals themselves. You'll need to have already added your number fields to the form before setting up a calculated field. See Add and configure fields for more information.
Set up your number fields
Before you add a calculated field, you need to set up the number fields it will use and give each one a Field Name so the formula can refer to them.
Add the number fields your calculation needs to the form canvas, for example, Quantity and Amount.
Click each number field to open its settings in the Properties panel.
Enter a Field Name for each field, for example, QUANTITY and AMOUNT.
🤓 Tip: Use capital letters with an underscore between words when naming fields, for example, TOTAL_COST. This makes your formulas much easier to read.
Add and configure the calculated field
Once your number fields are named, you can add the calculated field and build your formula.
Drag a Calculated Field from the Available Fields panel onto the form canvas.
Click the calculated field to open its settings in the Properties panel.
Enter a label for the field, for example, 'Total Cost'.
Enter a Field Name for the calculated field, for example, TOTAL_COST.
Build your formula by referencing your number fields using the standard operators:
Add — adds two values together.
Subtract — takes one value away from another.
Multiply — multiplies two values together.
Divide — divides one value by another.
Optionally, set a prefix, for example, £, a suffix, for example, 'per week', and the number of decimal places.
Click Save.
📌 Note: Calculated fields only work with number fields. You cannot use text, date, or selection fields in a formula.
Preview and test your calculated field
Always preview your form to make sure the calculated field works correctly before saving and publishing.
Click Preview Form.
Enter values into your number fields and check that the calculated field updates automatically with the correct result.