2011-03-29
Dismiss this until next updateThis documentation has been updated

The latest version of PrintShop Mail is currently 7.1. This documentation was updated on 2011-03-29 and covers the changes made in this version. If you are still using an older version of PrintShop Mail, you can access its documentation by using the Version: menu at the top-right corner of this screen.

If you wish to upgrade to PrintShop Mail7.1, you can do so via the Upgrade Request page. Note that in order to upgrade, you will need a valid OL Care contract as of 2010-09.

IF

This function manipulates the database output without changing the content. Its purpose is to make a conditional selection from the database.

Syntax

IF(Logical test, Value if True, Value if False)

Description

Gives one of two results depending on a condition you specify. Returns <Value if True> when <Logical test> is True, and <Value if False> otherwise.

Example

IF([GENDER]="M", "Mr.", "Mrs.")

In this example, the IF function checks the database field [GENDER], if it contains "M", it returns the string "Mr.". If the database field contains anything else, it returns "Mrs".

Parameter description

Logical test

Logical expression that determines which of the 2 parameters values will be returned.

Value if True

Any expression of fieldname. Will be returned if test condition evaluates to True.

Value if False

Any expression of fieldname. Will be returned if test condition evaluates to False.

You can use the IF function, for example, to create a salutation. See "Inserting a Salutation".