SharePoint 2010 Validation Settings

January 11th, 2011 | Posted by Marijn 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:
=OR([Field1]=””,[Field2]=””)
Don’t forget to insert a user message.

If you go back to your list and fill in both fields, hit save and you will see the user message popping up in red!

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.

You can follow any responses to this entry through the RSS 2.0 You can leave a response, or trackback.

One Response

  • Anonymous says:

    Hi, I'm experiencing an annoying issue. Validation message is not shown, although I've configured it right. Do you know what should happen to it? Maybe a Javascript bug on Custom lists?



Leave a Reply

%d bloggers like this: