Conditional Personalized Fields

How to create personalized fields that are conditional upon the content of the other fields?

This article describes how to create conditional personalized fields where the content of a new personalized field is determined by filtering an existing personalized field.

Step 1: Create column for conditiona personalized field

In Google Sheets, create a column for the conditional personalized field.

Step 2: Type conditional logic formula

Type the conditional logic formula in the first cell of the new column.

Step 3: Apply conditional logic formula

Apply the conditional logic formula to the rest of the cells in the column by dragging the first cell downward from the bottom right corner.

In the example below, conditional formatting is used to determine the customer's title for each row, depending on the gender for the row. The new column is called Title and the conditional logic formula states that:

Step 4: Insert conditional personalized field in WhatsApp message

In WhatsApp message template, insert the conditional personalized field as required. 

In the example below, *|Title|* and *|Name|* are inserted next to each other with a space between them.