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: 9 years 8 months 7 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: 6 years 6 months 20 days
thanks, i will try to do it this way
-
Maude ErnserMemberMember for: 9 months 4 days
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.
-
hrmastersMemberMember for: 7 months 11 days
-
jonemartinMemberMember for: 10 months 13 days
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