multi-column validation to create only unique elements

[palik]

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]

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]

thanks, i will try to do it this way