How do I add color to this field
[WALL PAINT] (If 1 color is true, blue. If 2 Color is true, green)
If([1 Color]=true,
List("_", [Wall Color],[Related Projects - Wall Paint]),
[2 Color]=true,
List("_", [Wall Color],[Related Projects - Walls-2 Color Paint]),"")
Qrew LegendHere 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)
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?
Qrew LegendIF(
[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]))
