Functions Reference

FILEMAKER FUNCTIONS REFERENCE 174
Examples
GetLayoutObjectAttribute("CancelButton","objectType") returns button (if the
button was created in a new file or a file after it was converted), returns button group (if the button
is associated with a button action or script and was converted in a file from a previous version of
FileMaker
Pro), or returns text (if the button isn’t associated with a button action or script and was
converted in a file from a previous version of FileMaker
Pro).
GetLayoutObjectAttribute("CancelButton","bounds") returns 138 24 391 38 0.
Related topics
Contents
Functions reference (alphabetical list)
GetNthRecord
Purpose
Returns the contents of fieldName from the provided recordNumber.
Format
GetNthRecord(fieldName;recordNumber)
Parameters
fieldName - any related field or repeating field, or an expression that returns a field or a repeating
field
recordNumber - the record number from which you want data
Data type returned
text, number, date, time, timestamp, container
Originated in
FileMaker Pro 8.0
Description
The result of GetNthRecord() will not be updated when the record referred to by GetNthRecord()
is a record other than the one in which the calculation is currently being evaluated.
GetNthRecord of the current table returns the Nth record of the found set according to how the
current table is sorted.
GetNthRecord of a related table returns the Nth record of the related set (relative to the current
record), regardless of how the related table (or portal) is sorted.
Examples
GetNthRecord(First Name;2) returns the contents of the First Name field for record 2 in the
current table.
GetNthRecord(First Name;Get(RecordNumber)+ 1) returns the contents of the First Name
field for the next record in the current table.