Category: Get
Syntax: Get ( FoundCount ) |
Parameters: None
Data type returned: Number
Description:
Returns a number that represents the number of records in the current found set.
If multiple windows are open in the current database file, each window can have its own found set. If the Get (FoundCount) function is used in a script, it returns the found count of the active layout in the active window.
Get (FoundCount) is often used in scripts, following finds, to determine navigation paths. In the following script, if one record is found, the Detail layout is shown. If multiple records are found, the List layout is shown. Finally, if no records are found, the script notifies the user with a dialog box.
If[Get(FoundCount)=1] Go To Layout[Detail] Else If[Get(FoundCount)>1] Go To Layout[List] Else Show Custom Dialog ["Empty Set"; "No Records Found"] End If
Examples:
If 240 records are in the found set, Get (FoundCount) returns 240.
: 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