Forum Discussion

AlanTibor's avatar
AlanTibor
Qrew Member
2 years ago

Color code a record in a report

Hello QB SME's!!

I need help - I have a date field in a record that I need to color code based off of.
I need to color code records that are 45 days past the date in the record; AND I need to color code (in a different color) records when the date in that field is 30 days past TODAYS date!!

Please help!!

------------------------------
Alan Tibor
------------------------------

1 Reply

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    On a Table report you can use a row Colorization formula.

    IF(
    Today() > [Date in the record] + Days(45), "Red",
    Today() > [Date in the record] + Days(30), "Yellow")

    There is a great choice of colors here, you can use the hex codes instead of the color names.

    https://laurahillier.quickbase.com/db/bhy8pumuk?a=q&qid=-1000000&dr=1

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------