FORUM PLAN UPDATE: Date revision: This forum will remain open to new posts and responses until December 1, 2018. (After that date, you will still be able to view and search the forum.) Also, we're taking a second look at the best place to host future conversation. For now, keep using this forum, and stay tuned for more news.
RE: new View in resource Reservation db Kevin Pettitt 30.Dec.08 02:33 PM a Web browser Domino Designer 6.5.5 FP3Windows 2003
Given that you're looking for things that don't exist (i.e. empty slots in the schedule), you cannot simply create a view to show this information since, well, it doesn't exist.
To solve the problem you have three choices:
1) Convince your users they can indeed click the mouse a couple times and the answer will be revealed. The information is easy enough to get
2) Write an agent that runs every few minutes which polls the current state of the Room Reservation db and creates documents that contain the information about the empty slots, so that you CAN build a view to show the information. This agent approach will be a MAJOR pain but if your client has more money that sense and you're looking for job security, will keep you busy for quite a while (though I'm not even sure it will work.
3) Create a custom form based loosely on the Appointment form in the Mail template that uses the scheduler to show all rooms at once in the grid. This is actually fairly practical, since all you're really doing is mimicking what you might see if you created a meeting and then added every room to it. You'll need to customize the scheduler to hide user and resource info, and increase the vertical height to match the number of rooms. This form could be a simple add-on to the Resource Reservation db or could reside in another custom app somewhere. If you want to buy a few hours of consulting time, I can build a working prototype that would allow you to move forward quickly. I've done some pretty cool stuff with schedulers in custom apps so this sounds pretty straightforward.
Whatever you decide, I'd be interested to hear how it works out so feel free to drop me a line.