Most of the developers faced issues with column validations in SharePoint 2003/2007.
It is really painful to write the validation using custom approach like javascript or jquery.
SharePoint 2010 provides the following validations in Out of the Box.
- Column Level Validation
- List Level Validation
Column Level Validation
While creating new column in list, click on the column validation node.
Specify your validation formula.
e.g.
[FieldName]=”Value”
The formula should return TRUE for validation to PASS.
Create New column in List and Specify the validation Settings.
Create new item in List, Click save to validate.
WOW….life is easy with SharePoint.
State Tuned to hear about List level validation in my next post.
[...] In my earlier article, I wrote about column level validation in SharePoint 2010. [...]
Can we compare more than 2 conditons eg;
If the textbox values can either be “NewYork” or “Washington” then how the formula must be.
Good Stuff.
I need to check it for e-mail validation. Can you please suggest me on this ?
Thanks,
Rao.
I’m trying to use a Single line of text field with column validation to allow users to just type text into the column. The problem is that I can’t figure out how to allow multiple entries into the column.
I have a validation formula that allows users to enter a single value such as “TC-12345″ but how can I adjust the formula below to allow a user to enter something like “TC-12345; TC-23456; TC-34567″ as well? Need to allow users to enter up to 20 separate values. My existing formula is below. Kindly suggesst what change i should do to achive my goal.
=IF(LEN([4M_Delete Type])<8,
FALSE,
IF(LEN([4M_Delete Type])=8,
IF(LEFT([4M_Delete Type],3)="TC-",
IF(ISNUMBER(VALUE(RIGHT([4M_Delete Type],5))),
IF(LEN(RIGHT([4M_Delete Type],5)=5),
TRUE,
FALSE),
FALSE),
FALSE),
FALSE))
this kind of formula is not taken into account by sharepoint 2010 :
=AND(TRIM([BadgeOwnerFullName])=”",TRIM([BadgeOwnerAccount])=”")
damage…