Forum Discussion
Here are my cheat notes on 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
------------------------------
How do I get this to work with the IF function formula. Also, I want the text to be colorized, not the background.
thank you
I have used this for another field..but I don't know how to incorporate with the formula in the WALL PAINT field?
------------------------------
BuildPro
------------------------------
- MarkShnier__You2 years agoQrew Legend
IF(
[1 Color]=true,
"<font color=red>" & List("_", [Wall Color],[Related Projects - Wall Paint]),
[2 Color]=true,
"<font color=red>" & List("_", [Wall Color],[Related Projects - Walls-2 Color Paint]))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- BuildPro2 years agoQrew Captain
Thank you. Worked perfectly.
------------------------------
BuildPro
------------------------------