Background Colour Column

This control allows users to set the background colour based on the colour value stored on a record. The value can be stored in text (e.g. pink, yellow, blue) or hex code (e.g. #FF0000, #00FF00, #00CCCC).

If you have a colour field in an eForm, [1] you can set the tabular report background [2] based on the value stored in the record.

Background Colour Rules

This control allows users to set the Background Colour based on a specific rule. Users can add multiple rules with different colours.

• Click X [1] to remove an existing rule.

• Click Add Rule to add a new rule [2].

• Click Remove All to remove all existing rules to re-configure the background colour rules.

• Click Edit on Condition [4] to set the rule.

• Click Edit on Colour [5] to enter a colour code to be used when the rule is met.

You will see the below screen when you click Edit on Condition.

1. Select the way you wish to set the condition. In this example, we use the Advanced [1] formula to set the condition.
2. Write the Formula [2] and then click Validate [3] to check if the formula is valid.
3. Click Ok to confirm the rule.

You will see the below screen when you click Edit on Colour.

1. Select Constant [1] in the dropdown.
2. Select String [2] to be used to set the value of the colour.
3. Enter Colour in Text or Hex Code [3]. We used Hexcode #ffb4b4 for this report.
4. Click Ok [4] to confirm the colour.

Text Colour Column

Similar to Background Colour Column, this allows users to set the Text colour of a row based on the colour value stored in a record. The value can be stored in text (e.g. pink, yellow, blue) or hex code (e.g. #FF0000, #00FF00, #00CCCC).

Select a colour field from the eForm to set the tabular report text [1] based on the value stored in the record. This colour will apply to the whole row of the report.

Text Colour Rules

This control allows users to set the Text colour on a row based on a specific rule. Please refer to Background Colour Rules to find out more information about adding or removing a rule.

Setting/ Editing a Rule

1. Click Edit on Condition [1] to set/edit the rule.
2. Click Edit on Colour [2] to set the colour of the text when the rule is met.

Setting the Rule using Operator

1. You will be presented with this screen when you click Edit on Condition [1]. In this example, we use Operator to set the Condition.
2. To edit the Left entity of the Operator click on Edit [2].
3. Select an Operator [3] to compare the Left and Right entities.
4. To edit the Right entity of the Operator click on Edit [4].
5. Click Ok [5] to confirm the condition.

Example

We would like to set up an example to check if anything in this record where the 'State' column is equal to 'VIC'.

We first need to set up the Left entity of the Operator. In this example, we would like to refer to a column on the current eForm.

1. Select Data Source eForm Column [1]
2. Select the Column State [2] to be used for the condition.

We then need to set up the Right entity of the Operator. In this example, we would like to check if the Left (State column) has this Value.

1. Select Constant [1] from the dropdown.
2. Select the value data type String [2].
3. Enter a value 'VIC' [3] in here.

The Condition will look like the below once it is successfully set up.

The next step is to Edit Colour: if State is equal to 'VIC', set the text to RED.

1. Select Constant in the dropdown [1].
2. Select String [2] from the dropdown.
3. Enter colour in Text or Hex Code. In this example, we use the text 'Red' [3].

The report will look like the below: