Get(RecordOpenState)
Purpose 
Returns a number representing the state of the current record.
Format 
Get(RecordOpenState)
Parameters 
None
Data type returned 
number
Description 
Returns:
  •
0 for a closed or committed record
  •
1 for a new record that hasn’t been committed
  •
2 for a modified record that hasn’t been committed
Notes
  •
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 www.filemaker.com/kb.
Examples 
Returns 1 if the current record is a new record that hasn’t been 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.