Forum Discussion

Copper Contributor

Jun 14, 2017

SharePoint Online - calculated column no longer showing as hyperlink

A couple of months back I created a calculated column that was showing a hyperlink and I have just noticed that the calculation no longer works. The formula I used is below, note: I have removed ...

SharePoint Online

Michael Söderberg

Copper Contributor

Jun 15, 2017

Using js-link to fix the problem. No need to change the calculated field. Here's what I came up with:

function RenderMyCalculatedField() {

var template = {

renderMyField: function (ctx) {

var html = [];

html.push(ctx.CurrentItem.Skicka); // Fieldname 'Skicka'

return html.join('');

}

function registerTemplate() {

var context:any = {};

context.Templates = {};

context.Templates.Fields = {'Skicka':{'View': template.renderMyField}}; // Fieldname 'Skicka'

SPClientTemplates.TemplateManager.RegisterTemplateOverrides(context);

}

registerTemplate();

};

RenderMyCalculatedField();

Chris McNulty
Silver Contributor
Jun 15, 2017
Please see our update at https://techcommunity.microsoft.com/t5/SharePoint/Custom-markup-in-SharePoint-calculated-columns/m-p/78225

Thanks.
- Deleted
  Jun 16, 2017
  You can use following code in JS Link to fix this issue:
  
  (function () {
  
  var priorityFiledContext = {};
  priorityFiledContext.Templates = {};
  priorityFiledContext.Templates.Fields = {
  
  'URL': { 'View' : setURL},
  
  };
  SPClientTemplates.TemplateManager.RegisterTemplateOverrides(priorityFiledContext);
  
  })();
  
  function setURL(ctx){
  var ret="";
  if(ctx.CurrentItem["URL"] != "")
  {
  ret = "<a href=\""+ctx.CurrentItem["URL"]+"\" target=\"_blank\" class=\"lnkURL\">"+ctx.CurrentItem["Title"]+"</a>";
  }
  return ret;
  }
  - Kelly Dungate
    Copper Contributor
    Jun 18, 2017
    thank you Vishal! I managed to get this one working.