Get(RecordOpenState)

Returns a number representing the state of the current record.

Format 

Parameters 

None

Data type returned 

number

Originated in 

FileMaker Pro 8.0

Description 

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

Notes 

•This function returns the state of the current record pertaining to the current user. 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 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