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: 8 years 9 months 4 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.

    link flag
  • palik
    Member
    Member for: 5 years 7 months 16 days
    #2 by palik Nov 10 ’16 at 01:37

    thanks, i will try to do it this way

    link flag
Displaying 1 to 2 of 2 messages

Related threads