10/12/2011 5:49:35  Tip of the day: #GetProductive by setting Flags WITH alarms in Lotus Notes

@1, Keith: Great follow-up post mate, now if only IBM allowed users to choose those colours themselves, instead of having to change the template's design. THAT is something that Outlook users CAN do.

10/12/2011 8:39:06  Showing Follow-Up’s in the Calendar

@3, Martin: Sure you can, it's just Data, and it's in Notes, so you can do just about anything :-)

Seriously though; you need designer access to the Mail Database to add this feature. A message that's been marked with a Follow-up will have a number of additional fields in it, the key one's for Calendar integration being FollowUpDate and FollowUpTime. Every calendar entry in your Notes Mail Database has a combination of CalendarDateTime, a StartDate and StartTime. You can include Messages marked with Follow-ups simply by modifying the design of the ($Calendar) views selection formula in your Mail database to include records that have the FollowUpDate field in them. Simply change the ($Calendar) view's select criteria to:

SELECT @IsAvailable(CalendarDateTime) | @IsAvailable(FollowUpDate)

Once those records (the Notes that include the Follow-Up flags) are included in the view, change the FIRST column to include @IF formula's to cater for FollowUpDate/FollowUpTime wherever you see a reference to CalendarDateTime, StartDate or StartTime, like this:

StartTime :=@If(@IsAvailable(FollowUpDate);FollowUpTime;@Time(CalendarDateTime));

Datelist:= @If(AppointmentType="2";@Explode(@TextToTime(@Text(StartDateTime) + "-" + @Text(EndDateTime))) ;

@Explode(@TextToTime(@Text(CalendarDateTime) + "-" + @Text(EndDateTime))) );

@If(@IsAvailable($CSVersion) & @IsAvailable(TaskType); @TextToTime(@Text(DateList)+ " " + @Text(@Time(CalendarDateTime))); AppointmentType = "0":"1":"2":"3":"4";CalendarDateTime;@IsAvailable(FollowUpDate);@TextToTime(@Text(FollowUpDate) + " " + @Text(FollowUpTime));@TextToTime(@Text(DateList) + " " + @Text(StartTime)))

If you need more information, message me by using the "About.Me" link on this page.