AnsweredAssumed Answered

Help with Bulk Adding Field Values Based to a Search Result Set

Question asked by AnthonyBaker on Jul 12, 2013
Latest reply on Jul 12, 2013 by IT_User

Title

Help with Bulk Adding Field Values Based to a Search Result Set

Post

     Hey Folks,

     I'm relatively new to FileMaker Pro and am currently using it to audit and make sense of a collection of 190,000 items.

     Would love some feedback on how to accomplish an item that will make a world of difference for me:

     I was originally conducting searches in my data to PRUNE (delete) items that were not needed. Would look like: "Search for all items in the collection that have a name of 'c_' and get back 10,000 items and then delete them all."

     Instead, however, what I'd like to do is conduct a search for a set of the items, then bulk-add a value to a field tied to these items. Something like this is easily accomplished in Excel — highlight a column, and bulk-paste a single value for all rows in that column.

     "Search for all items in the collection that have a name of 'c_' and get back 10,000 items and then set the value of a field called 'Action' to 'Remove'."

     Not clear, however, how a setting the value of a specific field on all items from a search can be accomplished. There doesn't seem to be a "SELECT ALL" option for a given field...

     Any thoughts? Would prefer to be able to do this in FileMaker Pro directly, versus doing a CSV export or something of my search sets and doing the field value setting in Excel, then re-importing. That's tedious. 

     Thanks a lot!

      

Outcomes