Re: Acting on subsummary parts

#1

Just to pick up on the fly one sentence you made :

Quote:

FMP 7.0.3 - on a PC for now. For mac and PC use from FMSA 7.0.4 when done.
A solution made on either platform works as it in the other platform without

changing anything : just copy the file and use the FM application Mac on Mac
and PC on PC to open and run it. Both Mac and PC application versions are
given on the CD sold by FMI. Just a few precautions for the aspect of the
layouts have to be taken, care of.For example prefer to use Verdana font
with 11pt size as it it looks roughly the same way in both platforms, and if
you develop on a PC, make the size of the rectangle around the fields on the
layouts a little bigger that needed, as Macs shrinks a bit the view of them.
Just my 2 cents.
Remi-Noel

"Jim Dornbos" <usenet (AT) work (DOT) com> a écrit dans le message de news:
op.tkmc15w4z6evoe (AT) jdornbos (DOT) ..

Quote:

Well... I can export my found set to a file, import it into a temp table
then send my mail notifications looping through the temp table. It does
the job, but... I'm still open to any sort of elegant solution. - JD

On Fri, 15 Dec 2006 09:59:03 -0500, Jim Dornbos <usenet (AT) work (DOT) com> wrote:

FMP 7.0.3 - on a PC for now. For mac and PC use from FMSA 7.0.4 when
done.

Once a month, I'll be importing email logs into an existing database -
updating matched records and adding in the remaining records. In that
table, I date stamp when a record is added. The portions of the log that
I'm importing are the message date, recipient email address and sender's
email address (sender is the company employee who I'm considering as the
owner/responsible party for that recipient address).

Once done, I'd like to send each of the owners a notice by email that
they have X new records added to the database, review them at their
earliest convenience.

Looking around at my options for coming up with that list led me to
subsummary report parts. I have a subsummary report part, sorted on
ownerID, that displays the information I'd like to act on - owner #1's
address listed 1 time with my summary (AddrCount) field displaying the
number of email addresses I just imported for him followed by owner #2's
address with the number of addresses I just added for her.

On to my mail script - it sends the right number of messages (2) for
this import, but it seems to be taking the information from record 1 and
record 2 rather than subsummary page 1 and subsummary page 2. Meaning -
instead of getting an email for owner 1 saying he has 9 records added
and a second email for owner 2 saying she has 2 records added, I get an
email for owner 1 saying he has 11 records added
then I get another email for owner 1 saying he as 11 records added.

Any thoughts on where I'm making my wrong turn? My mail script right now
is hard coded to send to my address, but I'm checking the owner address
by pulling it into the body of the message, as well as the count.

Thanks for any pointers you can offer.

Jim

--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Acting on subsummary parts

comp.databases.filemaker comp.databases.filemaker

Re: Acting on subsummary parts - 12-15-2006 , 06:54 PM