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 – Danny '365CSI' Engelman May 20 '16 at 8:12
  • 1
    How you set hyperlink in calculated column? Can you provide me steps? – Viraj Gorajia May 20 '16 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 May 22 '16 at 23:41

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 May 23 '16 at 11:10
  • CSR is the alternate – Danny '365CSI' Engelman May 23 '16 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 May 23 '16 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 – Danny '365CSI' Engelman May 23 '16 at 15:30
  • raised as a new question in the forum. sharepoint.stackexchange.com/questions/180742/… – Jason May 24 '16 at 0:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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