Page 1 of 1

Highlighting Specific Days on Month View

PostPosted: Fri Sep 03, 2010 9:33 am
by compubooks
I was wondering if the Pro Calendar version offers the ability to highlight specific days with different colors on the Month view. For example, today's date is highlighted in yellow. We are wanting to be able to highlight holidays, or special events days with different colors. We don't want to change the colors of the events, just the day's background.

Thanks,
Robert

PostPosted: Sat Sep 04, 2010 7:49 am
by John Sindelar
Hey Robert,

Good question, but this isn't built in. The day's background is highlighted with conditional formatting, and currently those calcs just look to see if the day is today (yellow) or outside the current month (pale blue).

Now you could change that calc to look for other things, like the day being in a list of holidays, but I think you'd see some real performance hits. That calc runs often in SeedCode Calendar (over 252 times in the month view) and it is currently VERY optimized. Having it reach out to global data could really add some drag. But you can try it, our video on working with tabs shows how to "unstack" the calendar fields and get at the conditional formatting: http://www.youtube.com/watch?v=UGsf9egCWiI

A simpler way to do holidays is to create them as events. (You can get a little fancier by treating them as their own source, but that has performance penalties as well.) A final refinement, if you have a lot of events, is to change the calendar's sort order to holidays are always drawn at the top of the list of all day events. You can change that in the script "Sort FileMaker Records --- Edit Sort Orders Here ---"

Hope that helps,

John