Formula: Color Coding and Dates
Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic inform...
Forum Discussion
Thank you! Do you know if there is a way to color code the numbers in a field? For example, an employee has worked for 5-10 years the field would be green, etc.
MarkShnier__You
Qrew Legend
Qrew LegendJust want to colour a single field it's a little more complicated than XL. You're actually need to create a formula rich text field and use a formula as described here.
https://help.quickbase.com/user-assistance/color-coding_fields.html
Here is another example
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 (YQC)
mark.shnier@gmail.com
------------------------------
https://help.quickbase.com/user-assistance/color-coding_fields.html
Here is another example
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 (YQC)
mark.shnier@gmail.com
------------------------------
