Forum Discussion
- MarkShnier__YouQrew Legend
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
------------------------------- BuildProQrew Captain
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?var text MyConcatenatedFields =List(" | ",(ToText([Related Projects - Neighborhood Name])),[Lot #]);If([Related Projects - Neighborhood Name]="Jameson Place","<b><font color=#8e865c>"& $MyConcatenatedFields & "</font color></b>",[Related Projects - Neighborhood Name]="Freeman Farms","<b><font color=#006633>"& $MyConcatenatedFields & "</font color></b>",[Related Projects - Neighborhood Name]="Timberleaf","<b><font color=#6ca97c>"& $MyConcatenatedFields & "</font color></b>",
------------------------------
BuildPro
------------------------------- MarkShnier__YouQrew 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
------------------------------