none
How to Prevent Duplicate Calendar (List) Items - SharePoint 2010

    Question

  • I'm trying to create a calendar that will serve as a Conference Room reservation system for my department. 

    Pain Point: Duplicate reservations are constant. 

    Needed Solution:  A calendar/list that - when creating a New Item - has the ability to check the existing List Items for duplicate Start Date/Time and End Date/Times.

    Use Case to consider: The solution would have to consider any time in between the Start and End times (for example - existing List Item runs from 9am-11am......but someone wants to create a New List item that has a start and end time of 9:30-10:00am ).

    Any thoughts how this solution could be built?

    Thursday, July 18, 2013 2:34 PM

Answers

  • Hi,

    You can prevent the double booking using SPD workflow.  Please verify the following link

    https://www.nothingbutsharepoint.com/sites/eusp/Pages/SharePoint-Double-Booking-with-the-Calendar.aspx

    Friday, July 19, 2013 12:00 AM
  • Hi there,

    Interesting question this one.  As you might know SharePoint generates a unique ID for each item upon creation.  OOB this is the only way that it can distinguish between items.  The following are just suggestions for you to get started and not complete solutions: -

    1. Consider using the SPServices MakeUnique Function (on this link)  by making a copy of the NewForm and editing it with the JQuery as outlined within that link
    2. Consider the following TechNet Gallery User Submission for preventing duplicate entries on this link
    3. Create an Event Receiver to check for duplicate entries.

    Cheers,

    Steven Andrews

    SharePoint Business Analyst

    Blog: Steve's SharePoint Space  Twitter:   LinkedIn:   Facebook:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, July 18, 2013 11:41 PM
    Answerer

All replies

  • Hi there,

    Interesting question this one.  As you might know SharePoint generates a unique ID for each item upon creation.  OOB this is the only way that it can distinguish between items.  The following are just suggestions for you to get started and not complete solutions: -

    1. Consider using the SPServices MakeUnique Function (on this link)  by making a copy of the NewForm and editing it with the JQuery as outlined within that link
    2. Consider the following TechNet Gallery User Submission for preventing duplicate entries on this link
    3. Create an Event Receiver to check for duplicate entries.

    Cheers,

    Steven Andrews

    SharePoint Business Analyst

    Blog: Steve's SharePoint Space  Twitter:   LinkedIn:   Facebook:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Thursday, July 18, 2013 11:41 PM
    Answerer
  • Hi,

    You can prevent the double booking using SPD workflow.  Please verify the following link

    https://www.nothingbutsharepoint.com/sites/eusp/Pages/SharePoint-Double-Booking-with-the-Calendar.aspx

    Friday, July 19, 2013 12:00 AM