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
Let’s 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 customization for Data Source values.
You can define rules that make column values appear in different colors 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 colors to emphasize their meanings.
These rules can be leveraged on Mapping screens to color 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.