Description
The following can be entered or changed in a particular recipient table column for the recipient who triggered the event:
- A constant value is entered.
- An existing value in the recipient table column is incremented or decremented by a specific numerical value.
- A value that is determined beforehand using an expression is entered.
Example A recipient clicks an image coupled with a link in an HTML mailing (event). The value ‘HTML’ is entered for the recipient in the ‘Format’ recipient table column (action). This method is known as HTML sensing, as information on whether the recipient can display HTML mailings is acquired through the action.
Setup
You set up the action using the following elements:
-
Set value in the following column: Select the recipient table column in which the value is to be entered.
-
Set to constant value: Select this option to enter a constant value in the column. Then enter the constant value.
Example For a column with the column type ‘Yes/No’, enter the constant value ‘TRUE’ in the input field.
-
Change numerical value by +/- amount: Select this option to increment or decrement an existing value in the column by a specific amount. Then specify the amount.
Example If the numerical value is to be decreased by 1, enter the amount ‘-1’ in the input field.
-
Get value from expression: Select this option to enter a value in the column that is determined beforehand using a particular expression. Then enter the expression (beginning with an equals sign (‘=’)).
Example When the recipient clicks a link, the current date is entered in the ‘Click date’ column.
Option 1: The format of the ‘Click date’ column is ‘Date and time’
Enter the following expression: =Date()
The ‘=’ sign can also be omitted. The date is saved in dd.mm.yy hh:mm:ss format.
Option 2: The format of the ‘Click date’ column is ‘Text’
Enter the following expression: =Format(Date(), "Date format")
e.g. =Format(Date(), "dd.mm.yy hh:mm")
Note: Saving a data in a recipient column in ‘Text’ format can be useful, for example, for export to third-party systems that require special date formats.
