Aside from specifying the data type and position of a data source column, we provide advanced options to influence how rows will display in various screens and filtering scenarios.
These additional options are accessed via data source, rows page. Using the navigation menu click on Connected Data, and select Data Source from the drop down. Click the 'cog' icon seen in the column headers. This will open the 'Advanced Column Settings' dialog.
This dialog contains powerful options such as:
Referring data source
This allows you specify another data source that contains a set of possible values that can appear in this column. When you define a referring source, the filter screen 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 new level of display customization 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 emphasize their meanings.
These rules can also be leveraged on mapping screens to colour pins, in listing screens to vary the data value display. They are automatically applied in form screens when you use a choices field with list of choices display style.