I'm trying to create some sort of reservation system in SharePoint using a calendar list. It's been recommend to me to create events and add a column which allows a user to claim it. From there, claimed events would change color and only those who've claimed the event would have permission to unclaim the event.

This is what it would look like (see alternative option): enter image description here

What I'd like to be able to do though, is instead of having to create three events like shown in the alternative option, creating 1 event (see original) and have that be broken down into 3 events or more, maybe using some form of drop down asking for intervals (ie. 15m, 30m, 1h). Based on the selected interval, it'd break the event accordingly.


I would look at breaking this up into a few pieces.

Your Initial Event List, where events will be entered by event admins. Create a column or columns that allow them to specify the available sessions/timeslots. This could be simple or get complicated depending on how flexible you need it to be (i.e. multiple days, different intervals, etc).

Create a workflow that will then take those entries, and then create events in your calendar list as required. You can create custom list views to display the events based on your selection criteria.

You will need an additional workflow that fires on the events if you want to change item level security as users claim the slots. Once you change the permissions, if you do not include read permissions for all users, then the item will no longer be visible at all on your calendar except for the admins and the user that has rights to it.

A very rough workflow example would be (you would need more actions to manage all your inputs): enter image description here

| improve this answer | |
  • What I did was create a choice column called "Intervals" with choices: 15m, 30m, and 1hour. What would be ideal is if I created a 2 hour event from 12-2pm and selected 1hour interval, it would break this event into 2 events. If I said 30m, it would break it into 4, so on. Is that the same as what you mean? – Batman Jul 13 '13 at 15:07
  • The intervals you use doesn't matter that much, it will be the logic you use in the workflow to handle it. – Jesus Shelby Jul 13 '13 at 15:34
  • But it's possible in foundation? Like I could create 1 event have it broken into multiple events using a workflow based on the selected interval? Because if it's not possible I don't want to waste my time looking into it – Batman Jul 13 '13 at 19:08
  • Nothing fancy here, you are using a custom list, calendar list, and out of the box workflows, all available on foundation. – Jesus Shelby Jul 13 '13 at 20:58
  • Sounds good, thank you. I'll try to follow what you've said and see if I can figure it out tomorrow or this week. – Batman Jul 14 '13 at 0:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.