Skip to main content
Question

Color code a record in a report

  • September 13, 2022
  • 0 replies
  • 36 views
Forum|alt.badge.img+1
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement