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:
Tom Elliott <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Wed, 12 Nov 2014 22:18:49 +0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (86 lines)
This  seems to be unnecessarily complicated.

Why not:
  open new window (retains the original found set)
  constrain by region
  print to PDF
  close window

repeat for each region

cheers

Tom Elliott

On 12 Nov 2014, at 19:36, Peter Buchanan wrote:

> 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