Skip to main content
Question

Coloring alternate row

  • December 21, 2016
  • 0 replies
  • 106 views

Is there a native way to colour each alternate row in a timeline report? 
This topic has been closed for replies.

  • Registered
  • March 16, 2017
Natively and Perfectly, no.

But here is a sneaky workaround for another option.

If(Rem([Record ID#], 2)=0, "#EvenColor", "#OddColor")

This will basically will devide the record id by 2 and if there is no remainder, then it will color one, or the odd color.

It works as long as you have one of the sorting things to go by record ID, first or last.

Or if you have some field that sequentially grows you can use that as well.

Just Ideas.

  • Registered
  • March 17, 2017
Matthew - this is brilliant in its simplicity. Love it. =]

Forum|alt.badge.img
  • Registered
  • April 4, 2017
Hi there, 2 questions - can you colour rows dependent on the resource (assigned to) using a variation of the above? Secondly, where do you put the code??

  • Registered
  • April 4, 2017
If your "assigned to" resource is via a relationship,...

Create a new field on the resource table, call it something like [Color]
Put the custom color hex (#xxxxxx) there, then pass that value to the main table (tasks or jobs, whatever you have it called).

Then in the report settings you can select the checkbox for 'colorization' towards the bottom, the simply insert that new lookup field [Resource - Color]