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

Get(FoundCount)

Returns the number of records in the current found set.

Format 

Get ( FoundCount )

Parameters 

None

Data type returned 

number

Originated in 

FileMaker Pro 6.0 or earlier

Description 

If there are multiple windows open in the current database file, each window can have its own found count value, but results are returned for only the foreground window.

Example 1 

Returns 7 when there are seven records in the current found set. For example scripts, see If script step.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas