Script to add records via portal?

[krswitky]

Greetings all,

I've got a new FMP7 database that includes a table for DONORS, MAILINGS, and MAILINGSRECEIVED. The last table manages the many-to-many relationship for donors and mailings, and includes fields for the DonorID and the MailingID.

On a layout based on DONORS, I'm looking at a portal of MAILINGSRECEIVED and see the list of all mailings that have been sent to that donor. I can add records to this portal. This all works just fine - so far, so good.

My question is whether I can use a script to add records to this MAILINGSRECEIVED table, one each for a group of donors.

The problem I'm trying to solve is this: I have a group of, say, 400 donors that I have found via multiple finds in the DONOR table. I want to mark each of these records so that I can tell that they've received my next mailing. I can do this manually, but I'd like to automate it.

What I'm envisioning is a solution that would ask the user what mailing the group would receive. The user would select a mailing (from a value list generated via the MAILINGS table), and then give FMP the go-ahead to create a record in CAMPAIGNSRECEIVED for each donor in the found set, for that mailing.

Is this possible? Or is there another / better way to solve this problem?

Many thanks to anyone who might have some help to offer.

Kathy