FMPRO-L Archives

November 2014, Week 2

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Peter Buchanan <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Wed, 12 Nov 2014 21:36:43 +0200
Content-Type:
text/plain
Parts/Attachments:
text/plain (70 lines)
I had an idea after Beverly mentioned constraining the found set :

Create a global_region field. 
Create a relationship -  global region -> region
Sort the found set by region, go to first record.
Set global_region field with the value in region field.
Go to related region records in a new window, print to PDF etc, and close
window.
Return to found set and constrain, omitting those regions = global_region 
And repeat until no more records in found set.

Seems to work on a test database.






-----Original Message-----
From: FileMaker Pro Discussions [mailto:[log in to unmask]] On
Behalf Of BEVERLY VOTH
Sent: 12 November 2014 16:09
To: [log in to unmask]
Subject: Re: saving grouped records to individual PDF files

Yes, the "trick" is to get your found set "saved" in a way that you can
refind, but looping so that only each region is found.

Perhaps (not tested!) you can make your find, get your "list" of regions in
the found set, LOOP and within the loop constrain the found set. I don't
know if each iteration through the loop would return you to the original
find (remember, not tested!)

If we knew *how* you get the found set, it might be easily scripted.
I also have not tested a way to recall a saved find (via script). THAT would
be a great feature request!

Beverly


On Nov 11, 2014, at 1:49 PM, Jonathan Fletcher <[log in to unmask]>
wrote:

> I agree, Peter. While someone brilliant (leaves me out) may have a better
way, that is the way I would do it. Just save your found set of regions to a
variable and step through that with the GetValue ( ) function. 
> 
> If you are using FMP 13 you can also use the new summary field option
"List of" for a quick and easy way to get the list from your found set.
> 
> j.
> 
> 
> On Nov 11, 2014, at 1:35 PM, Peter Buchanan <[log in to unmask]> wrote:
> 
>> Thanks Richard, but I do need to save each group to an individual PDF.
Can only think that I need to constrain to each region, save, and repeat for
remaining regions?
> 
> 
> --
> Jonathan Fletcher
> FileMaker Certified Developer (9 thru 13) FileMaker Business Alliance
> 
> Fletcher Data Consulting, LLC
> [log in to unmask]
> http://www.fletcherdata.com
> 502-509-7137
> 

ATOM RSS1 RSS2