Skip to main content
Formatting Fields

You can pre-determine a datas format depending on the data by formatting the field.

Dan Thody avatar
Written by Dan Thody
Updated over a week ago

If you are unsure as to what a field of data is, then click here to find out more.

Once you have selected a field to show, you can customise the formatting settings. This allows you to change its basic formatting as well the ability to add rules that pre-determine the formatting when data meets those rules.

(if price is over £1.00 change its colour for example)

To edit the formatting of a field, simply click the paint brush icon to the right of the field name.

Styling

Here you can set the fields background, field active background and field active text colour.

Basic Formatting

The basic formatting option will set the format of the selected fields data. There is also a  'Scroll text' option which only applies to 'Text, List or Date'.
For our example we want to format this field to 'Currency'.

  • 'Text' - Formats the data to be shown exactly how it is written in the source.

  • 'Number' - Only applies to numbers - Formats the data as a number, can set the amount of decimal places and the thousands separator. (if decimals is set to 0 or left blank, numbers will be rounded to the nearest whole number - 0.9 = 1, 1.2 = 1)

  • 'Percentage' - Only applies to numbers - Formats the data as a percentage with the percentage symbol, can set the amount of decimal places and the thousands separator. (0.9 = 90%, 1.2 = 120%)

  • 'Currency' - Only applies to numbers - Formats the data as a currency, can set the amount of decimal places, thousands separator and choose the currency symbol. (0.9 = £0.90, 1.2 = £1.20 if decimals is set to 0 or left blank, numbers will be rounded to the nearest whole number - 0.9 = £1, 1.2 = £1)

  • 'Media' - Can edit some basic media settings which will occur if media is shown

  • 'List' - Will format the data as a list, separating the data into a new list item at every comma

  • 'Date' - Will format the data as a date & time stamp. (data must be configured as a date and time in source)

Conditional Formatting

Conditional formatting is where you can set rules that will pre-determine the formatting settings of the data that meets these rules. As seen on the conditional formatting area, 'If more than one rule matches with the same action, the last will be used'.

  • Add a rule - Click 'Add rule'

  • Configure the rule

Select a query from the drop down menu. This will be the query that the rule uses to check against the field you are formatting. The next input box is where you enter the specified value.

If you would like to find out more regarding these queries, click here.

  • Set formatting

Select the formatting option you wish to edit if the rule is matched. The next input box is where you specify which text, colour the data changes to or set the settings for the media.

The options you can select are:
'Show text' - If the rule is matched, change the text to the value specified in the next input area.
'Show media' - If the rule is matched, show the media item selected.
'Change row text colour' - If the rule is matched, change the entire rows text colour to the colour selected in the next input area.
'Change field text colour' - If the rule is matched, change the fields text colour to the colour selected in the next input area.
'Change row background colour' - If the rule is matched, change the entire rows background colour to the colour selected in the next input area.
'Change field background colour' - If the rule is matched, change the fields background colour to the colour selected in the next input area.

Animations

Animations can be added by choosing the animation type and time delay.

In our example below, we are going to change the text colour of all of the 'Price' fields to green if the price is over £1.00 (1).

As you can see, when we preview our layout, the two prices about £1.00 now have a green text colour.

Did this answer your question?