The FileMaker List Function

From Dwayne Wright PMP
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).

The list function will provide you a return-delimited data list from a related data field or a repeating field. For the most part, this function is used for gathering related data in one large block and then using it for correspondence. For example, a list of related invoices in which you want to include in a batch email to each client in a found set. It is also possible that you would use the list function to pull a collection of related data as a list and then parse it out by using some of the value related text functions.

Here you can see a snapshot of the List function in use in my example file that shows off many of the aggregate, text, number, date and time functions.

© 2010 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. FileMaker Pro is the registered trademark of FileMaker Inc.