CASE formula using merged fields in an object URL button - Answers - Salesforce Trailblazer Community
Trailblazer Community

Browse by categories

Ask Search:
ShowAll Questionssorted byDate Posted
Maud EONMaud EON 

CASE formula using merged fields in an object URL button

Hi
I'm trying to customize an email that will automatically be sent via CongaSign. Depending on the country I want to send an email in French or English. So I've used a CASE formula and merged fields.
The function works except it doesn't merge the fields as a result.
Here's the formula:
&CSemailmessage={!CASE( Quote.BillingCountry , 
"France", "Bonjour, Quote.ContactFR__c , veuillez trouver votre devis pour les licences Atlassian. Il vous suffit de cliquer sur le lien ci-dessous pour nous le retourner signé. Cordialement, Quote.OwnerFullName", 
"United Kingdom", "Hello+ Quote.ContactFR__c , please find the quote for your Atlassian licenses. You just need to follow the link below to confirm your order. Best Regards, Quote.OwnerFullName", 
"Hello, Here is the quote to accept...")} 

Any idea why it's not populating the merged fields Quote.ContactFR__c or Quote.OwnerFullName?
Thanks
Deepak AnandDeepak Anand
Try this =  
&CSemailmessage={!CASE(Quote.BillingCountry,"France","Bonjour {!Quote.ContactFR__c}, veuillez trouver votre devis pour les licences Atlassian. Il vous suffit de cliquer sur le lien ci-dessous pour nous le retourner signé. Cordialement, {!Quote.OwnerFullName}","United Kingdom","Hello {!Quote.ContactFR__c}, please find the quote for your Atlassian licenses. You just need to follow the link below to confirm your order. Best Regards, {!Quote.OwnerFullName}","Hello, Here is the quote to accept...")}
Maud EONMaud EON
Thanks Deepak but it does the same unfortunately.