4 Replies Latest reply: Mar 24, 2013 10:25 PM by M Tajuddin RSS

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

    990414
      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!