Formulas |
Scroll |
Formula for calculating the field value:
This field is available in the 'Number', 'Decimal' and 'Text' fields. Formulas can be used to perform automatic calculations in the field, which are calculated from values captured from other fields within the same dialog. Add a formula that calculates figures from other field sources here.
Arrow
Opens the 'Objects and Functions dialog' containing a list of functions to use.
Reference: Objects and Functions
Conditional Properties
Set conditional properties for the field. This includes the mode (default, mandatory, or disabled) and conditional field formatting.
Supported Fields
Conditional properties can be defined in the Formulas tab for the following field types.
Field type |
Conditional formatting |
Conditional mandatory/disabled |
Label |
no |
no |
Image |
no |
no |
Text |
yes |
yes |
Integer |
yes |
yes |
Decimal |
yes |
yes |
Date |
yes |
yes |
Datetime/Timestamp |
yes |
yes |
Check box |
yes |
yes |
Numeric Counter |
no |
no |
Formatted Counter |
no |
no |
Single Keyword |
yes |
yes |
Multiple Keyword |
yes |
yes |
Primary/Dependent |
yes |
yes |
Tab Control |
no |
no |
Tab |
no |
no (visibility only) |
Table |
no |
no |
Table Text |
no |
yes |
Table Integer |
no |
yes |
Table Decimal |
no |
yes |
Table Date |
no |
yes |
Table Datetime |
no |
yes |
Table Check box |
no |
yes |
Table Single keyword |
no |
yes |
Table Primary/Dependent |
no |
yes |
Condition
Set a condition for the field to be set in a specific mode and to display a background and/or font color when the figures meet the condition's criteria. Only one condition can be active in a field.
Arrow
Opens the 'Objects and Functions' dialog containing a list of objects and functions to use.
Reference: Objects and Functions
Mode
Select the mode the field should be set to if specific conditions are met. The available modes are 'Default', 'Mandatory' and 'Disabled'.
Default |
Standard formatting will be used on the field. |
Mandatory |
The field will be set as mandatory if the condition is met. |
Disabled |
The field will be set as disabled if the condition is met. For this mode, the options below are grayed out. |
Font Colors
Set a font color for the condition.
Background Color
Set a background color for the condition.