CODEWITHSUNDEEP
recordfilemakersimultaneousfindandmodify
deepstructure
deepstructure

Reputation: 778

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

Upvotes: 1

Views: 1293

Answers (2)

deepstructure
deepstructure

Reputation: 778

I created a button to do this. This required learning a few things:

  1. Create a script (under Scripts -> Scripts Workspace), using Replace Field Contents function, and point it at your checkbox field, with "Current Contents" as the replace option.
  2. Create a button and for the Button Function, choose Perform Script and point to your script.
  3. To use: Perform a Find to create a found set; then click the field on the first record to either check or uncheck your box; then click your button. This will then check or uncheck this field on all the rest of the found records.

enter image description here

Upvotes: 0

AndreasT
AndreasT

Reputation: 2337

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.

Upvotes: 1

Related Questions