Replace Field Contents: batch field updates in FileMaker

Intermediate

Replace Field Contents updates a field in every record in the current found set in a single step — making it the fastest way to batch-update data. Learn serial, value, and calculated replace modes.

What you'll learn

The three replace modes: Replace with value, Replace with serial numbers, Replace with calculated result
How to use Replace Field Contents safely on a controlled found set
Performance implications compared to a loop-based approach

Replace Field Contents is a bulk-update step that writes a new value into a field for every record in the current found set, with options for a fixed value, a serial number, or a calculated result.

1/2

Replace a field with a fixed value across the found set

Navigate to the correct layout, establish a found set, then call Replace Field Contents. It updates the target field in every record in the current found set.

FileMaker Script

Set Error Capture [ On ]

# Establish a targeted found set first
Enter Find Mode [ Pause: Off ]
Set Field [ Contacts::syncStatus ; "pending" ]
Perform Find []

Set Variable [ $error ; Value: Get ( LastError ) ]
If [ $error = 401 ]
  Exit Script [ Result: True ]  # nothing to update
Else If [ $error ≠ 0 ]
  Exit Script [ Result: $error ]
End If

# Update all found records
Replace Field Contents [ No dialog ; Contacts::syncStatus ; "complete" ]
Set Variable [ $error ; Value: Get ( LastError ) ]

If [ $error ≠ 0 ]
  Exit Script [ Result: $error ]
End If

Perform Find: scripting finds and handling error 401 Sort Records in FileMaker scripts