This discussion is archived
4 Replies Latest reply: Mar 24, 2013 8:25 PM by M Tajuddin 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='http://intranet.att.com/oneattcr/crsummary.cfm?crid="&[CR_Number]&"' target='_blank'>"&[CR_Number]&"</a>"). I tried to mirror the HTML but not working. This is my current syntax in DECODE:

DECODE(CR_NUMBER,NULL,Null,'||CR_NUMBER||')

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

Legend

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