Aside from simply specifying the data type and position of a Data Source column, we provide more advanced options which influence how rows will display in various screens and filtering scenarios.
These additional options are accessed via Data Source -> Rows page in the secure website – simply click the “cog” icon seen in the column headers.
This will open the Advanced Column Settings dialog.
The dialog contains powerful options such as:
Referring Data Source
Lets you specify another Data Source which contains the set of possible values that can appear in this column. When you define a Referring source, the Filter screen in the app will automatically display those possible values as a drop down list of options instead of defaulting to text entry.
Conditional Display Rules
This unlocks a whole new level of display customisation for Data Source values.
You can define rules that make column values appear in different colours and text styles based on a formula result.
For example, you might have a Status column that has three possible values – Good, Bad and Ugly. Defining rules for these will let you display those Status values in different colours to emphasise their meanings.
These rules can be leveraged on Mapping screens to colour pins, in Listing screens to vary the data value display and are also automatically applied in Form screens when you use a Choices field with List of Choices display style.