recordfilemakersimultaneousfindandmodify

Filemaker 18 - Change same field on multiple records at once


I'm a fairly inexperienced FM user and have tried searching for this answer but haven't had any luck.

I'm wondering if there's a simple way to change a parameter on multiple records at once. We're using a FMDB for shot tracking in film production. I'd like to do a find to get multiple records and then click a checkbox for them all. Is there a simple way to do this rather than clicking on each one individually? I'm used to an online tool called Shotgun where you can select multiple "records" and change or add something to all of them in a particular field.

Is there a built in function for this? Or would it require some scripting of a "select all" style button (which is currently beyond my capabilities)?

FMDB screen cap


Solution

  • Yes, the Replace Field Contents command does exactly what you need. It operates on a field in the found set of records.

    It's also available as a script step so you can attach it to a button.