How to handle calendar events over multiple dates

HCL Domino Domino Forum
1

I am developing an application to handle notices about system outages. In this application I want the users to complete one form per outage.

In the calendar view I want to show the outages with the relevant times, so a quick look at the calendar for any day can show if there are going to be conflicting entries for the same time period on a day. As you would when looking at meetings.

This is not a problem for outages that happen on one day. However if an outage is to span multiple days I would like it to appear on the first day at the start time and then to show all day for each intervening date except the last where it will show up until the final time.

The only way I can see of doing it was to create multiple documents, one for each day, with fields for Start time and duration so it can display in the calendar view correctly. I was wondering if this was the only way of doing it or if someone had another way which was simpler than trying to control multiple documents for a single event.

I look forward to your ideas

Thank you

Duncan Caldwell

2

Subject: RE: How to handle calendar events over multiple dates

Tricky. You can of course create a multivalue list of date/times for the start time, and use that to display the calendar items on multiple days. If it were a normal view you could set the view column option to display multiple values on separate rows, on the duration column (making sure not to sort that column). But I don’t know whether the calendar display code is smart enough to do the appropriate thing with that.

Why don’t you try that in a little sample database and see what it does, and let us know?

3

Subject: RE: How to handle calendar events over multiple dates

That was the sort of thing I was thinking, using multivalue fields. But then that works fine for the first column, but how do I link the second column value (duration) to the first column value.

I will have to do some test databases with multiple values and see how it works.

Please keep the ideas coming.

Thanks