This is my AMPscript code:
%%[
/*Lookup Quoted__c Object*/
Set @quoted__cRows = RetrieveSalesforceObjects("Quoted__c", "Id,Trade_Confirmation_URL__c,Trade_Confirmation__c", "Id", "=", @Quoted__c:ID)
set @Quoted__cRowsCount = rowcount(@Quoted__cRows)
if @Quoted__cRowsCount > 0 then
set @tradeConfirmationURL = field(row(@accountRows,1),"Trade_Confirmation_URL__c")
endif
if @Quoted__cRowsCount > 0 then
set @tradeConfirmation = field(row(@accountRows,1),"Trade_Confirmation__c")
endif
]%%
I have a button that redirects to Trade_Confirmation_URL__c
. Here is that code:
<table width="200" cellspacing="0" cellpadding="0" border="0" align="center">
<tr>
<td style="color: #000001; text-align: center; font-size:12px; font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif;" valign="top" align="left">
<a href="%%=RedirectTo(Quoted__c:Trade_Confirmation_URL__c)=%%" alias="Apple Trade Confirmation Link" target="_blank">
<img alt="Complete Trade" src="http://image.contact.phobio.com/lib/fe5215707c610d757313/m/1/3afb3e1e-d1dc-480b-a185-4f06cf345dba.png?b=1519762800000" style="display: block;" width="200" height="40" border="0"></a>
</td>
</tr>
</table>
I got this error message from Salesforce
-- Error:- ExactTarget.OMM.InvalidFunctionException: The specified attribute or custom object field name was not found for this client. Function Call: RedirectTo(Quoted:Trade_Confirmation_URL__c) Attribute or Field Name: Quoted:Trade_Confirmation_URL__c Error Code: OMM_FUNC_SYNTAX_ERR - from OMMCommon