Show/Hide Toolbars

Thereforeâ„¢ Help

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

SD_R_Design_Categories_Index_Field_Calculation_001_v2

 

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.