Discussions

 View Only
  • 1.  "Contains" formula with colorization

    Posted 7 days ago
    This is what I am trying to do in a field called PRIME PT/UP DATE.COLOR

    If [PRIME PT/UP DATE] contains Monday, (red button with M)
    If [PRIME PT/UP DATE] contains Tuesday, (yellow button with T)...and so on

    I am using this formula in another field...but, I do not know how to include the "If Contains":

    var text ButtonColor = Case([Customer Initials],
    "SM","#808000", // olive green
    "KB20","#ffc966", // golden orange
    "NVR","#ede7d3", // cream
    "PUL","#003366", // navy blue
    "TRU","#ff884d", // peach orange
    "DWH","#004d99",
    "GRH","#00cccc");



    var text WordsColor = Case([Customer Initials],
    "NVR","black",
    "white");



    // Begin button style
    var text bgcolor = $ButtonColor;
    var text txtcolor = $WordsColor;
    var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; width: 45px; border-radius: 50px; padding: 3px 5px; color: " & $txtcolor & "; display: inline-block; font: normal 500 16px/1 \"Calibri\", sans-serif; text-shadow: none;";
    // End button style

    var text URL = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Customer ID#];


    "<a " & $style & " href=" & $URL & ">" & [Customer Initials] & "</a>"


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


  • 2.  RE: "Contains" formula with colorization

    Posted 7 days ago
    I have played around a bit.  Here is what I came up.  But, It is returning just the date instead of day of week "button

    Here is the formula:
    var text ButtonColor = If
    (Contains(ToText([PRIME PT/UP DATE]),"Monday"),"#808000",
    (Contains(ToText([PRIME PT/UP DATE]),"Tuesday")),"#ede7d3",
    (Contains(ToText([PRIME PT/UP DATE]),"Wednesday")),"#ede7d3");



    // Begin button style
    var text bgcolor = $ButtonColor;

    var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; width: 100px; border-radius: 5px; padding: 3px 5px; color: " & "; display: inline-block; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;";
    // End button style

    "<div "& $style &">" & [PRIME PT/UP DATE] & "</div>"

    //"<div " & $style & " " & [PRIME PT/UP DATE] & "</div>"

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