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:

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

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.