Functions Reference

Table Of Contents
Chapter 10
|
Repeating functions 157
Description
Returns the contents of the repeating field specified by number.
Examples
ParcelBids is a field defined to repeat with ten values and contains the values 2500, 1200,
and 1500.
GetRepetition(ParcelBids;2) returns 1200.
GetRepetition(if(IsEmpty(ParcelBids) true, ParcelBids,
HouseBids);2) returns 1200.
GetRepetition(ParcelBids;5) returns nothing.
Note You can also find the contents of a particular repetition in a repeating field using
square brackets [ ] as array operators. For example, ParcelBids[2] returns 1200. See
FileMaker Pro help.
Last
Format
Last(field)
Parameter
field - any repeating field or related field, or an expression that returns a reference to a
repeating field or related field.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the last valid, non-blank value in field. If field specifies a repeating field then
it returns the last non-blank repetition. If field specifies a related field, then it returns the
last non-blank value in the related set.
Note The last related value will depend on the way related records
are sorted. If the related
records are not sorted, then the Last function returns a value based on the creation order
of the records
.
Examples
Last(ParcelBids) returns 1500 if ParcelBids is a number field defined to repeat with
ten values and contains the values 2500, 1200, and 1500.
Last(Payments::PaymentDate) returns the payment date in the last matching record
in the Payments table.