Formula

Introduction

Feature(s)

After you edit the formula for a field in the form, the value of the field can be automatically calculated according to the formula when values of related fields are filled or modified.

Application Scenario(s)

1. You can fill the forms more efficiently with formulas, as the content that needs to be filled is reduced and some data can be automatically calculated.

For example, in score management, you want to set a rule that the grade is A when the score is above 90, otherwise it is B. Therefore, you can use a formula to calculate it. After a score is entered, the grade will be displayed automatically.

2. You do not need to calculate manually, which can reduce mistakes.

For example, in salary management, the formula for calculating the total salary is as follows:

Total salary = Basic salary + Bonus – Deduction

Then, after the basic salary, bonus, and deduction are entered, the total salary can be automatically calculated according to the formula, which can avoid calculation errors.

Where to Set

Currently, fields that support editing formulas include Single Line, Multi Line, Number, Date&Time, and Serial No..

Go to the Design page and select the field to be edited. Then, go to Field Properties > Initial Value, select Formula, and click Edit to edit the formula.