Color code a record in a report

Question

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------------------------------

markshnier__you · Answer

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)
[email protected]
------------------------------

Forum Discussion

Color code a record in a report

1 Reply

Related Content

Qrew Tip: Calculations per Record

Record picker behavior with preselected values not on filter report

Totaling Child Records Live on Parent Using New Form and New Grid Reports Locking Parent Record

Report Dynamic filters

Deleted records and record pickers / Formula check if related record has been deleted