Get(RecordNumber)
 
Purpose 
Returns the number of the current record in the current found set.
Format 
Get(RecordNumber)
Parameters 
None
Data type returned 
number
Originated in 
FileMaker Pro 6.0 or earlier
Description 
The value returned is determined by the relative place of the record in the found set, and it 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.
 •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
Examples 
Returns 3 when the current record is the third record in a found set.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.