Category: Get
Syntax: Get ( RecordNumber ) |
Parameters: None
Data type returned: Number
Description:
Returns a number that represents the position of a record in the current found set. This value changes depending on the found set and the sort order.
Get (RecordNumber) tells you a record's position within the found set. This is useful if you want to create a calculation to display "X of Y records" on a given layout.
To determine FileMaker's unique internal record ID, use Get (RecordID).
Examples:
Function |
Results |
---|---|
Get (RecordNumber) |
Returns 1 for the first record in the found set. |
Returns 83 for the 83rd record in a found set of 322 records. |
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
Calculation Signatures
Calculation Functions
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Scripting Primer
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