Conditional Formatting

WorkWithPlus provides the possibility to format a row of the grid in relation to certain condition. Also, you can format just one column or add a badge column.

 

Row & Add Tag Column Formatting

Each Grid has a property named 'Conditional Formatting'.

ConditionalFormattingImg01

When clicking in this property the following window will be displayed:

ConditionalFormattingImg02

Formatting type:

Specifies if the formatting will be by row or if a badge column will be added when the condition accomplishes. This is the first property to configure when adding conditional formatting to a grid.

Then, you have to add conditions, and for each condition specify which format you would like to apply to records which accomplishes that condition.

Click in Add button and insert the condition:

ConditionalFormattingImg03

After you select one format the row with the condition will show you a preview of what it will look like:

ConditionalFormattingImg04

The options available in the format are the ones defined in WorkWithPlus Settings -> Grid -> Properties Row Formatting Conditions and Badge Formatting Conditions

You can add all the conditions you would like and the order of them is important because that order will be used for analyzing the conditions (the first condition accomplished is the one that will be assigned, when a row accomplishes more than one condition).

At runtime, the grid will look like the following image:

ConditionalFormattingImg05

The same example, using formatting type 'Add tag column'. For example you can use 'Icon - Badge' (among others). It will be displayed like follows:

ConditionalFormattingImg06

And at runtime: 

ConditionalFormattingImg07

Column Formatting

It´s analogous to Row Formatting with the difference that the property Conditional Formatting will be on each column of the grid (attribute or variable).

ConditionalFormattingImg08

And at runtime:

ConditionalFormattingImg09

Runtime formatting

Feature included as of WorkWithPlus for Web 15 Upgrade #2.
 

Added the 'Dynamic variables for Conditional Formatting' property, in which you can add variables and then use them in Conditional Formatting conditions.
These variables will have a description and a default value. Additionally, you can choose who can edit the default value of the variables, whether any user or an administrator.

ConditionalFormattingRuntime02

 

Then using these variables in the conditions.

ConditionalFormattingRuntime01

 

During execution, in the Title Filter, you will see the filters created for these 'Conditional Formatting', which you can edit in the 'Settings' button for the values you want at runtime and those values will be maintained.

ConditionalFormattingRuntime03


This property is available for columns (Attributes and Variables) and in the grid, both places where you have Conditional Formatting.