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,
List("_", [Wall Color],[Related Projects - Walls-2 Color Paint]),"")



------------------------------
BuildPro
------------------------------
  • 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

      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

        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
        ------------------------------