Customer experience | Sales, Customer Insights,...

Dynamics Content in E-Mail - Dynamic salutation programming based on a code list

(0) Share

Report

Posted on by Jenni221

140

Hi all,

i want to add a Dynamic salutation in an email template. We use an own field contact.a_salutation with a drop down value list for it.

There are three options: male (code 1), female (code 2) and gender neutral (not 1 or not 2)

How do I have to design the if query so that the third variant is drawn? Unfortunately it does not work at the moment.

My code looks like this:

#if (eq contact.a_salutation 1) Sehr geehrter
else if (eq contact.a_salutation 2) Sehr geehrte
/if
#if(ne contact.a_salutation 1){{#if(ne contact.a_salutation 2)}}Sehr geehrte(r)
/if/if

Thank you!

Best Regards

Jennifer

All responses (4)

Answers (0)

Suggested answer

cloflyMao 25,198 on at

Like (0)

Report

RE: Dynamics Content in E-Mail - Dynamic salutation programming based on a code list

Hi Jennifer,

1. You could add an extra block to handle situation that the option set field value not equals to 1 or 2.

There are 5 options in Gender field of Contact:

Overview of dynamic expression:(do nothing in else condition)

Result 1:(when the field is "Male")

Result 2:(when the field is "Female")

Result 3:(when the field is "Gender neutral")

Result 4:(when the field is "Alien")

Result 5:(when the field is "Unknown")

2. I also tested your new expression:

---------------------------------------------------------------------------------------------------------------

{{#if (<operator> <value1> <value2>)}}

Content displayed when the expression is true

{{else if (<operator> <value1> <value2>)}}

Content displayed when the first expression is false and the second one is true

.

.

.

{{else}}

Content displayed when all expressions are false

{{/if}}

---------------------------------------------------------------------------------------------------------------

It will display gender directly if gender not equals to neither Male or Female.

result 1: (Gender neutral)

result 2: (Alien)

Could you describe details that why couldn't you render expected result by running one-by-one?

From my test, if the field contains data(an option is selected), then it shall display content when specific condition meets.

For your final doubt "Is there a problem if the field with the option set is empty?":

Yes, it is an issue in current Marketing application, because dynamic expression is built with Handlebarsjs,

If "#if" argument returns null, Handlebars will not render the block, that's by design.(In pure HTML page, we can solve it by extending custom javascript code, but javascript is blocked in HTML email.)

we need to wait for this issue could be fixed in future version.

So back to your question, make sure that Gender field of contact record contains a value.

Regards,

Clofly
Jenni221 140 on at

Like (0)

Report

RE: Dynamics Content in E-Mail - Dynamic salutation programming based on a code list

The documentation says the following should work. I'm running this one-to-one, but I can't. Is the documentation wrong?

docs.microsoft.com/.../dynamic-email-content

{{#if (<operator> <value1> <value2>)}}

Content displayed when the expression is true

{{else if (<operator> <value1> <value2>)}}

Content displayed when the first expression is false and the second one is true

.

.

.

{{else}}

Content displayed when all expressions are false

{{/if}}

Is there a problem if the field with the option set is empty for a contact? It is not a mandatory field and in case it is not filled I need a third option.
Jenni221 140 on at

Like (0)

Report

RE: Dynamics Content in E-Mail - Dynamic salutation programming based on a code list

Dear Clofly,

Thanks for your answer.

The request is quite simple, so that you don't have to program out all possibilities of the If statement, but can only trigger certain actions on 2 defined values and a standard text is displayed for the rest.

If it is a code list with ten values, your proposed solution becomes quite complex and inflates the template. This is not nice for the end user.

A nested if statement is standard in my view and should be supported.

Thank you!

Best Regards

Jennifer
cloflyMao 25,198 on at

Like (0)

Report

RE: Dynamics Content in E-Mail - Dynamic salutation programming based on a code list

Hi Jennifer,

Could you share me your requirement that why would you like to combine two conditional statements instead of a simple checking directly?

From my test, we could add another "else if" statement directly if there are 3 options in optionset field.

Logical expression:

Preview:

The actual expression should be {{#if A}}{{#if B}}<DisplayedContent>{{/if}}{{/if}} if our expected checking condition is {{#if A and B}}<DisplayedContent>{{/if}

Regards,

Clofly