Prevent overlapping date periods in SharePoint list items
In this InfoPath video you'll see how you can use validation rules in a SharePoint list form to prevent items with overlapping date and time periods from being added to a SharePoint list.
In recipe 53 of InfoPath 2013 Cookbook 2, you'll learn how to use data validation on items in a SharePoint list to prevent duplicate or overlapping date and time periods from being added to the SharePoint list through a SharePoint list form.
Get more solutions from InfoPath 2013 Cookbook 2 which is available on Amazon.com
Watch next video: Create InfoPath 2013 forms through SharePoint Designer workflows
InfoPath demo video transcript:
Here I'm in SharePoint 2013, where I've got this RoomReservations SharePoint list that contains these 3 list items. The basic idea is that I would like to enter items into this SharePoint list and then what I don't want is that whatever period, time period I select, I don't want it to overlap with existing time periods for a particular room.
Related InfoPath Demo Videos:
- Create InfoPath 2013 forms through SharePoint Designer workflows
- Bulk export selected InfoPath forms to Word documents
- SharePoint Designer workflow loop through people picker
- Autonumber InfoPath forms submitted to a SharePoint 2013 form library
- Basic SharePoint user profile info using a people picker
- Update an Excel spreadsheet when submitting an InfoPath form to SharePoint 2013
- SharePoint Designer 2013 workflow to loop through InfoPath repeating table
- Add validation rules to a people picker in InfoPath 2013
- Cascading multi-select list boxes with validation in InfoPath 2013
- Submit SharePoint list item to Excel workbook via InfoPath 2013
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author.