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. Filtering screens are accessed on your app via the Listing and Mapping screen types. Filter screens allow the app user to apply their own custom filters onto the rows shown in a Listing or Mapping screen. 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 customization for Data Source row 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 your app in the following areas:
- Mapping screens
Colors the map pins displayed, provided you have set your rules column as the Conditional Pin Color property in the Mapping screen designer.
- Listing screens
Colors the column text displayed, assuming you have the rules column set as one of the row display positions in the Listing screen designer.
- Forms screen
Specifically within Choices fields that are set to display vertically and using the List of Choices display style property in the Form designer. The rules target column must also be set as one of the default display positions, which is configured via the Settings page of your Data Source.