5.1 Search and replace data

5.1 Searching and replacing data

As in a word processing program, you can search and replace data in several fields (including related fields) of a data record or a search query, in a result set of data records or search queries or in text objects in a mask.

  • In browse or search mode, select in the menu bar Edit > Find/Replace > Find/Replace
  • Enter your search term in the field Search for in.
  • Enter the data with which the search term is to be replaced in the Replace with in.

Data in fields that are formatted as pop-up menus, radio buttons or checkboxes cannot be replaced. These fields are counted and after completion of the process Replace everything are displayed as skipped fields.

5.1.1 Replacing a field value with calculated values

510-field-content-replaceYou can replace a field value with a calculated value. All field values in the current result set are replaced with the calculated value.

First create a selection containing all data records in which you want to replace a field with a calculated value. Click in the field whose value you want to replace with a calculated value.

In the menu bar, select the item Data records > Replace field content button. A dialog box then appears in which you can replace data records with a fixed value, a consecutive number or a calculated result.

If you replace the value with a calculated value now click the option Replace with calculated result button. This opens the formula editor, which can be used to perform all calculations that FileMaker supports. Further information on the possibilities of calculated formulas can be found in the FileMaker documentation.

Once you have entered the calculation in the formula editor, click on the [OK] button. In the dialog box below, click on the button [Replace]. The value of the specified field is now replaced by the calculation you have specified in all data records called up.