4 Replies Latest reply on Mar 25, 2013 3:25 AM by M Tajuddin

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

      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:


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