Insert a calculation field and access its features: Go to the element options by clicking on the pencil.

Several options are available to you under the Properties tab:

Define how many digits after the decimal point will be included in your results.

Define the type of results in your calculation: number or time.

By checking the Editable entry box, you can change the results of your calculation. For example, if you want to round the results.

Under the Calculation tab, you will define the fields to calculate.

The Calculation tool has several functions.

Consider the following example: You want the price for an order to be automatically calculated.

Example: Start by inserting an Input field and go to its properties: Rename it according to the needs of your form and choose the type that you need. In our example, the Entry field will be called “Price” and will be a “decimal number” type.

Insert as many Input fields as necessary to make your calculation and set the properties of these fields.

Then insert your Calculation field and go into its options.

Add the “Price” field in the 'formula of calculation'.

Multiply with another field, like "Quantity" as shown here.

Once completed, confirm and save your form.

Consider the example of an employee time sheet.

Create your time sheet form: A table with a list of participants and a numeric entry field where you specify the number of hours worked.

Add an external Calculation field to the table.

Define the field: According to the example, the field will make the sum of the "Hours worked” column.

Confirm and save your form.

The Uniq Number allows you to create a random line. As an example, we will use the Uniq number to create the P.O number of your Purchase Order.

The ItemRefNum makes data reading easier. It is similar to the Reference field. It reads information contained in a given column. It is usually linked to an NFC Tag or an Input Field. To discover how to configure your NCF tag, do not hesitate to check our tutorial!

Square root

The Square Root function can be used to calculate area or volume, for example. When you select this function, the formula sqrt() is displayed. You can then :
​
Enter a value between the brackets to calculate the square root of that value
Place yourself between the brackets and select a field in the form to calculate the square root of the value entered in the field

Cosine

When you select this function, the formula cos() is displayed. By placing the cursor between the brackets, you can either enter a value or select a field on the form to calculate the cosine of the value in that field.

​Sine

When you select this function, the sin() formula is displayed. By placing the cursor between the brackets, you can either enter a value or select a field on the form to calculate the sine of the value in that field.

​Natural logarithm

When you select this function, the formula log() is displayed. By placing the cursor between the brackets, you can either enter a value or select a field on the form to calculate the logarithm of the value in that field.

Power

When you select this function, the pow() formula is displayed. By placing the cursor between the brackets, you can either enter a value or select a field on the form to calculate the power of the value in that field.

Exponential

When you select this function, the formula exp() is displayed. By placing the cursor between the brackets, you can either enter a value or select a field on the form to calculate the exponential of the value it contains.

You can condition your calculations through different operators:

Arithmetic operators:

Comparison operators:

Logical operators:

Bitwise operators:

Perform a calculation according to a checkbox

In order to perform a different calculation according to a checkbox, you can use the following formula:

In the example below, we want to apply a 5% discount if our box is checked.

For this, we test whether our apply 5% discount? box is checked or not. The deduction will be applied if the box is checked.

In order to give a value in our calculation when an element is selected in a list, we use the following formula:

In the example below, we applied it to our calculation to offer VAT if New Customer is selected. At first, we assign a code to our list, of the form code: list. This code will of course not be visible on the mobile device.

We then test if our new client has been selected.

Perform operations with conditions - example: average

In the example below, we want to achieve a grade average of 0 to 10 and not to consider an item that is not applicable.

In our Slider elements, we select the type Text and we add our different notes, for the Not applicable, we give it a code, -1: 0 1 2 3 4 5 6 7 8 9 10 -1:Not applicable In our Calculation element, we test whether the non-applicable element is entered or not. For this we use the following formulas:

By repeating the first calculation for each slider element and then dividing by the second, we get the calculation below:

Using two conditions - example: display a result if a field is greater than, less than, or equal to another field

If you want to combine several conditions, you can use the following formula:

If the first condition is false, we test the second, etc., until we reach the "Value if false" In the example below, we test our A value and B value to find out if A is greater than, less than or equal to B. We use the following formulas:

Combined, we get the operation below:

To perform a calculation if a box is checked or if an item is entered, you can use this formula:

At first, we will test the first condition, if it turns out wrong, we will test the second, so on. In the example below, we test our input field. If it contains 0, 2, 4, 6, 8 or 10, then Even will appear, otherwise it will be Odd.

To perform a calculation if a box is checked and an item is entered, you can use this formula:

In the example below, we wish:

Thus, we test respectively: