Help

Table Of Contents

FILEMAKER PRO HELP 1036

Originated in

FileMaker Pro 6.0 or earlier

Description

Important Replace Field Contents modifies all records in the found set. You cannot undo a Replace

Field Contents script step.

• This script step can also be used to reserialize a field in every record in the current found

set.

• When you use the Replace Field Contents script step, the data must be committed first

before the operation is performed, or you may get unexpected results. For example, if a field

value is modified and a replace is attempted before the data is committed, then the replace

will be based on the old data rather than the modified data. (For more information about

committing data, see

Committing data in records.)

• FileMaker WebDirect, FileMaker Server scheduled scripts, and Custom Web Publishing run

this script step as if the Perform without dialog option is selected.

Example 1

Assigns serial numbers to all invoices in the found set.

Sort Records [Restore]

Go to Record/Request/Page [First]

Replace Field Contents [No dialog; Invoices::Invoice ID; Serial numbers]

Example 2

Replaces the contents of the Customer ID field in all records in the found set with the contents of the

current record's Customer ID field.

Perform Find [Restore]

Replace Field Contents [No dialog; Invoices::Customer ID; Current

Contents]