Replacing the contents of a field
2.
|
In Browse mode, in the current record, select the contents of the field you want to replace.
|
4.
|
Choose Records menu > Replace Field Contents.
|
|
|
|
Replace with “< value>”. FileMaker Pro replaces the contents of the field for the entire found set.
|
|
Replace with serial numbers, then type the starting value for the serial numbers in Initial value, and the incremental value in Increment by.
|
|
Replace with calculated result, then click Specify. In the Specify Calculation dialog box, enter the calculation you want evaluated. (The result must match the field type of the replaced field.) Click OK.
|
•
|
If you select Update serial number in Entry Options, the next automatically entered value for this field (after the replace is performed) follows in sequence. If you clear this option, the next value isn't changed in the Options for Field dialog box. The next automatically entered value is based on the current settings (not in sequence with the records reserialized by this replace task).
|
•
|
In FileMaker Pro 10, there was a change to how FileMaker Pro performs the Replace Field Contents and Relookup Field Contents commands and script steps. Replace/relookup operations are now performed without committing the active record. This change only affects multiple uncommitted records in a window transaction, as when you do a replace/relookup on related records in a portal. If there are uncommitted records in the window that are affected by the operation, these changes will be made using the window's transaction and remain uncommitted until you choose to commit the changes following the completion of the operation. All other records will be modified and committed during the operation as before. For more information about committing data, see Committing data in records.
|