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.
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
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
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