Functions Reference

Aggregate functions
F
ILEMAKER FUNCTIONS REFERENCE 22
List
Purpose
Returns a concatenated list of non-blank values for a field or fields.
Format
List(field{;field...})
Parameters
field - any related field, repeating field, or set of non-repeating fields; an expression that returns a
field, repeating field, or set of non-repeating fields, or a variable.
Parameters in braces { } are optional.
Data type returned
text
Originated in
FileMaker Pro 8.5
Description
Listed items are separated by carriage returns.
Use this function to return a list of values for:
• a single field (table::field), which returns a single result over all repetitions (if any) for
this field and over all matching related records, whether or not these records appear in a
portal.
• several fields and/or literal values (table::field1,constant,table::field2...),
which returns a separate result for each repetition of the calculation across each
corresponding repetition of the fields. If any fields are related, only the first related record is
used.
Examples
In the following examples:
• Field1 contains white.
• Field2 contains black.
• Field3 contains three repetitions with values of red, green, blue.
• Related::Field4 refers to three records that contain 100, 200, 300.
• $f1 contains orange.
Note When referencing multiple repeating fields, List() returns the list of values across the first
repetition in the calculation's first repetition, then the list of values across the second repetition in the
second repetition, and so on.