So I was tasked with an In/Out board for a small team - lovely, aside from the many questions I have to the requester, who asked that it be integrated with the induhviduals calendars, I've got a little best practices/how to question or two.
The core issue is I have no way of knowing if someone is physically in or out based on calendar entry - just because I have a conf call on my calendar doesn't necessarily mean I am in the office or not, but never mind these sorts of issues :-).
So, I have an agent that goes and gets all the user's calendar entries, well, just the pieces I need.
The problem -
Given a calendar entry - i have Start Times, End Times, and the CalendarDateTime.
So I have a form (employee), with the employee's name, and a few fields, date /time ranges, subject
Multivalue Date field: StartDT
Data: 10/01/2009 10:00:00 AM, 10/01/2009 11:00:00 AM, 10/01/2009 04:00:00 PM
Multivalue Date field: EndDT
Data: 10/01/2009 10:30:00 AM, 10/01/2009 01:00:00 PM, 10/01/2009 04:30:00 PM
Core question - At any given time of day, easiest way to return just a simple - "Busy or Not"
The date will always be for just "today".
Ideally, want to avoid @Now in a view, so I was thinking of running an agent to update the employee documents, but, how often?
To me, an app like this make no sense, and i tried explaining it - and the Sandbox example makes a lot more sense to me (http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/0d4b503c9cec8693852568b1006ae793?OpenDocument&Highlight=0,in,out,board) but I'd like to give some other ideas a whirl.
Any thoughts on the process?