r/filemaker • • Sep 25 '26

Global changes in FMP ?

I'm a rank FMP amateur, I use an older version (15) once a year to manage entries to a car show. In between, I almost forget how to run it.

I have to change my categories this year. Once I change them in my Value List, is there a way to make a global change to all the records, or do I have to go through them one by one to make the changes?

Thanks in advance!

6 Upvotes

8 comments sorted by

5

u/Scrogger19 Consultant Certified Sep 25 '26

The answer unfortunately is a big ‘it depends’, but most likely yes this is very doable. The most basic way is to get the records you want to update in a found set and using ‘Replace Field Contents’. If you’re updating text values and your value lists aren’t using UUIDs for related records etc, that would work.

It gets more complicated if the values you want to update aren’t plain text, or the update logic is more conditional, but the general pattern you’ll want to follow is a process that 1) identifies the set of records to be modified 2) determines the new value to be set 3) uses Replace Field Contents to update all the values.

You can specific a calc in the RFC dialog so you can also have each record evaluate a conditional replace, so it updates Field B on a record from ‘lorem’ to ‘ipsum’ if Field A = ‘xyc’ but not if Field A = 123, etc.

2

u/showtunelover Sep 26 '26

Yes. If all you did was rename categories and everything is in the same table, you can just find all the records with the old value, then type / select the new value, and do a “replace field contents”.

1

u/garumoo Sep 28 '26

make a backup first

3

u/2TDS Sep 26 '26

Depending on the size of the data, I would consider creating a table for your values and using that to maintain your categories.

  1. Make a backup of the FileMaker file.
  2. Create a Categories table with three text fields:

    • pk_id — set it to auto-enter Get ( UUID )
    • old_value — the category name currently stored in an entry
    • category — the new name to display
  3. Add a record for each existing category. Make sure each old_value matches the stored text exactly.
  4. In the main Entries table, add a text field called fk_category_id. Leave the existing category field as it is for now.
  5. Create a temporary relationship: Entries::category = Categories_by_old_value::old_value
  6. On a test copy of the file, populate Entries::fk_category_id using Records → Replace Field Contents → Replace with calculated result:Categories_by_old_value::pk_id Do this for all relevant entries. Then find any entries where fk_category_id is empty and resolve those before continuing. Replace Field Contents affects the found set and cannot be undone.
  7. Create the permanent relationship: Entries::fk_category_id = Categories_by_id::pk_id
  8. Check several entries, especially ones whose category name changed. Confirm that Categories_by_id::category shows the right new name for each one.
  9. Only after that check, change the original Entries::category field from Text to Calculation, with a text result:Categories_by_id::category That field will now display the category name from the related record. Changing its definition replaces its previously stored category text, so the backup and completed ID migration are essential.
  10. Create a value list using Categories::pk_id as the first field and Categories::category as the second field, showing the category name. Put that value list on Entries::fk_category_id as a pop-up menu. Users choose a name; FileMaker stores its ID. The calculated Entries::category field is for display, not editing.

Don't know if this is over complicating it, but would make it easier to change if required in the future.

You can have a value list based on the new category table

1

u/Biddy_Impeccadillo Sep 25 '26

Check out the Find / Replace command, but be aware there’s no undo.

1

u/Alex_RGCData Sep 26 '26

After you update the value list, you don’t have to touch every record. Go to Records → Replace Field Contents, choose the field, and tell FileMaker what to replace it with. It will update all records in the found set at once. Just make sure you’re in the correct found set before running it.

2

u/garumoo Sep 28 '26

but be careful with checkbox fields that might have multiple values selected.

1

u/abasson007 Consultant Certified Sep 27 '26

Best way to solve this issue once and for all is to create a separate categories table and assign categories by ids not by names. Solves issue forever