ifboolean

Use the ifboolean command when you want to create a condition with multiple fields linked by ANDs and ORs.

The ifboolean syntax is:

%%
ifboolean
tablename.fieldname1 operand value1 AND/OR
tablename.fieldname2 operand value2 AND/OR
...
tablename.fieldnamex operand valuex
"content-if-true"
"content-if-false"
%%

If you mix ANDs and ORs, you need to use parentheses to group expressions.  

How it works: for each individual recipient, the command evaluates whether the entire condition statement is true. If the condition is true, the command prints content-if-true. If the condition is false, the command prints content-if-false.

Supported Operands

• =  equals
• <  less than
• >  greater than
• <=  less than or equal to
• >=  greater than or equal to
• <>  is not equal to
• contains  contains
• doesnotcontain  does not contain
• endswith  ends with
• beginswith  begins with

See below for examples of how these are used.

Example 1

You want to include a paragraph that goes to all Florida residents whose interests are dogs or cats.

%%
ifboolean
address.state = FL AND
(members_.interestdog = T OR
 members_.interestcat = T)
"We have a special for your pet!"
"
%%

 

Example 2

You want to include a paragraph that goes to all Florida and Georgia residents whose interests are dogs or cats.

%%
ifboolean
(address.state = FL OR
 address.state = GA) AND
(members_.interestdog = T OR
 members_.interestcat = T)
"We have a special for your pet!"
"
%%

 

Example 3

You want to include a paragraph that goes to all Florida and Georgia residents whose interests are dogs or cats, but not if they have a lizard interest.

%%
ifboolean
((address.state = FL OR
 address.state = GA) AND
 (members_.interestdog = T OR
 members_.interestcat = T)) AND
 members_.interestlizard <> T
"We have a special for your pet!"
"
%%

 

Example 4

You want to send a special a message to all California residents who joined your list after March 1, 2001.

%%
ifboolean
address.state = CA AND
members_.DateJoined_ > 2001/03/01
"Special message!"
"
%%

 

Example 5

You want to send a special a message to all northern California residents (designated by a range of zip codes) who have an interest in basket weaving.

%%
ifboolean
((address.zip > 91000 AND
 address.zip < 95000) AND
 members_.interest = "basket weaving" )
"Special message!"
"
%%

 

Example 6

You want to send a special a message to all AOL customers living in New York.

%%
ifboolean
members_.EmailAddr_ endswith aol.com AND
address.state = NY
"Special message!"
"
%%

 

Example 7

You want to send special content if member name information is blanka nadn dy joined in the year 2000.

%%
ifboolean
 members_.FullName_ = " AND
(members_.DateJoined_ >= 2000/01/ AND
 members_.DateJoined_ <= 2000/12/31)
"Special message!"
"
%%

 

Example 8

You want to send a message to everyone outside California.

%%
ifboolean
address.state <> CA
"Special message!"
"
%%

You could also do this with the ifcondition command, with the message as your default text:

%%
ifcondition
address.state CA
<>
"Special message!"
%%