Get(ModifiedFields)

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

Format

Get ( ModifiedFields )

Parameters

None

Data type returned

text

Originated in version

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.

After a record is deleted, this function returns an empty string.

Example 1

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

Customer Name Company