thankQ Help

If a specified custom field equals a specific value, display content "A". If it doesn't contain that value, check another specified custom field for a specific value, and if found, display content "B". If there is no match in either scenario, display alternative content.

[if:CustomField=x]Your "A" content here[elseif:CustomField=y]Your "B" content here[else]Your alternative content here[endif]

 

thankQ Example:

The following are the steps to create an Include Field Rule so a Profile can be used in a mailing or campaign. A Word or Campaign Monitor template can be created and the PARAMETERVALUE inserted into the template. The Field Rule should be applied in the mailing that is being used with the Profile.

1.Click Include Field Rules under Communication Modules

2.Click Table View on the Tool Bar

3.Click the Destination Field heading to sort in order. Locate a number that is not being used.

4.Click New on the Tool Bar

5.Click the tick box beside Include in Quick Letters if using the Write button and also Quick Receipts

6.Enter a Description

7.Select the Number of Characters from the drop down

8.Select the Parametervalue number from the Destination Field drop down

9.Enter or copy and paste the SQL Code

10.Click OK

UPDATE MAILINGDETAILPARAMETER

SET MAILINGDETAILPARAMETER.PARAMETERVALUE<Next available Number> = [CONTACTPARAMETER].[PARAMETERVALUE]

FROM MAILINGDETAILPARAMETER INNER JOIN CONTACTPARAMETER ON MAILINGDETAILPARAMETER.SERIALNUMBER = CONTACTPARAMETER.SERIALNUMBER

WHERE (((MAILINGDETAILPARAMETER.ADMITNAME)=':MailingID:') AND ((CONTACTPARAMETER.PARAMETERNAME)='<Profile Name>'))

 

<Next available Number> should be replaced with the next un-used number i.e. go to table view in Include field rules and order by column Destination field

<Profile Name> should be replaced with the desired profile name

Campaign Template:

 

 

 

[if:PARAMETERVALUE27=Vegan]You have a special table with no diary or meat.[elseif:PARAMETERVALUE27=Vegetarian]We have a salad bar just for you.[elseif:PARAMETERVALUE27=Lactose Intolerant]We have a buffet with nothing containing milk.[else]Sample our many delacies.[endif]