Color Coding Fields: Duration
I want to color code a field within a report, but the field is a Duration Type. Currently I am color coding within the report instead of just the field, but it's too much color and doesn't convey wha...
Forum Discussion
One more question: how do I change the font color? Some of the background colors I chose are too dark and the font should now be white. I did some research and tried this, but it didn't work. I am sure I am missing some syntax somewhere.
var text ColorCode =
If(
([Days in Discovery]) <Days(60),"#74A235",
([Days in Discovery]) <Days(90),"#90B433",
([Days in Discovery]) <Days(120),"#FFED44",
([Days in Discovery]) <Days(180),"#F9A900",
([Days in Discovery]) >Days(180),"#FF1100");
var text DateText = ToText (ToDays([Days in Discovery]));
Case($ColorCode,
"#74A235","<div style=\"background-color: #74A235; color: #FFFFFF;\"" & ">" & $DateText & "</div>",
"#90B433","<div style=\"background-color: #90B433;\"" & ">" & $DateText & "</div>",
"#FFED44","<div style=\"background-color: #FFED44;\"" & ">" & $DateText & "</div>",
"#F9A900","<div style=\"background-color: #F9A900;\"" & ">" & $DateText & "</div>",
"#FF1100","<div style=\"background-color: #FF1100; color: #FFFFFF;\"" & ">" & $DateText & "</div>", $DateText)
------------------------------
Elizabeth Schlagel
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendI believe that this code already in some of your formula controls the color.
color: #FFFFFF
#FFFFFF is black.
Try this for white
color: white
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------