<< Click to Display Table of Contents >> Navigation: Available Functions > NamesOfStoredFilesForDonor() |
Syntax
NamesOfStoredFilesForDonor( <cFileMask> )
Purpose
To retrieve the names of all stored files for a donor which match an optional file mask.
Parameters
<cFileMask> is a character value which must be enclosed in quotation marks. It can be used to limit the types of files returned, or to specify that only files beginning with a certain name be returned. For example, "*.pdf" would return the names of all PDF document files for the current donor. "Profile Picture*.jpg" would return all of the file names of picture files starting with the phrase "Profile Picture."
Returns
The file names are returned in a single tab-delimited character value, suitable for reporting or exporting.
Usage
On reports the NamesOfStoredFilesForDonor() function can be used to retrieve and print all files, or files meeting a certain file mask, for each donor.
Example
The following examples illustrate NamesOfStoredFileForDonor():
STORED FILES FOR DONOR |
---|
Audio file of speech donor gave at city council meeting.mp3 |
ConstituentNotes.doc |
Profile picture of donor.jpg |
Picture of donor at our top donor tribute dinner.jpg |
Scan of letter donor sent us praising our work.pdf |
CALL |
RESULT |
---|---|
NamesOfStoredFilesForDonor( *.pdf ) |
Scan of letter donor sent us praising our work.pdf |
NamesOfStoredFilesForDonor( *.jpg ) |
Main profile picture of donor.jpg <tab> Picture of donor at our top donor tribute dinner.jpg |
NamesOfStoredFilesForDonor( "Profile*.jpg" ) |
Profile picture of donor.jpg |