Available Functions > PlgValFor()

Syntax

PlgValFor( <Condition>, <FieldExpr> )

Purpose

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

Parameters

<Condition> is any expression which evaluates to true or false. This expression is used to tell PlgValFor() which pledge you wish to retrieve a value for. The condition should be very specific so that PlgValFor() can pinpoint the exact pledge you are interested in. For example, <Condition> could be used to select a pledge containing a certain comment in the pledge comment field, or perhaps a pledge made within a specific date range.

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

Returns

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

Usage

PlgValFor() can be used to "reach in" to a donor's pledge history to retrieve information from a specific pledge. For example, to create a report with a column containing the comment of the most recent pledge for each donor, you could use the following PlgValFor() expression:

Example

PlgValFor( .Pledge_Number. = .#_Pledges., .Pledge_Amount )