Forum Discussion
QuickBaseCoachD
11 years agoQrew Captain
I have never been able to successfully color the background. on a calendar but if you just have one field on caleder, then you can color the text.
In these two separate examples I am making a concatenated field of the fields I want to show and then coloring the font (not the background)
Example 1
var text NameDaysReason = List(" | ", [Common Name & Initial],ToText([# Days]),[Reason]);
If([H S D]="H", "<b><font color = #A52A2A>" & $NameDaysReason & "</font color></b>", $NameDaysReason)
Example 2
var text TextBlock=
List(" | ",
"<b>" & If([Start Time]<ToTimeOfDay ("10:00 am"),"0") & ToText([Start Time]) & "</b>",
[Physician : Location : Report Type],
[Patient Name / Available]);
If(
Begins([Appointment Status],"No Show"),"<font color = red>",
Begins([Appointment Status],"Cancel"),"<font color = red>",
[Patient Name / Available]="Available","<font color = green>") & $TextBlock
In these two separate examples I am making a concatenated field of the fields I want to show and then coloring the font (not the background)
Example 1
var text NameDaysReason = List(" | ", [Common Name & Initial],ToText([# Days]),[Reason]);
If([H S D]="H", "<b><font color = #A52A2A>" & $NameDaysReason & "</font color></b>", $NameDaysReason)
Example 2
var text TextBlock=
List(" | ",
"<b>" & If([Start Time]<ToTimeOfDay ("10:00 am"),"0") & ToText([Start Time]) & "</b>",
[Physician : Location : Report Type],
[Patient Name / Available]);
If(
Begins([Appointment Status],"No Show"),"<font color = red>",
Begins([Appointment Status],"Cancel"),"<font color = red>",
[Patient Name / Available]="Available","<font color = green>") & $TextBlock