<< Click to Display Table of Contents >> Navigation:  Available Functions > XAdValFor()

Syntax

XAdValFor( <Condition>, <FieldExpr> )

 

Purpose

To retrieve the value of an extra address field or field expression for a specific extra address in a given donor's history.

 

Parameters

<Condition> is any expression which evaluates to true or false. This expression is used to tell XAdValFor() which extra address you wish to retrieve a value for. The condition should be very specific so that XAdValFor() can pinpoint the exact extra address you are interested in. For example, <Condition> could be used to select an extra address containing a certain value in the extra address code field, or perhaps an extra address with a specific date window for mailing.

 

<FieldExpr> is the extra address field or field expression you wish XAdValFor() to return the value of for the specific extra address identified via the <Condition> parameter.

 

Returns

XAdValFor() will return the value of an extra address field or field expression for a specific extra address in a given donor's history. The type of data value returned by XAdValFor() will be the same as <FieldExpr>.

 

Usage

XAdValFor() can be used to "reach in" to a donor's extra address history to retrieve information from a specific extra address. For example, to create a report with a column containing the summer mailing address of each donor, you could use the following XAdValFor() expression:

 

Example

XAdValFor( .XA_Code. == "SUMR", .XA_Address. )

 

Note that the above example requires that summer extra addresses have the code "SUMR" entered for the extra address code field.