Formula-Field
A Formula-Field type field is used to perform calculations based on specified inputs.
Incorporate other fields by simply using their unique Field Name and mathematical operations like addition (+), subtraction (-), multiplication (*), and division (/). These mathematical operations are executed automatically, and the output decimals can be limited if the designer has specified the number of Decimal. Users can adjust the calculation result if Can Adjust? is checked.
Formula-Field
For example:
- Field A: Field Name - field_a, Type - Integer
- Field B: Field Name - field_b, Type - Integer
- Field C: Field Name - field_c, Type - Formula-Field
The designer sets up the formula: (field_a + field_b) / 0.33
When an end-user enters "330" in Field A and "30" in Field B, the formula calculation (330 + 30) / 0.33 will be displayed in Field C.
Watch the video below to see how easy it is to use the formula field.
YouTube will track your interaction with them.
LabIMotion: Designer - Formula Field
When setting up the calculation formula, use the Field Name to reference an Integer type field.
Extra Field Attributes​
Decimal​
The decimal of the calculation result.
Can adjust?​
When this is checked, it means that the user is allowed to change the calculation result.
Formula​
The calculation formula.