multi-column validation to create only unique elements

Discussions about Forms Designer for SharePoint 2010.
Locked
palik
Posts: 5
Joined: Tue Nov 08, 2016

09 Nov 2016

Hi there,


I've got a 'devices' list with ~40 columns. When adding/editing item i would like to check if several columns are unique before saving data.

So if i add new device with columns:

Producer=Siemens, Type=Switch, S/N=123456

Other user cannot add identical device but can add device like:

Producer=Cisco, Type=Switch, S/N=123456


Is that possible OOB with Sharepoint or maybe you can do this using jQuery (with or without your product)

Is your product able to do only client side validation or maybe server side too ?

User avatar
Dmitry Kozlov
Site Admin
Posts: 1524
Joined: Thu Jun 07, 2012

09 Nov 2016

You cannot validate uniqueness of a set of fields OOTB, but you can create a calculated column concatenating values of those fields and check if an item with a certain value already exists in the list via JavaScript.

palik
Posts: 5
Joined: Tue Nov 08, 2016

10 Nov 2016

thanks, i will try to do it this way

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests