Page tree
Skip to end of metadata
Go to start of metadata

Introduction

Element

Description

Introduction

TIS Board supports the conditional formatting (e.g., application of color schemes, the use of symbols for specific values) of columns in a number of ways:

  1. Standard color schemes (e.g. traffic color lights)
  2. Generic color schemes

    This is possible in the Simple Grid and in the Editable Grid

Example

The following example shows three standard color schemes:

  1. Traffic light (0=red)
  2. Traffic light (0=green)
  3. Coded Trend (01234)

Tips I

  • To see the original values add an additional column of data.
  • Conditional formatting can be combined.

Tips II

The operator Traffic lights helps you to define threshold values depending on the time of day & the day of week with up to 5 thresholds.

More complex codings can be made with the formula operator or the merge tables operator.

Steps to use the special formats

Steps

Description

Prepare

In TIS Editor prepare the data.
In the Portlet Designer create a Simple Grid or an Editable Grid

Select column

In the Portlet Designer select a column on the right hand side of the window:

Select format

Select format:


Clicking the Button will add a special format

Causes the column to be formatted differently

Notes

  • Special formats are removed by pressing the symbol.
  • Special formats can be combined. The following example shows traffic lights and trend used in one column.

Standard special format types

 

Predefined special format typesType

Element

Description

Traffic light 1

Results in a coding of 0 = red traffic light.

Traffic light 2

Results in a coding of 2 = red traffic light.

Trend (0-4)

Results in a coding trends (0 = strongest)

State (0-Error, 1-OK)  
Hide zero values  

Generic special format types

Steps

Description

 

Select the action for a generic element

Select special format GENERIC and the

e.g. add action change of foreground colour

 

Conditional color - Example

The following settings:

Produce:

Conditional formatting selection of icon

You can choose from a large set of existing icons or upload your own icons (needs administrative rights).

 

Generate Hyperlinks in Grid

Grids do not support HTML hyperlinks such as <a href="https://blabla.bla">Link</a>.

Note that this kind of markup works in the TIS Editor details view.

StepsDescription
Add a new special format type

Click (plus) icon for adding

Select ActionConvert entry to link
 

Link Texttext that is shown in the grid
From / To

range of strings that will be converted to a link.

Change foreground or background color of a whole row

StepsDescription
Select Action

New options

  • Change row foreground color
  • Change row background color

  • No labels

2 Comments

  1. FLEX-393 - Getting issue details... STATUS

  2. FLEX-1675 - Getting issue details... STATUS