In this post we will discuss how we can create URL using calculated column in SharePoint 2013 list or document library. By default when user click 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.
Download FREE SharePoint 2019 Installation PDF Guide
This FREE PDF contains, Steps by step guide to install SharePoint 2019 Preview, prerequisites, hardware and software new features. First impression to SharePoint Server 2019 new modern site, modern lists and modern document libraries.
