Hi there,

I have created a calendar in SharePoint 2010. I created two custom drop down columns - Room and Attendant. There are 5 rooms and 3 attendant.  Each attendant can be assigned to only one room at a time.  E.g. if an Attendant #1 is assigned to room #2 during 9am-11am, then he cannot be assigned to any other room during that time. He can be assigned to other available rooms after 11 am.

Is it possible to implement such kind of validation for both the columns Room and Attendant when adding/editing an event?

Thanks

Joe

Hi green- you should set up your calendar as a resource calendar. When you create a calendar it will ask if you'd like it to be a resource calendar. Select that box. You'll then be able to add attendants & rooms as resources in an automatically created resources list. When a new calendar item is made, it will check to see if the resources are already booked and won't double book them.

I added Rooms and Attendants as resources. Should I create separate calendars for Rooms and add Attendants as resources? How should I design this? It would be nice to have a single calendar.

.

• Edited by green2004 13 hours 59 minutes ago

Please provide details as to how you're adding them and where. Screenshots would be helpful, too.

Should I create separate calendars for Rooms and add Attendants as resources? How should I design this? It would be nice to have a single calendar.