From time to time, I preach about how glorious the SharePoint twitter social community is and how it impacts my daily routines in a positive manner. I’d like to share an experience I had on twitter in regards to the new Validation Settings in SharePoint 2010.
It all started with @SharePointKris asking the following: “Help... I'm looking for #sharepoint 2010 email column validation formula for public blog comments... @gdurzi huuusshhhhh”.
I was familiar with Validation Settings on Lists, but never had the chance to actually use the feature in a practical manner. Intrigued by the question, I tried looking at regex and vba validation expressions. Everything was failing giving me the following screen:
(Along the way @stacyDraper decided to hop on to figure this out as well.)
Yet again SharePoint left me feeling dazed and confused….until @tigertoy sent me the following tweet: “I think the same functions you can use in calculated field are supported only”.
Calculated fields is nothing new and something I’ve used before. That tweet was exactly what I needed!
Found the old WSS 2.0 list of functions (http://office.microsoft.com/en-us/sharepointtechnology/CH011711171033.aspx?stt=1) and came up with the following: =AND(FIND("@",EmailAddress,1)>0,FIND(".",EmailAddress,1)>0).
One tweet sparked nine tweets, ten direct messages, two blog posts and possibly a solution.
http://twitter.com/sharepointkris
http://twitter.com/tigertoy
http://twitter.com/stacydraper