I have little experience working with the Calendar style view but am trying to do something that I’m suprised I can’t. It appears as though the calendar entries color is set in the view property so all entries would end up being the same color. How can I use a different color based on some criteria? Like if a different form is used, or a specific category is chosen in a field, etc? Is that possible? In the personal calendar they have multiple colors for different entry types but I just don’t see how to do it in the designer.
Subject: Calendar Entry Colors
I assume (I think I never checked it) that colored entries are done the same in calendar views as in regular views. There is an option to load the value of a color column from a profile document rather then from the column value itself. Don’t remember off hands, but I think the column must contain the profile name or so.
Check the column properties and Designer help should provide the details (just try clicking the question mark on the right tab).
Subject: RE: Calendar Entry Colors
Yes, you can use colors from a profile document, or coded into the column - just use the display column as color checkbox on a column you insert BEFORE all the existing columns in the calendar view. I’ve done this so that appointments, meetings, reminders, and holidays all display in different colors.
Subject: RE: Calendar Entry Colors
I’m still a little confused. I thought Calendars typically only had two columns. The first column on a calendar view had to be the date range and the second column showed what was displayed in that range (like a label).
Subject: RE: Calendar Entry Colors
I got it now, thanks a lot for the help!
Subject: RE: Calendar Entry Colors
search designer help for column colors- I have a column w/ this formula in it:white := 255:255:255;
black := 1:1:1;
apricot := 255:155:133;
plain:= 0:0:0;
@If(Form = “Product” & Publish = “0” & DateAvailable < @Today;red;
Form = “Product” & Publish = “0” & DateAvailable>= @Today;blue;
Form = “Product” & Publish = “1”;black;apricot)
Subject: RE: Calendar Entry Colors
In fact, examples in Designer help and especially Lotus courseware are not too brilliant.
What’s the meaning of “plain”? What would you expect from the name of the variable? In reality, 0:0:0 is simply black (and 1:1:1 is not).
What it is was probably meant to mean is: Use the views default colors as defined in designer. Can be done, but the correct value is -1:-1:-1 (which Designer in turn will incorrectly as -1; 1; -1 in the preview).
The whole profile document stuff is only needed, if you want to make the colors user configurable. Mostly, this makes sense for user specific databases (like mail), only.
Subject: RE: Calendar Entry Colors
Well of course, I copy the color code from help and add in other colors-- I was reading help on this the other day and found you can do background and text color, separating them w/ a colon.
Subject: RE: Calendar Entry Colors
Yep, but only if both are of the same datatype, either text or numbers. E.g. you cannot combine
red := “FF0000”;
grey := 220:220:220;
Which shouldn’t really surprise us: The colon still just works as a list operator.