Get(RecordOpenState)
 
Purpose 
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 
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
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.
 •
For information on how functions evaluate differently on the host versus the client, search the FileMaker Knowledge Base available at http://help.filemaker.com.
Examples 
Returns 1 if the current record is a new record that the current user hasn’t saved.
Related topics 
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Was this topic helpful? Send feedback.