Color Code

From AgileApps Support Wiki
Revision as of 22:08, 11 August 2011 by imported>Aeric (→‎How it works)

This conditional color code function highlights rows based on the user-defined conditions in Views and Reports. Any number of conditions can be added for a variety of colorized views into your data.

Records that match the selected criteria will have that color applied. You can select multiple criteria to create multiple color codes in a report. Color coding applies to Views and Tabular Reports only, not Matrix or Chart Reports.

How it works

  1. Select a data field
  2. Define a true/false condition
  3. Choose a color from the color palette

Up to 10 conditions can be specified.

A typical condition might be "Status is equal to In Progress", or "Expected Revenue is greater than $1000".

When the condition is true, that row will be highlighted in the color you choose.

Exceptions

Some field types cannot be used for color coding, including:

  • Lookups and Related to Lookups
  • Dependent Multi-Fields
  • Multi-Checkbox
  • Multi-Picklists
  • Rich Text Areas
  • File and Image fields
  • Multi-Select Lookups