Functions Reference

Chapter 7
|
Get functions 95
Data type returned
number
Description
Returns the number of the current record in the current found set. This value is determined
by the relative place of the record in the found set, and changes depending on the find
criteria and the sort order.
Notes
• To return a value that uniquely and permanently identifies a record in this table, use
Get(RecordID).
• If you specify the context for the current calculation, this function will be evaluated
based on that context; otherwise, it will be evaluated based on the context of the
current window.
• See FileMaker Pro Help for information about running scripts in client/server and
peer-to-peer environments.
Example
Returns 3 when the current record is the third record in a found set.
Get(RecordOpenCount)
Format
Get(RecordOpenCount)
Parameter
None
Data type returned
number
Description
Returns the total number of open records
in the current found set that haven’t been saved.
Notes
• If you specify the context
for the current calculation, this function will be evaluated
based on that context; otherwise, it will be evaluated based on the context of the
current window.
• See FileMaker Pro Help for information about running scripts
in client/server and
peer-to-peer environments.
Example
Returns 4 if there are four open records in the current found set that haven’t been saved.