To help control how the Data Source filters and rows display across your apps, our platform provides advanced column configuration functionality.
This functionality is accessed via the Data Sources -> Rows page in the secure website; simply click on the “cog” icon seen next to each column heading to open the Advanced Column Settings dialog.
The dialog contains powerful options such as:
Referring Data Source
This 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, all Filtering screens in the app will automatically display the referring Data Source's rows as a drop down list of options instead of a text entry field.
This provides a more cohesive user experience and is a faster, more error-free way for users to define their own filters on Listing and Mapping screens.
Conditional Display Rules
This opens up a new level of display customisation for Data Source row 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 the pins displayed, 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.