InfoPath form to force a unique combination of values for a SharePoint list item

This InfoPath video is a demonstration of a SharePoint List Form that can be used to force users to enter a unique combination of values for a SharePoint list item thereby preventing duplicate items from being entered into the SharePoint list.

While you can configure fields separately to contain unique values in a SharePoint list, it becomes a bit more difficult to configure a combination of fields to contain unique data using out-of-the-box settings in SharePoint. Here is where InfoPath can help.

You can use data validation rules in a SharePoint List Form, which is an InfoPath form, to prevent users from adding duplicate items to a SharePoint list. The validation rules can validate data in either one field or data in a combination of fields.

The InfoPath 2013 with SharePoint 2013 video below demonstrates how such a solution would work by validating data that is entered into two fields of a SharePoint list item as a unique combination. It also demonstrates a second solution that prevents users to not only enter a unique combination of values, but also forces users to enter items that have unique titles.

The demo form templates can be download by customers in the InfoPath 2013 Cookbook Club, the InfoPath 2010 Cookbook Club, or the InfoPath 2010 Cookbook 2 Club

See more InfoPath 2013 tutorial videos »

 
 Subscribe for updates via RSS or Email

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 of S.Y.M. Wong-A-Ton. 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, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services