AgileApps Support Wiki Pre Release

Difference between revisions of "Color Code"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 1: Line 1:
This conditional color code function highlights rows based on the user-defined conditions in [[Reports]]. Any number of conditions can be added to color your data. Records that match specified criteria have the selected color applied.  
This conditional color code function highlights rows based on the user-defined conditions in [[Reports]]. Any number of conditions can be added to color your data. Records that match specified criteria are displayed with the selected background color.  


;Considerations:
;Considerations:

Revision as of 23:39, 12 June 2014

This conditional color code function highlights rows based on the user-defined conditions in Reports. Any number of conditions can be added to color your data. Records that match specified criteria are displayed with the selected background color.

Considerations
  • Color coding applies to 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