Forum Discussion
QuickBaseCoachD
10 years agoQrew Captain
here is an example of a formual to put three fields on a calendar in color
var text TextBlock=
"<b>" &
List(" | ",
[Quote - Project] ,
[Installer Name],
If([Planned Business Days to Install]>1, ToText([Planned Business Days to Install]) & " days", ToText([Planned Business Days to Install]) & "day")
& "<br>" &List("|", [Customer Name], ToText([Related Quote])))
& "</b>";
"<span style=\"background-color:" & [Color Code] &";\">" & $TextBlock &"</span>"
In my setup, the field for [Color code] is a lookup field that has like #FFF000 or whatever the hex code is for the color.
var text TextBlock=
"<b>" &
List(" | ",
[Quote - Project] ,
[Installer Name],
If([Planned Business Days to Install]>1, ToText([Planned Business Days to Install]) & " days", ToText([Planned Business Days to Install]) & "day")
& "<br>" &List("|", [Customer Name], ToText([Related Quote])))
& "</b>";
"<span style=\"background-color:" & [Color Code] &";\">" & $TextBlock &"</span>"
In my setup, the field for [Color code] is a lookup field that has like #FFF000 or whatever the hex code is for the color.