Generate URL using Calculated column in SharePoint 2013 List

Generate URL using Calculated column in SharePoint 2013 List

In this post, we will discuss how we can create a URL using a calculated column in SharePoint 2013 list or document library. By default when the user clicks on the Title column of a list then it usually opens the view form. But our requirement was to navigate to a different page with some query string parameter.

Also, read:
Office 365 Calendar Add-in by Virto Software Product Review

Keyword query language KQL in SharePoint 2013

PreSaveItem() in SharePoint 2013 NewForm.aspx form

For this we have created a calculated column like below:

=”<a href=’https://www.enjoysharepoint.com?ID=”&ID&”‘>”&Title&”</a>”

Here it will take the ID as the query string parameter.

And one more thing we should remember here is that we should choose Number in “The data type returned from this formula is:” section. It should looks like below:

 Generate URL using Calculated column in SharePoint 2013 List
Generate URL using Calculated column in SharePoint 2013 List

After this when you see in the view, you will be able to see the hyperlink column.

 Generate URL using Calculated column in SharePoint 2013 List
Generate URL using Calculated column in SharePoint 2013 List

Another example we can create an email link, when user click on the link it will open the email window and then in the body it will put the url.


=CONCATENATE(“<DIV align=””left””><a href=””mailto: ?SUBJECT= &BODY=https://www.enjoysharepoint.com?ID=”,ID,”””>email this post</a></DIV>”)

Hope this will be helpful.


You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →