Reference > Functions reference > Get functions > Get(RecordNumber)
 

Get(RecordNumber)

Returns a number representing a record’s position 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 the Get(RecordID) function.

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.

Example 1 

Returns 3 when the current record is the third record in a found set.

For another example, see Get(ActiveRecordNumber).

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas

Get(ActiveRecordNumber) function