Syntax: Get ( TotalRecordCount )
Data type returned: Number
Returns the total number of records in the current table (not table occurrence), regardless of the state of the found set.
The Get (TotalRecordCount) function is most often used in unstored calculations and scripts. Be sure to navigate to a layout that establishes the correct table context before referencing the function.
The total record count includes records that have been created but not yet committed. If such records are reverted, the total record count is decreased.
Returns 283 when there are 283 records in the current table, regardless of the size of the current found set.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
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