Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

Concatenated field with color - formula assistance

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, ...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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
------------------------------
BuildPro's avatar
BuildPro
Qrew Captain
2 years ago

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__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    2 years ago

    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
    ------------------------------
    • BuildPro's avatar
      BuildPro
      Qrew Captain
      2 years ago

      Thank you. Worked perfectly.



      ------------------------------
      BuildPro
      ------------------------------