Skip to main content

SharePoint calculated column and hyperlink or Link (no workflows or scripts needed)

This is a process how you make the Link column in your sharepoint link

original url

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 herehttp://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 hyperlink, and it is going to be very easy.

1. Modify the calculated column and change the returned data type from Single line of text to Number/Currency/Date and Times. Click OK.



2. Go back to the list and be amazed :)



This will also work when you’d like to achieve the same thing with the image tag <img>.
Regards
3art Technology Experts
http://www.3art.tech
Labels:

Comments

  1. UnknownDecember 19, 2018 at 2:49 AM

    I am not getting hyperlink After changing to number column also

    ReplyDelete
    Replies
    1. Rashid Imran BilgramiJuly 1, 2021 at 9:28 PM

      Please explain about your issue, but you can use the workflow

      Delete
  2. Karthick GanesanApril 21, 2019 at 4:46 AM

    And indeed, I’m just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I’ve had.
    Java Training in Chennai |Best Java Training course in Chennai
    C C++ Training in Chennai |Best C C++ Training course in Chennai
    Python Training in Chennai| Python Training institute in Chennai
    Datascience Training in Chennai |Datascience Training institute in Chennai
    RPA Training in Chennai | RPA Training institute in Chennai

    ReplyDelete
  3. Sugantha RajaJuly 6, 2019 at 1:24 AM

    This is very great thinks. It was very comprehensive post and powerful concept. Thanks for your sharing with us. Keep it up..
    Oracle Training in Chennai | Oracle Training Institutes in Chennai

    ReplyDelete
  4. Dreamsoft ConsultantsOctober 12, 2021 at 12:20 AM

    This blog is very knowledgeable. Thank you for writing this blog. Dreamsoft Consultancy is one of the Leading Company in India who Provide Genuine Experience Certificate in Pune. So Contact here and Get all Details. Contact Us with Get all Details- 9599119376 or check Our Website- https://experiencecertificates.com/experience-certificate-provider-in-mumbai.html

    ReplyDelete
  5. Dreamsoft ConsultantsOctober 19, 2021 at 12:47 AM


    Gone through your blog it is very knowledgeable and have very interesting fact. Dreamsoft is the 20 years old consultancy providing fake experience certificate in Noida To get fake experience certificate in Noida you can call at 9599119376 or can the visit https://experiencecertificates.com/experience-certificate-provider-in-Noida.html

    ReplyDelete
  6. Dreamsoft ConsultantsOctober 26, 2021 at 12:19 AM


    Good to hear you views about I totally agree to your views. For filling the gap in the courier Dreamsoft will provide the Genuine experience certificate in Delhi, so here is your turn to grab the opportunity and to take your experience certificate in Delhi. The one who is interested for the experience certificate in Delhi may contact at 9599119376 or can visit our website at https://experiencecertificates.com/experience-certificate-provider-in-delhi.html

    ReplyDelete

Post a Comment

Popular posts from this blog

[Solved] SharePoint 2013 And Adobe Reader Problem : The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable

Dear All  When trying to open a PDF file from a mapped drive in SharePoint 2010.  You might see the following error message. The URL you have provided could not be reached. Please verify that the URL is correct and that the network location is reachable. 1. Open the registry. 2. Go to HKLM Local Software\SOFTWARE\Policies\Adobe\\\FeatureLockDown. 3. Create a key called cSharePoint. 4. Create a DWORD value called bDisableSharePointFeatures. 5. Set its value to 1. Regards Rashid Imran Bilgrami CEO Best visualization http://www.bestvisualization.com  
Post a Comment
Read more

SharePoint: A Complete Guide to Getting and Setting Fields using C#

Original article https://social.technet.microsoft.com/wiki/contents/articles/21801.sharepoint-a-complete-guide-to-getting-and-setting-fields-using-c.aspx Introduction This article demonstrates how to set and get the various SPField types for a SharePoint list using C#. The examples demonstrated set and get fields from an item that belongs to a custom list. The custom list contains a number of fields, and all the fields are named based on the type of field they are. For example, there is a Text field, which has been named, textfield. This is depicted in the following picture:   Applies To The examples demonstrated below are tested with and apply to the following versions of SharePoint: SharePoint 2010 SharePoint 2013 Get the List, and the first SPListItem This is the basic code for getting an item. If the list has at least one item, the first item is retrieved, otherwise a new item is created. var web = SPContext.Current.Site.RootWeb; var list = web.Lists...
Post a Comment
Read more

Updatepanel or Enable Ajax in SharePoint webpart

Dear All It is really giving me a hard to get this techniques if you want to run the update panel in sharepoint 2013 webpart then you need to initialize the script manage by code   protected override void OnInit(EventArgs e)         {             base.OnInit(e);             InitializeControl();             // Register the ScriptManager             ScriptManager scriptManager = ScriptManager.GetCurrent(this.Page);             if (scriptManager == null)             {                 scriptManager = new ScriptManager();                 scriptManager.ID = "ScriptManager1";                 scriptManager.EnablePartialRendering = true;       ...
23 comments
Read more