Embedded Files
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
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
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
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:
If the gender in cell B2 is M, then enter Mr in cell C2.
If the gender in cell B2 is F, then enter Ms in cell C2.
Step 4: Insert conditional personalized field in WhatsApp message
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.
Report abuse