For whatever reason, if you set a hyperlink within calculated column or place an url as default value for a field, in the modal view the hyperlink wont work and in the case of calculated column it will show the entire code.

Researched a lot, but so far not sure what will make it work.

  • 2
    You need to specify the SP version you are on, and the Formula you used Commented May 20, 2016 at 8:12
  • 1
    How you set hyperlink in calculated column? Can you provide me steps? Commented May 20, 2016 at 9:56
  • SPS 2013 Enterprise (latest SP level) @DannyEngelmanNVP & @viraj code =CONCATENATE("<a href=’”,”example.com/sites//General%20Documents/Forms/…{373A9A36-C01A-4616-BADA-065DEEBC44C0}&FilterField1=Agreement&FilterValue1=",Agreement Number,”’>”,Information,”</a>”) code It works when viewed in SPS List, but wen u open the item in MODAL view it shows the code rather the link. Selected as Numeric value.
    – Jason
    Commented May 22, 2016 at 23:41

1 Answer 1


HTML in Calculated Columns only works in Views

It will display the bare HTML in Forms, in Alerts, in Tree View, etc etc

Read the pros & cons of HTML+JavaScript in Calculated Columns at:


Alternatively you can do it with Client Side Rendering on SP2013:

CSR /JSLink blogs

  • Is their an alternate option?
    – Jason
    Commented May 23, 2016 at 11:10
  • CSR is the alternate Commented May 23, 2016 at 11:25
  • With reference to JavaScript, can you help me ascerting if the Javascript code below is correct to point a field name in SPS 2013 List as Hyperlink. code <script type="text/javascript" src="//code.jquery.com/jquery-1.12.0.min.js"></script> <script type="text/javascript"> var setColumnValue = function (column, linkVal) { var columnObj = $("input[Title='" + column + "']"); columnObj.val(linkVal); } $(document).ready(function() { setColumnValue('Apply','example.com'); }); </script> code Any pointer will be of great benefit.
    – Jason
    Commented May 23, 2016 at 14:07
  • This code is impossible to read in a comment. Make it another question and post it in a code block, that way anyone can answer Commented May 23, 2016 at 15:30
  • raised as a new question in the forum. sharepoint.stackexchange.com/questions/180742/…
    – Jason
    Commented May 24, 2016 at 0:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.