Always Recalculate

Introduction

Feature(s)

Always Recalculate means that when a field is set hidden, the value of the hidden field will be the same as when it is visible, and it will also participate in calculation and linkage.

Application Scenario(s)

Fields that are set to Always Recalculate are generally configured with Data Linkage or Formula. These fields might be hidden for business needs or better visual effects. After being set to Always Recalculate, these hidden fields can still participate in calculations.

For example, in the case of a business assessment, the score of the assessment test needs to be calculated through a formula and hidden from examinees. In this case, it is necessary to set Always Recalculate for the field, and the score value for each option must be entered correctly.

Preview

When you fill in a form, the score field will be hidden. When the correct answer is selected, ten points will be automatically entered in the hidden field. If other wrong answers are selected, no score will be entered.

Setting Procedure

Setting Hidden Field(s)

Select a field in a form, go to Field Properties > Field Permissions, and untick View.

Setting Formula

1. Click Field Properties, select Formula from the drop-down list of Initial Value, and set a formula:

2. For example, set the formula as:

IF (The capital of country A is== "a",10,0)

It means that when the answer to the question is "a", you will get ten points, otherwise you will not get points.

Setting Hidden Field Default Value

Go to Form Properties > Hidden Field Default Value and select Always Recalculate:

Note(s)

For Single Line, Multi Line, Number, Date＆Time, Radio, Checkbox, Single Select, Multi Select, Image, Attachment, Select Data, Signature, Member, Members, Department, and Departments fields, the following rules are applied when you select Always Recalculate in Hidden Field Default Value:

1. For a regular form:

If a field has been set as an initial value and is invisible, the field will be assigned the initial value when the form is submitted.
After setting initial values for the above fields, you can add Field Display Rules: The above fields will be visible when Option 1 is selected, and hidden when Option 2 is selected. It means when Option 2 is selected, and the form is submitted, these fields will be assigned initial values.

2. For a workflow form:

Suppose you have set the above fields to be visible and editable at the start node and invisible at the approval node. Members can fill in fields and submit the form at the start node. If the approver submits the form directly at the approval node, the values of these fields will be same as those of fields submitted at the start node.
Suppose you make all fields visible and add Field Display Rules: some fields will be visible when Option 1 is selected and hidden when Option 2 is selected. Members can select Option 1 and fill these fields at the start node. If the approver selects Option 2 at the approval node, the values of these fields will be same as those of fields submitted at the start node after being submitted.
Suppose you add a Single Line field to the form, and you configure formulas for all the other fields based on the Single Line field. Besides, the Single Line field is set as visible, while other fields are visible at the start node and hidden at the approval node. Members can fill in the Single Line field at the start node. If the approver updates this field at the approval node, other fields will remain at their original values, which are calculated through the Single Line field, after the form is submitted.