Here are my notes about the best i figured out with coloring a calendar.:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I just thought I would post this answer to an old question as I needed to figure it out for a client.
Ensure that the calendar is showing a link to the entry and not just �text�
While coloring the background did not work for me (it cause strange extra line breaks), and coloring just the font sort of worked, but then the additional fields that listed did not render properly and caused extra line breaks, this did work for me.
I created my own concatenated field of the three fields which I wanted to show in the calendar and just listed this one concatenated / colored field. My goal here was to color the Hourly warehouse staff in a different color from the other Salaried staff.
var text NameDaysReason =
List(" | ", [Common Name & Initial],ToText([# Days]),[Reason]);
If([H S D]="H", "<b><font color = #A52A2A>" & $NameDaysReason & "</font color></b>", $NameDaysReason)
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
