Get(ModifiedFields)

Returns a list of fields that have been modified in the current record of the current table.

Format 

Parameters 

None

Data type returned 

text

Originated in 

FileMaker Pro 13.0

Description 

Returns a list of fields modified since the last time the record was committed. The list includes stored calculation fields that are dependent on one or more fields that have been modified. Field names are separated by carriage returns.

For a new record, the list is always empty because the record has never been committed.

Example 1 

When the Invoices::Customer Name and Invoices::Company fields are modified and the record is open, Get(ModifiedFields) returns:

Customer Name
Company

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas