Skip to main content
Question

Concatenated field with color - formula assistance

Forum|alt.badge.img+11

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

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement