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

Get(RecordOpenState)

Returns a number representing the state of the current record.

Format 

Get ( RecordOpenState )

Parameters 

None

Data type returned 

number

Originated in 

FileMaker Pro 8.0

Description 

This function returns the state of the current record pertaining to the current user. It returns:

0 for a closed (committed) record

1 for a new record that hasn't been committed

2 for a modified record that hasn't been committed

3 for a deleted record that hasn't been committed

Example 1 

Returns 1 if the current record is a new record that the current user hasn't saved.

For an example script, see Revert Record/Request script step.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas