Page 1 of 1

Projects on calendar, and "late" flagging

PostPosted: Tue Jan 11, 2011 12:57 pm
by guido
1. Using your alternate summary calc., I can make an event show as a multi-line display on the Calendar. How can I do the same thing for Project-related events? Right now, the Project name shows first on the calendar, not leaving enough room to see the related project event detalls. Even when I make the project task last for several hours, the Calendar only has enough space for the Project name.

2. What would your “best practice” be for making "past due" items clearly visible—say, highlighted in red? Conditional formatting based on a due date field? I don’t want to edit the event to say it is late—I want to see that it is late.

Re: Projects on calendar, and "late" flagging

PostPosted: Tue Jan 11, 2011 5:22 pm
by John Sindelar
I'm not sure I follow Guido: project based events use the same summary calc as events that don't have a project associated with them and you can manipulate that calc to show whatever information you prefer, in whatever order you prefer. So just play with that calc until you get the kind of display you like: and don't be afraid to have the calc behave differently for events with an _id_Project.

This is also one of the simplest places to deal with coloring of past due events: just add some text coloring right in that calc if the event is over due.

But while I understand that you don't want to have to tag the event as overdue yourself, relying on a calc like this will have performance penalties if you have tons of records showing at once. To get past this you might have a server side script tag relevant events as "late" every morning, and the have auto-enter calcs untag them as their status changes.

Hope that helps,

John

Re: Projects on calendar, and "late" flagging

PostPosted: Tue Jan 11, 2011 7:42 pm
by guido
Got it--many thanks!