multi-column validation to create only unique elements
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 KozlovAdminMember for: 8 years 9 months 4 days
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.
-
palikMemberMember for: 5 years 7 months 16 days
thanks, i will try to do it this way