If you need to calculate hyperlinks in SharePoint 2010 based off of other fields in a list, check this out. It definitely came in handy with a recent project I was working on.
Often you will get a requirement like this:
Create a calculated column which concatenate the url text with an existing column value.
This seems to be an easy task, except one thing: SharePoint doest not render hyperlink in calculated column by default.
For example, I have a list with 2 columns: Search term and Google Search. Google Search is a calculated column with this formula
Now, this is what I will get by default:
There are a few ways to fix this problem. Usually people will recommend you to create a Hyperlink column instead and create a workflow to update the Hyperlink value (http://social.technet.microsoft.com/Forums/ar/sharepoint2010customization/thread/32d32e47-3256-4806-8775-c250b6243038) . Or, you can place a script on the page that loop through the HTML nodes and replace the unfriendly html tags with a hyperlink as described here http://practicalsharepoint.blogspot.com/2011/10/dynamic-hyperlinks-in-calculated.html.
But today, I’m going to show you how to trick SharePoint into displaying the…
View original post 58 more words