Forum Discussion

JenniferSilbers's avatar
JenniferSilbers
Qrew Trainee
3 years ago

Trying to alternate row colors based on creating a new row number

Hello, I am trying to create a report that has alternating colors for the rows.  I can't us the record Id because the Record ID is not in sequential order when filtered (as seen below).  I have bee...
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
Interesting question. There may be a solution using formula queries. Can you tell me the sort on your report?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Assuming that the sort is by Date and then by Record ID# as a tie breaker, then thisw formula Numeric will give you the Row #

var text Query = "{69.LTE.'" & [Date] & "'} AND {3.LTE.'" & [Record ID#] & "'}";
Size(
GetRecords($Query))

Once you get that working, you can have a row colorization formula like 

IF(REM([Row#],2)=0, "pink", blue")
​

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    BTW, the 69 in my example is the Field ID for the Date field and the 3 is the Field ID for the Record ID# field (which is always 3).

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------