This discussion is archived
4 Replies Latest reply: Mar 24, 2013 8:25 PM by MTajuddin RSS

Creating an external link in one field based on value of another field

990414 Newbie
Currently Being Moderated
Have 2 fields in a table: CR_Number and CR_Link (both varchar2s). If a CR_Number is populated in the data form, the CR_Link will be populated with a link to a company app which the manager can use to open this app from within Apex.

This is my original SharePoint formula: =IF([CR#]="","","<a href='"&[CR_Number]&"' target='_blank'>"&[CR_Number]&"</a>"). I tried to mirror the HTML but not working. This is my current syntax in DECODE:


Where am I going wrong? Appreciate any help. Thanks!


  • Correct Answers - 10 points
  • Helpful Answers - 5 points