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.

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 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