Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a list. I want add a column for list with this format :

XX-XXXX

How to set this Validate for column?

i use this link , but don't work for me.

share|improve this question
    
Do you want to use this format for display only or enforce for input as well? –  Ryan May 21 '12 at 10:25
    
I want use for input :) –  ar.gorgin May 22 '12 at 3:38

2 Answers 2

up vote 2 down vote accepted

You've got a few options.

1) JavaScript validation on form as shown in the link in your question.

It DOES work if done correctly and is probably the quickest way do this.

  • Pro - Quick and easy and allows you to provide immediate feedback to user in OnBlur event.

  • Cons - limited in what you can do (e.g. can't run server side code to check against another list) and easy to 'get around' e.g. via the DataSheet view.

2) A custom column that applies regular expression validation.

You can use/adapt one of these open source projects

3) Write your own custom column.

More complex - but allows you to combine server side and client side validation.

share|improve this answer
    
Thanks a lot :) –  ar.gorgin May 23 '12 at 5:31
    
And its not even worth an upvote? Sheesh, tough crowd! ;) –  Ryan May 23 '12 at 8:11

Though not as easy or powerful as regular expressions, standard Column Validation can use a rich selection of Excel-like string functions. For example...

<br>
&nbsp;&nbsp;=IF(LEN([ColumnName])=7,IF(MID([ColumnName],3,1)="-"),TRUE,FALSE),FALSE)&nbsp;&nbsp;&nbsp;-or-<br>
&nbsp;&nbsp;=(LEN([ColumnName])=7)+(MID([ColumnName],3,1)="-")=2

Some more complex examples are described at http://sharepointsolutions.com/sharepoint-help/blog/2011/12/how-to-use-or-type-options-in-sharepoint-2010-column-validation/

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.