SharePoint 2010 Validation SettingsJanuary 11th, 2011 | Posted by in enduser | sharepoint 2010 | usability
One of the cool things in SharePoint 2010 for end-users is the validation of columns. In normal applications you can have a validation on a field; examples :
– a field number must be between value x and value y that are also on the item
– a date must be smaller then another date on the item
A coworker was playing with the validation settings and it looked so cool I had to write this post about it!
His goal was to create 2 numeric fields where 1 of the fields has to be filled in, but they cannot both be filled in..not possible without code in SharePoint 2007, but a piece of cake in SharePoint 2010.
Just create the 2 fields, go to list settings – validation settings and create following validation:
Don’t forget to insert a user message.
REMARK FOR DUTCH USERS!!!
Als je de bovenstaande formule gebruikt, zal deze niet werken in de nederlandse versie!!
In deze versies moet je “;” in plaats van “,” gebruiken. Ook “OR” of “AND” werken niet, deze dienen “OF” of “EN” zijn.