"Contains" formula with colorization
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)......
Forum Discussion
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
------------------------------
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
------------------------------