Use Cases
The Calculation field covers a wide range of business needs:
Compliance checking
Generate a barcode for a custom export
Log work hours with automatic calculations
Generate a link to open Google Maps
Create a custom identifier
Generate an automatic score or rating based on criteria
Calculate the total amount of a quote
What Types of Calculations Are Supported?
✅ Basic operations: addition, subtraction, multiplication, division
📊 Totals and averages within a table (e.g. total quantity, average score)
🕓 Durations: difference between two times or two dates
📐 Complex formulas: powers, square root, logarithm, trigonometric functions
📎 Conditional calculations: compliance checks, checkbox-based calculations
🔁 Use values from other fields: calculate from a Reference field, NFC Tag, or input field
🧾 Custom display: combine text and numbers in a single result (e.g. custom identifier)
These options allow you to automate many business calculations while eliminating manual errors.
Field Settings
Once the field is added to your form, click the ✏️ icon to access its settings. The configuration is organised across six tabs:
Properties
Calculation
Visibility
Display
Advanced
Help
1. Properties Tab
1.1 Title
By default, the title reflects the field type. You can change it at any time.
👉 Renaming the field after the form is first saved does not change the field's identifier or tag (used for exports).
1.2 Editable Input
Enable this option if you want the field value to be manually editable during data entry.
1.3 Number of Decimal Places
Sets the number of decimal places displayed in the result.
1.4 Result Type
Choose between a number or time format for the result.
2. Calculation Tab
This is where you build your formula.
2.1 Add a Field
Click Add a field to insert a form field into your formula. A blue chip with the field name will appear in the Calculation Formula area. Multiple fields can be added to the same formula.
ℹ️ Note
Some fields may not appear depending on their position (inside or outside a table).
If the Calculation field is outside a table, only fields outside the table are available.
If it is inside a table, only fields from that table are available.
Fields are grouped by category:
Simple fields: can be inserted directly into a formula
Average: calculates the average of a field across table rows
Sum: adds up values of a field in a table (Checkbox, Input, Counter, Slider)
Min / Max: retrieves the lowest or highest value of a field in a table
References: uses the value from a Reference field (if present in the form)
2.2 Functions
Unique identifier: generates a value based on the date, time, and user ID
ItemRefNum: reads a value from a defined column, similar to a Reference field — typically linked to an NFC Tag or an input field
Mathematical functions:
Square root:
sqrt()Cosine:
cos()Sine:
sin()Natural logarithm:
log()Power:
pow(x,y)Exponential:
exp()Round up:
ceil()Round down:
floor()
Place your cursor between the parentheses to enter a value or select a form field.
2.3 Calculation Formula
Write your formula here.
The Clear button deletes the formula.
The Add text button inserts a text string into the formula. An orange chip containing the text will appear in the formula area. Multiple text strings can be added.
⚠️ Important
When adding text, a + sign is inserted automatically. Delete it if it is not needed.
2.3.1 Arithmetic Operators
+— addition or concatenation-— subtraction/— division*— multiplication%— modulo (remainder of a division)
2.3.2 Comparison Operators
<— less than<=— less than or equal to>— greater than>=— greater than or equal to==— equal to!=— not equal to===— strict equality!==— strict inequality
2.3.3 Logical Operators
&&— AND||— OR!— NOT?— ternary operator:((condition) ? value_if_true : value_if_false)
2.3.4 Bitwise Operators
&— bitwise AND|— bitwise OR
3. Visibility Tab
As with any field, you can:
Set visibility conditions — the field only appears when the specified condition(s) are met
Check Always hidden to prevent the field from displaying during data entry
Leave unconfigured — the field will always be visible
4. Display Tab
4.1 Stay on the Same Line as the Previous Element (Mobile)
Displays two fields side by side on mobile (if enabled in the app settings).
4.2 Element Size
Sets the display size of the field name (Normal, Larger, Smaller).
4.3 Colour
Customises the colour of the field name.
4.4 Icon
Adds an icon to the left of the field name.
4.5 Help Text
Displays a help message to the user, accessible via a question mark icon.
5. Advanced Tab
5.1 This Data Is Personal Data
Hides this data in the history unless explicitly clicked. Also enables personal data export via CSV.
📚 See our guide: How to adapt your forms to make them conform to the GDPR?
5.2 Remove Paragraph in Custom Word Export if Data Is Empty or Hidden
The paragraph linked to this field will not appear in the Word export if the field is empty or hidden.
5.3 Read-Only on Edit or Push
The data cannot be modified after saving or when sent via Push.
6. Help Tab
Contains the field's identifier and tag.
Identifier: automatically generated from the field name; can be edited before the form is saved for the first time
Tag: derived from the identifier, enclosed in
##. Example:##identifier##