Calculation

Luna
Luna
  • Updated

Calculation allows you to create new field that calculates values. It uses Yeeflow built-in Expression Editor to perform calculations.

You need specify the value of calculation that you want to use as the source of data in the control by defining an expression. An expression can use values from fields in the same list/form as well as built-in functions.

 

Calculation_Overview.jpg

 

Calculation displays read-only values based on your calculation expression.

 

Add Calculation to the form

Firstly, find the Calculation control in the controls add panel. Then, drag and drop it into a section or container on your form.

Calculation_Add.jpg

 

Basic of the Calculation field

Open the Content > Basic block and set the Title's text of this Multiple Metadata control. For more information about Title for field control, please refer:

Understand the Title of field controls

Set the Associated variable for this Calculation control. When you add a new Calculation control, a default variable will be generated automatically. You can click the Edit Button to change the ID and name, or click the Reset button to bind this Calculation control to other existing variables. For more information, please refer:

Understand form controls and the associated variables / fields

 

Expression: Click the Edit button to edit the calculation logic in the expression editor.

Learn more about creating a calculation

 

Calculation_Basic.jpg

 

Appearance of the Calculation field

Open the Content > Appearance block to set the appearance and layout of this Calculation control.

Hide in form: Turn ON this option will hide this control on your form. For some case, you might just need to do some calculation, and use the result on other controls, then you can hide this control.

Thousands Separator(,): Turn ON this option display the calculation value with thousands separator (use this for a value of Number or Currency etc.)

Prefix: Set the prefix text of this calculation value.

Suffix: Set the Suffix text of this calculation value.

Display Title: Choose display or hide the label of this control. For more information, please refer: Understand the label of field controls

Allow comment: Turn on this option will allow users to add comments on this control.  

Calculation_Appearance.jpg

 

Validation of the Calculation

Open the Content > Validation block to set the properties of this Calculation control.

  1. Number of Decimal Places: round number to the decimal place. (use this for a value of Number or Currency etc.)
  2. Custom Validation: Set the custom validation rules. An error message that will display under your field when specified conditions become true. It will allow you to add any number of rules for validating your field. Learn more about the Custom Validation.

 

Action call of the Calculation field

Open the Content > Action block to call a pre-defined action from the dropdown list. This action will be triggered once the value of this Calculation field is changed.

Switch_action.jpg

 

Style the Date Picker field

Field

  1. Typography: Set the typography options for the text in the Date Picker.
  2. Color: Choose the color of the field's text.
  3. Background Color: Set background color of the field. By default, the background color is set as transparent.
  4. Align: Set the alignment of text inside the field control. Can be LeftCenter or Right
  5. Padding: Set the Padding of the field control.
  6. Border Type: Select the type of border, choosing from none, solid, double, dotted, dashed, or grooved.
  7. Radius: Set the border radius to control corner roundness.

 

Style of title

Set the Title of field controls that are applicable to this control.

 

Advanced Settings

Set the Advanced options that are applicable to this control.

 

Types of Data

The data in a calculation is the result of formula that you specify. The result can be one of these below types of data:

  • Text
  • Number (included Percentage)
  • Currency
  • Date and Time
  • Yes/No (Boolean)

 

Was this article helpful?

/

Comments

0 comments

Please sign in to leave a comment.