Skip to main content
Question

Colorize words

  • May 10, 2022
  • 0 replies
  • 45 views
Forum|alt.badge.img+11
I am trying to create a field where the words are colorized based on day of week.

FIELD NAME: [SKIM DATE COLOR] equals FIELD NAME: [SKIM DATE DAY]
FIELD TYPE: RICH TEXT FORMULA

Then, I want the this date field to have the words (for example(Friday, May 13)) to be colored based on the day of the week.

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

MarkShnierYou
Forum|alt.badge.img+24
Colourize the words or the background shading?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
MarkShnierYou
Forum|alt.badge.img+24
try this

var date MyDate = [SKIM DATE DAY];

var text DayName = Case(DayOfWeek($MyDate),
0,"Sunday",
1,"Monday",
2,"Tuesday",
3,"Wednesday",
4,"Thursday",
5,"Friday",
6,"Saturday");



var text DateWords =
$DayName
& ", "
&Case(Month($MyDate),
1,"January",
2,"February",
3,"March",
4,"April",
5,"May",
6,"June",
7,"July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December")
& " "
&ToText(Day($MyDate));

var text Color = 
Case(DayofWeek([SKIM DATE DAY]),
0, "red",
1, "orange",
2, "purple",
3, "blue",
4, "black",
5, "green",
6, "brown");

"<font color=" & $Color & ">" & $DateWords



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement