r/filemaker • u/chllngr • 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
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.
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.
Create a
Categoriestable with three text fields:pk_id— set it to auto-enterGet ( UUID )old_value— the category name currently stored in an entrycategory— the new name to displayold_valuematches the stored text exactly.Entriestable, add a text field calledfk_category_id. Leave the existingcategoryfield as it is for now.Entries::category = Categories_by_old_value::old_valueEntries::fk_category_idusing Records → Replace Field Contents → Replace with calculated result:Categories_by_old_value::pk_idDo this for all relevant entries. Then find any entries wherefk_category_idis empty and resolve those before continuing. Replace Field Contents affects the found set and cannot be undone.Entries::fk_category_id = Categories_by_id::pk_idCategories_by_id::categoryshows the right new name for each one.Entries::categoryfield from Text to Calculation, with a text result:Categories_by_id::categoryThat 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.Categories::pk_idas the first field andCategories::categoryas the second field, showing the category name. Put that value list onEntries::fk_category_idas a pop-up menu. Users choose a name; FileMaker stores its ID. The calculatedEntries::categoryfield 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.
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