Display

The Display section allows you to specify how the column header and their values should be displayed based on your needs.

Go to Setup > Columns.

Accessing the 'Columns' section

Click on the pencil icon beside the column name or double-click on the column name. Go to the Display tab.

Display properties

Here, you can add and configure various display properties, such as the date format, display name, thousand separator, prefix, and suffix.

1. Format

Using the Format property, you can define how the date and date-time values should be presented in the columns. You can choose from various date and date-time formats such as 'MM/DD/YYYY', 'DD/MM/YYYY', 'DD MMM, YYYY hh:mm:ss', and so on.

Date format

2. Display Name

The Display Name property enables you to display a user-friendly name for the column header, different from the actual field name in the database. For instance, the 'ProductSubcategoryKey' field in the database can be displayed as 'Customer ID' in the visual for enhanced clarity.

Display Name

3. Description

You can use the 'Description' field to include additional information in the column headers, helping users understand the data better. An 'i' icon is added beside the header name, and when you hover over it, the additional description is shown.

Description

4. Thousand Separator

By default, numbers in the column are displayed continuously without any thousand separators. To enhance the readability of large numeric values, you can add a comma, a period, or a space as a separator for every group of thousands.

Thousand separator

5. Prefix

This property allows you to add a prefix of up to two characters before numeric or decimal column values. This is commonly used to indicate currency symbols.

Prefix

6. Suffix

This property lets you add a suffix of up to two characters after numeric or decimal column values. This can be used to indicate measurement units like kilograms, centimeters, and percentages.

We have now discussed all the column properties that can be configured from the Columns section. In the next section, we will look at other options, such as importing/exporting configurations and adding columns.