Collect values in a field across a found set

[ljensen1]

Is there a function that will automatically collect all the values in a particular field over a found set? The Send Mail script does this when you pick "Collect addresses across found set," but I can't figure out how to get the database to do it for my own purposes. I know I can loop through the records, but I'm looking for something quicker. Field index doesn't work because that doesn't limit the values to the found set.

[Fitch]

A custom function like this might be your best bet. You'll need FileMaker Advanced in order to create the function in your file, but you don't need Advanced to actually use the function.

[bcooney]

Two approaches came to mind:

1. Use a relationship that filters to the correct set of records and the List ( ).

2. Use a layout with just the field you want on it and the Copy Records script step.

It depends on what you're collecting and why. Details?

[ljensen1]

Thank you. I'll take a look at this is more detail and let you know how it goes.

[ljensen1]

I'm trying to collect email addresses across a found set. I'm using SMTP-it and I want to BCC to a large group of people. Maybe there's a way to get SMTP-it to do this, but I've haven't found it.

[ljensen1]

Copy All Records worked perfectly. Thanks!

[bcooney]

Good to hear. Do you really think the bcc is a better idea and is it really quicker? I like the personalization that can be achieved with a looping script (ie, Dear Mr. Customer,), and I wonder if a large bcc alerts the Spam police?