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!