Using conditional functions in communication templates

Available conditional functions with examples

To insert a conditional function in the HTML body of one of the supported areas, use the syntax:

{if (conditions)}
Text or HTML to appear if condition is true 
{/endif}

This section covers the specific conditional functions supported in alerts, communication templates, Data Showcase, and Query Template Display.

COUNT example

{if (COUNT(#party.AdditionalAttributes) GT 0 AND #party.AdditionalAttributes[1].Name EQ
'IsMemberRecord' AND #party.AdditionalAttributes[1].Value EQ true)}
Is a member.
{/endif}

LENGTH example

{if (LENGTH(#query.TAX_EXEMPT) GT 0)}
Contact is tax exempt.
{/endif}

ISTRUE example

{if (COUNT(#party.AdditionalAttributes) GT 0 AND #party.AdditionalAttributes[3].Name EQ 'IsMember' 
      AND ISTRUE(#party.AdditionalAttributes[3].Value))}
Contact is a member.
{/endif}

ISFALSE example

{if (ISFALSE(#query.IsMember))}
Contact is not a member.
{/endif}

ISNULLOREMPTY example

{if (ISNULLOREMPTY(#query.Website))}
Please add your website!
{/endif}

ISNOTNULLOREMPTY example

{if (ISNOTNULLOREMPTY(#query.PaidThrough) AND #query.PaidThrough LT Now)}
Contact is not yet expired.
{/endif}

DAYSBETWEEN example

{if (DAYSBETWEEN(#query.RenewedThrough, #query.PaidThrough) GT 90)}
Member is due for renewal.
{/endif}

DATE example

{if (ISNOTNULL(#query.JoinDate) AND (#query.JoinDate GTE DATE('12/31/2021')))}
2022 MEMBER
{/endif}

CONTAINS example

{if (CONTAINS(#query.JoinDate, '2022'))}
New member in 2022.
{/endif}

NOTCONTAINS example

{if (NOTCONTAINS(#query.City, 'Austin'))}
Member is not an Austin resident.
{/endif}

STARTSWITH example

{if (STARTSWITH(#query.City, 'Aus') OR STARTSWITH(#query.City, 'Dal') )}
Member may live in Austin or Dallas.
{/endif}

ENDSWITH example

{if (ENDSWITH(#query.FullName, 'Smith') OR ENDSWITH(#query.FullName, 'Richards') )}
Last name ends with Smith or Richards.
{/endif}

Acceptable conditional operators

Symbolic operators such as ==, !=, and || are supported, but the preferred syntax is EQ, NEQ, and OR.

Example: Adding party data values when they exist for the recipient and hiding the values when they do not exist

Do the following to create the above example:

1. Go to Marketing > Communication templates.

2. Open the communication template.

3. Click the Body tab, then click the HTML tab.

   

4. Find the location where you want the message to go, then paste the following:
   Text

   <h3>
     <strong>
   {if (ISNOTNULLOREMPTY (#query.FirstName))}{#query.FirstName} {/endif}
   {if (ISNOTNULLOREMPTY (#query.MiddleName))}{#query.MiddleName} {/endif}
   {if (ISNOTNULLOREMPTY (#query.LastName))}{#query.LastName}, {/endif}
   {if (ISNOTNULLOREMPTY (#query.Suffix))}{#query.Suffix}, {/endif}
   {if (ISNOTNULLOREMPTY (#query.Designation))}{#recipient.Designation}{/endif}
     </strong>
   </h3>

5. Save the template.

The properties and associated commas will only appear if the recipient has the value populated on their account page.

Example: Adding a unique message to the email based on the recipient's location

Do the following to add a conditional statement to a communication template based on the recipient’s location:

1. Go to Marketing > Communication templates.

2. Open the communication template.

3. Click the Body tab, then click the HTML tab.

   

4. Find the location where you want the message to go, then paste the following:

   <p>{if (#party.City EQ 'Austin')}
    <strong>Reminder</strong>: Austin's SXSW festival is happening the same weekend as our Annual Conference! 
   Since you already live in Austin, it is highly recommended that you use a rideshare company when traveling to the conference!
   {/endif}</p>

   

5. Save the template.

6. Only members attending the event with Austin defined as their primary city will see the extra note in their email.

   

Example: Adding address information for a contact when the information exists and hiding the extra line when the information does not exist

Use the following to accomplish the above example:

{if (ISNOTNULLOREMPTY (#recipient.Address1))} {#recipient.Address1} <br>
{/endif}
{if (ISNOTNULLOREMPTY (#recipient.Address2))} {#recipient.Address2}<br>
{/endif}
{if (ISNOTNULLOREMPTY (#recipient.Address3))} {#recipient.Address3}<br>
{/endif}
{if (ISNOTNULLOREMPTY (#recipient.City))} {#recipient.City},{/endif}{if (ISNOTNULLOREMPTY (#recipient.StateProvince))} {#recipient.StateProvince}{/endif}{if (ISNOTNULLOREMPTY (#recipient.Zip))} {#recipient.Zip}{/endif}