multi-column validation to create only unique elements

rss

Posted by palik - Nov 9 ’16 at 04:56

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 ?

 

  • Dmitry Kozlov
    Dmitry Kozlov
    Admin
    Member for: 6 years 2 months 22 days
    #1 by Dmitry Kozlov Nov 9 ’16 at 08:01

    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
    Member
    Member for: 3 years 1 month 1 day
    #2 by palik Nov 10 ’16 at 01:37

    thanks, i will try to do it this way

Displaying 1 to 2 of 2 messages