| Table of Contents | |
|---|---|
|
...
Purpose
...
Formula
...
Formula editor is used to create Visualization and Calculation rules for Activity Fieldsfields. You can access it by creating new Field field or editing and existing field in Administration/Activity/the Form Designer.
At At the bottom of the screen you can choose either to add Calculation or Visualization rule for the chosen field by clicking Edit. Some Fields may have only Visualization rule available , if they can't be used in calculations.
Default View
...
The formula editor contains several areas:
...
| Reference | Description |
|---|---|
| 1 | Expression builder |
| 2 | Available fields for selection |
| 3 | Arithmetic and logical operators |
| 4 | Available |
...
| functions | |
| 5 | Available options in |
...
| pick list and multi-select fields |
If you click once on a Multi List or Pick List or Mulit-Select Field, their entered Options available options will appear on the empty place bellow the operator’s buttons (place 4):
That's working also for fields with selected URL Setting, like Technician:
. Options will also display if the pick list / multi-select field is based on a data source URL setting (i.e. Technician or Location).
Expression building
...