Functions Reference

14 FileMaker Functions Reference
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.
Note When referencing multiple repeating fields, List() returns the list of the values
across the first repetition in the calculation's first repetition, then the list of the values
across the second repetition in the second repetition, and so on.
Example 1
List (Field1; Field2) returns:
white
black
Example 2
List(Field3) returns:
red
green
blue
Example 3
List (Field1; Field2; Field3) returns:
in calculation repetition 1:
white
black
red
in calculation repetition 2:
green
in calculation repetition 3:
blue
Example 4
List(Related::Field4) returns:
100
200
300