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
MarkShnier__You
Qrew Legend
Qrew LegendYou will need to create. New formula Rich Text field for your report. Here re some cheat notes I have.
| Background Shading |  |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| https://help.quickbase.com/user-assistance/color_field.html Background Shading var text ColorCode = If( [Delivery Date]-Today()<Days(1),"pink", [Delivery Date]-Today()<Days(3),"yellow", [Delivery Date]-Today()<Days(5),"green"); var text DateText = ToText([Delivery Date]); Case($ColorCode, "pink","<div style=\"background-color: pink;\"" & ">" & $DateText & "</div>", "yellow","<div style=\"background-color: yellow;\"" & ">" & $DateText & "</div>", "green","<div style=\"background-color: #00C957;\"" & ">" & $DateText & "</div>", $DateText) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Mark! This is really helpful. I am now receiving an error due to the <div> expecting a different type, but if I remove the ToText to keep the type expectancy, then I get a different error:
Error: Expecting duration but found text.
Error: Expecting text but found datetime
------------------------------
Elizabeth Schlagel
------------------------------
- MarkShnier__You
The field type needs ot be Rich Text, not Duration.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------That worked! Now how do I get it to still do the original formula I needed it to do to should # of days between the timestamp and today. Now that I switched it to this formula, the color coding works, but it shows me the timestamp and not the number of days.
------------------------------
Elizabeth Schlagel
------------------------------This is what the report looks like now:
------------------------------
Elizabeth Schlagel
------------------------------