Available Functions > NthSolNumFollowUps()

Nth Solicitation Number of Follow-Ups

Syntax

NTHSOLNUMFOLLOWUPS( <SolicitationNumber> )

Purpose

To retrieve the number of follow-ups made for the nth solicitation.

Parameters

<SolicitationNumber> is the unique number for the desired solicitation. Solicitation numbers are generated in ascending order by DonorQuest, starting from 1 and going up to 999.

Returns

The number of follow-up phone calls or mailings for the specified solicitation.

Usage

On reports the NTHSOLNUMFOLLOWUPS() function can be used to retrieve the number of follow-up attempts for the nth solicitation in each donor's history.

Example

The following examples illustrate NTHSOLNUMFOLLOWUPS():

MEMO CODE	MEMO TEXT
S000001	02/01/2011; GOLF ; Last Follow-Up: 05/15/2011; Number Of Follow-Ups: 4
S000002	02/01/2012; CAPTL; Last Follow-Up: 04/20/2012; Number Of Follow-Ups: 2

CALL	RESULT
NTHSOLNUMFOLLOWUPS( 1 )	4
NTHSOLNUMFOLLOWUPS( 2 )	2