I didn’t originally set out to write a series of posts on Column Validation in SharePoint 2010, but I keep thinking of new challenges each time I do. I have no idea how long this series may go (in fact, this may be the last one), but this is the third in the series. Here… Read More»
How to Validate an Email Address Using Column Validation in SharePoint 2010
Yesterday I showed you how to use Column Validation to validate Social Security Numbers, Phone Numbers, Employee Numbers, Part Numbers, and other things with strict formatting. Today I’m going to expand on that idea by showing you something more complex—we’re going to validate that an acceptable email address has been entered. The formula we’ll write… Read More»
How to Validate Strict Text Formats in SharePoint 2010
We often need to ensure that users enter text information in a specific way. For example, perhaps our company uses part numbers such as TL-1400 and RW-1555. Every part number begins with two letters, followed by a dash, followed by four digits. Or perhaps we use Social Security Numbers in SharePoint (if you do, I’m… Read More»
Get InfoPath to display lookup column value, not ID
If you have ever used a SharePoint list containing lookup columns as a data source in your InfoPath forms, you may have been disappointed to see the value of the lookup is not displayed. Instead of the value, the list ID of the item containing the value is displayed. My ‘Construction Line Items’ list contains… Read More»
A Few Notes on SharePoint 2010 Service Pack 1 and the June Cumulative Update
I just finished upgrading a three-server SharePoint 2010 farm (1 Web Front End (WFE01), 1 Application Server (APP01), and a separate Database Server; almost exactly as described in Jeff’s post How to Scale Out a SharePoint 2010 Farm from Two-Tier to Three-Tier By Adding a Dedicated Application Server) to Service Pack 1 and the June… Read More»
What Replaced the Build Dynamic String Workflow Activity in SharePoint Designer 2010?
One of the SharePoint Designer workflow activities I use most in SharePoint 2007 is Build Dynamic String. It is a very convenient way to create a customized string of dynamic text that I can then use and re-use for email subject lines, descriptions, task titles, and all sorts of things. Unfortunately, Microsoft made the decision… Read More»
How to Show the Fax Number in People Search Results in SharePoint 2010
I was recently working with a client who needed to show employees’ fax numbers in their People Search results in SharePoint 2010. Several months ago I got this working for them in SharePoint 2007, but it had to be configured all over again after the upgrade to SharePoint 2010. It was also more involved to… Read More»