Last
Purpose
Returns the last valid, non-blank value in a field.
Format
Last(field)
Parameters
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
Originated in
FileMaker Pro 6.0 or earlier
Description
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.
Notes
•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.
Last(if(IsEmpty(Company);PersonalPhone;WorkPhone)) returns the last non-empty phone number from the repeating field PersonalPhone when the Company field is empty. If the Company field is not empty, the function returns the last non-empty phone number from the repeating field WorkPhone.
Related topics