Category: Repeating

Syntax: Last ( field )


fieldAny repeating field or related field.

Data type returned: Text, Number, Date, Time, Timestamp, Container


If the specified field is a repeating field, Last() returns the value from the last valid, non-blank repetition. If the specified field is a related field, it returns the last non-blank value from the set of related records. The order of the set of related records is determined by the sort order of the relationship. If no sort order has been specified, then the creation order is used.


When RepPercentage is a repeating field with the values .04, .05, and .06, Last (RepPercentage) returns .06.

 Last (PhoneNumber::Number)

returns the most recent phone number entry, assuming no sort is specified for the relationship.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: