Conditional logic in Salesforce Text Email Template

Question

I want to add conditional logic to my text email template.

Here is what I tried:

Destination__c = {!Enquiry__c.Destination__c}

{!IF("{!Enquiry__c.Destination__c}" = "Barcelona", "i am barcelona", "i am not barcelona")}

When I sent a test message, I got the following:

Destination__c = Barcelona 

i am not barcelona

I'm aware of formula fields, but I'd rather have the logic in the template. Although, if I need to make a formula field, I'm willing to do so.

{!IF(Enquiry__c.Destination__c == "Barcelona", "i am barcelona", "i am not barcelona")} — batMask, Commented Aug 27, 2018 at 2:05

iDog · Accepted Answer · 2017-08-09 05:34:54Z

4

Try the following:

{!CASE(Enquiry__c.Destination__c, "Barcelona", "i am barcelona", "i am not barcelona")}

If that doesn't work with a simple Text Email Template, try re-creating as a Custom HTML Email Template, it should work.

answered Aug 9, 2017 at 5:34

iDog

4845 silver badges19 bronze badges

formula works best, custom email template has some disadvantages to keep editable text before sending.
– Santanu Boral
Commented Aug 9, 2017 at 5:44
It worked! Thanks, iDog. The reason why I don't want to use formula fields is because I want to conditionally show a sentence depending on the value of Destination__c.
– Matthew
Commented Aug 9, 2017 at 6:01

Add a comment |

Santanu Boral · Accepted Answer · 2017-08-09 05:33:47Z

1

Conditional logic only works correctly if you use Visualforce Email Template.

For, Text or HTML based email templates, you need to create a formula field which will return results based on your conditions.

answered Aug 9, 2017 at 5:17

Santanu Boral

36.2k8 gold badges45 silver badges72 bronze badges

Add a comment |

Mustafa Jhabuawala · Accepted Answer · 2017-08-13 17:48:15Z

0

Try out this once -

{!IF({!Enquiry__c.Destination__c} == "Barcelona", "i am barcelona", "i am not barcelona")}

answered Aug 13, 2017 at 17:48

3681 silver badge6 bronze badges

Add a comment |

batMask · Accepted Answer · 2018-08-24 10:09:01Z

0

Replace {!Enquiry__c.Destination__c} with Enquiry__c.Destination__c

{!IF(Enquiry__c.Destination__c == "Barcelona", "i am barcelona", "i am not barcelona")}

answered Aug 24, 2018 at 10:09

batMask

1011 bronze badge

2

Welcome to SFSE! This looks more like it should be a comment on (or an edit to) another answer, rather than an answer by itself. Usually, a good answer will go into detail about what the problem is (in this case, an extra {!} in the formula), how to fix it, and why the fix works. Normally, new users aren't able to comment on other people's questions/answers (50 reputation required), but since you linked your account from other SE sites, you have 100 reputation. I'm recommending a deletion for this one.
– Derek F
Commented Aug 24, 2018 at 12:36

Add a comment |

4 Answers 4