Functions Reference

Table Of Contents
106 FileMaker Functions Reference
Data type returned
number
Description
Returns the total number of open records in the current found set that haven’t been saved.
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.
See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.
Example
Returns 4 if there are four open records in the current found set that haven’t been saved.
Get(RecordOpenState)
Format
Get(RecordOpenState)
Parameter
None
Data type returned
number
Description
Returns a number representing the state of the current record
.
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.
See FileMaker Pro help for information about running scripts in client/server and
peer-to-peer environments.