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:
 •
 •
 •
 •
 •
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.
Example 1 
List (Field1; Field2) returns:
 •
 •
Example 2 
List(Field3) returns:
 •
 •
 •
Example 3 
List (Field1; Field2; Field3) returns:
in calculation repetition 1:
 •
 •
 •
in calculation repetition 2:
 •
in calculation repetition 3:
 •
Example 4 
List(Related::Field4) returns:
 •
 •
 •
Example 5
List ($f1; Field2) returns:
 •
 •
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas