Skip to main content
Formula

Introduce what is formula in forms and where to set it.

Updated over 2 months ago

What is Formula?

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.


Where to Set Formula?

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.


When to Use Formula?

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.


I have finished reading. 🏆

👉I can't wait to SET FORMULAS.

👉I need more HELP in Discord Forum.

Did this answer your question?