Format Data

Column formatting

For Connectors as well as when using the output of the Lookup formula you would get different types of data from the respective sources. Now typically if you are presenting data in a Table grid control or any card control you would prefer to make it visually appealing.

You have the option of applying conditional formatting or data type-specific formatting in Studio using the Format Data feature or property available for the table grid control, the detail view control, and the different card controls like compact card, single-user card, long card, and so on.

The formatting options would differ based on the type of data. At times you may also apply formatting based on a condition. Now let see the different types of formatting available.

Conditional Formatting - Conditions

Typically conditional formatting involves providing the condition to check with the column data and then apply the selected formatting options.

The condition available are as follows:

Condition Data type Description
IsEmpty Text
Date
Time
Datetime
Numeric
Decimal
If the cell is Empty/ does not contain data then applying a certain format.
IsNotEmpty Text
Date
Time
Datetime
Numeric
Decimal
If the cell is not Empty / contains data.
Equal Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is exactly equal to a certain value
Not Equals Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is not equal to a certain value
Contains Text If the cell value contains a specified sequence of characters.
Not Contains Text If the cell value does not include a specified sequence of characters.
Starts with Text If the Cell value begins with the specified sequence of characters
Does not start with Text If the Cell value does not begin with the specified sequence of characters.
Ends with Text If the Cell value ends with the specified sequence of characters.
Does not end with Text If the Cell value does not end with the specified sequence of characters.
Greater than Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is more than specified value.
Less than Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is smaller than specified value
Greater than equal to Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is more than or equal to specified value.
Less than equal to Text
Date
Time
Datetime
Numeric
Decimal
If the cell value is smaller than or equal to specified value.

You can use either of these conditions in the specific column. If the condition is true the formatting is applied to that cell/ column data which could include updating the cell with options like bold, italics, underline, strikethrough, cell background color, text color, and icon color.

Text

Text data types include conditional formatting based on filters/conditions applied to the respective data. The data of the column being formatted should be text or string type data.

Conditional formatting

You would specify the condition to check the text type data for a column and if the condition is True, the specific formatting is applied. You can refer to the conditions that can be applied to your text data type in this table here.

Number and Decimal

For the Numeric and Decimal data, you can add either of the following format types: Format, Prefix / Suffix / Conditional formatting.

Format

Includes options to use the cell values as normal integers or use the Currency or Accounting format.

Prefix / Suffix

You can add a Prefix or a Suffix to your numeric values. Typically it could be a specific currency symbol or it may be a particular sign like say a percentage symbol associated with numeric values.

Conditional formatting

In case you need to check each value based on a condition like say value is more than or equal to a certain amount and apply a format then you can make use of the Conditional formatting. You can refer to the application conditions that can be used in this tablehere.

Toggle

When you have toggle switches to indicate data like say like/dislike, star rating, toggle switch on or off, and so on. Here the formatting available is selecting the styles as a toggle switch, star, heart, like/dislike/ checkmark, or flag.

Styles

You can provide the different styles of toggle symbols like the default one and also use different colors for them.

Simply select the style icon and color and click Apply.

Single select and Multi-select

Both single and multi-select have the formatting to define Options and then add colors to categorize each type of option.

Percent

To format the Percent type data you can provide the Limit between which the percentage amount would be formatted

Limit

You can provide the Minimum and Maximum limit value between which the cell would data would be shown in the default color set for the property.

  • Select a column that contains percentage type data.

  • Goto Format Options. In case of Percentage type, you need to specify the Limit for which the formatting would be applied.

  • Specify the Minimum and Maximum limit values.

  • You can see the toggle switch to display the Progress bar. So now if you Switch it ON the progress bar would be displayed in the column in the table grid.

    By default, you can see that any value below the minimum limit is indicated with Red colored progress bar, anything within the range is indicated with Blue colored progress bar and those above the maximum limit is indicated with the Green colored progress bar.

    tablegrid enahnce

Rating

For Rating, you can add different Styles to express the kind of rating you are indicating.

Style

You can set the icons like star, heart shape, etc. and set the color for each of the types, and so on, and also provide the maximum number of icons to add to provide the rating degree and also use different colors for them.

URL, FileUpload, Email, TextArea, JSON Object, GeoLocation

There would be no formats for these data types.

You can refer to this article here to see how to use the data formatting for Connectors.

Also, refer to this article to know more about using the data formatting when using LOOKUP formula for a Table grid control.