To control how Data Source filters and rows are displayed across your apps, the platform provides advanced column configuration options.

This functionality becomes available once you select the desired Data Source by navigating to Data Hub > Data Sources and opening the specific Data Source.

Once you’re on the Rows page of a Data Source, click on the cog icon next to each column heading to open the Advanced Column Settings. 

Column Settings

Contains powerful options.

Data Type

Specifying a data type will cause the Data Source to validate and reject data values that do not match the type selected.

Display Order

Controls the default position of this column when displayed in the portal and on the app.

Disable Filtering

Prevents the app user from filtering by this column.

It applies to the Listing and Mapping screens, among others.

Is Personal Data

This indicates that data captured in this column may contain personal or sensitive data, which can be anonymized when exported from the platform.

This option does not grant or imply additional security, protection and privacy of data.

Referring to a Data Source

This indicates that the cells of this column are expected to match values in the first column of the selected data source.

Specifying a referring Data Source allows the app to display a dropdown list of values in a Filter screen, amongst other things.

This lets you specify another Data Source that contains the set of possible values in the 1st column 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. 

Be sure to tick the Allow User To Filter By Column property on the screen you’d like to use this functionality.

1. Select the Search field
2. Tick the “Allow User to Filter by Column” property
3. Hit “Save” or “Publish” for changes to reflect in the app

Listing Screen

Mapping Screen

Filtering screens are accessed on your app via the Listing and Mapping screen types. They allow the app user to apply custom filters to the rows shown in a Listing or Mapping screen.

In-app, a user can now select:

1. Filter Options.
2. Brand (in this case) or the column header title of a column with a referring data source.
3. Expand a drop-down of the referring data source.
4. An option from the referring data source to filter by.

This provides a more cohesive user experience and is a faster, more error-free way for users to define their filters on Listing and Mapping screens.

Conditional Display Rules

Applies conditional display styling based on the value of the column.
Use our standard formula syntax to define a formula that has a true/false result.
To refer to this column’s value, use the {{this}} placeholder.

e.g. {{this}} = ‘Yes’

If true, then the style specified will be applied to the column value when it is displayed.

This opens up a new level of display customization for Data Source row values on your app.

Based on a formula result, you can define rules that make column values appear in different colors and text styles.

For example, you might have a Brand column or a Status column with three possible values: Good, Bad, and Ugly.  

Defining rules for these will let you highlight Brands or 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

The map pins displayed are colored, provided you have set your rules column as the Conditional Pin Color property in the Mapping screen designer.

1. Set the Conditional Pin Color property to the Conditional Display Rules column applied.

Listing screens

Colors the column text displayed, assuming you have the rules column set as one of the row display positions (Titles/Subtitles) in the Listing screen designer.

1. Select the Row field.
2. Set the Title or Subtitle properties to the column that has Conditional Display Rules applied.

You can also color the entire row’s background when setting the Conditional Background property to the rules column set in the data source.

1. Select the Row field.
2. Set the Conditional Background property to the column with Conditional Display Rules applied.

Forms screen

Specifically within the Choices fields that are set to display vertically, and using the List of Choices display style property in the Form designer.

1. Select the Choices field.
2. Set the Display Type property to List of Choices.
3. Set the Display Column to the data source column with Conditional Display Rules applied.

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.