Understanding and using the Calculation field

In the back-office.

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.

/!\ ATTENTION /!\ Specify clearly the “numeric” type.

• 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.

On the mobile.

This feature enables it to work from the outset with a  Referential list, but we would prefer to use the  Reference element, which was developed expressly for this feature.

For those who already work with Referential lists and Calculation fields, this feature still works.

Idea: With the Referential and Calculation elements, you have the option to create a proper purchase order form. In order to obtain an identical document to your current purchase orders, you can create a Word template. Refer to the "purchase order" example, which is located in our forms library. 

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.

Configuration.

• Add a Calculation field and go in its option, ‘calculation’ tab.
• In the drop-down menu, select ‘Uniq number’.

  /!\ Don’t forget to  confirm  your settings and   save your form .

On the mobile device.

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.

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

• List == value code A? Value if true: Value if false

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. Warning: if you add text, remember to remove the + which is generated automatically.

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:

• my_slider == -1?0:my_slider <- so, if Not applicable is selected, its value in the calculation will be equal to 0, otherwise the chosen value will be taken into account. This operation will allow us to know the selected note.
• my_slider == -1?0:1<- thus, if Not applicable is selected, the value taken into account during the computation will be equal to 0; otherwise, it will be equal to 1. This formula will be used for the division to know how many items have been entered.

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

In order to display a result when a field is equal to another field, we use the following formula:

• Element A == element B? Value if identical: Value if different

In the example below, we applied it to two input fields to check if the email addresses are identical.  Warning: if you add text, remember to remove the + which is generated automatically.

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:

• Our first condition? Value if true: Our second condition? Value if true: Value if false

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:

• Element A <element B? Value if true: Value if false
• Element A> element B? Value if true: Value if false

Combined, we get the operation below:   Warning: if you add text, remember to remove the + which is generated automatically.