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: 9 years 8 months 7 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: 6 years 6 months 20 days
    #2 by palik Nov 10 ’16 at 01:37

    thanks, i will try to do it this way

  • Maude Ernser
    Member
    Member for: 9 months 4 days
    #3 by Maude Ernser Oct 15 ’22 at 08:10

    The fact that you can have multiple columns means that you can validate a whole set of rules in one go. If there's one rule that has to be satisfied for all your items, then you create a rule for each column and then when adding a new item you can apply the rules to it by just clicking on the column. Now you can try here for best ideas. The only thing I don't understand is how you want to do multi-column validation for single products.

  • hrmasters
    Member
    Member for: 7 months 11 days
    #4 by hrmasters Oct 18 ’22 at 04:05

    Really nice and helpful Article. Thanks for Sharing

    Nanny in Dubai

  • jonemartin
    Member
    Member for: 10 months 13 days
    #5 by jonemartin Dec 6 ’22 at 03:34

    You already post formulas in your post for multi-column validation to create only unique elements.

     

    TPCS providing high quality and reliable Pest Control Richmond service

Displaying 1 to 5 of 5 messages