2 Replies Latest reply on Jun 19, 2014 9:16 AM by artdoc

    Print a specific range of portal rows



      Print a specific range of portal rows


           I can't find an appropriate way to script a change of pirtal rows? Example: if I have 20 lines on a page and  43 items to list, a script woult count my rows (not hard) and then after printing P1, the script would reset the portal to display 21-40, then a p3 for the remaining lines. I could dynamically number the pages P1,P2, etc.


           Right now I have several forms that could each need more then one page so I have had to create layouts for P2 versions of each. I would like to not have to create p3 versions if I could script this; I can and will, but then I had this notion.


           Am I deluded?






        • 1. Re: Print a specific range of portal rows

               It's possible, but may not be necessary if you can get this much simpler approach to work:

               Base a list view layout on the portal's table and include field from your current layouts table in the header, footer or grand summary layout parts. As a List view, your layout will automatically adjust to print any number of records from your portal table all from a single layout. The trick is to use a script to pull up a found of just the related portal records for a given "parent" record from the table that your current layout is based on.

               The Invoices Starter Solutions that come with FileMaker 11,12 or 13 all use this method for printing the line items portal of records on an Invoice so you can look at them for a more detailed picture of how you might set this up.

               And yes, this isn't always an approach that you can use, so let me know if other considerations keep this option from working for you.

          • 2. Re: Print a specific range of portal rows

                 A little delayed, but now a report: Your suggestion put me on a new track, and after taking a new approach, I have solved my problem. Your mention of a list view (not a portal) was the key!

                 Without unnecessary details, I'll just say that I have scripted a method to find the job-specific line items and use a list view with great success. In retrospect, it's so obvious. Now I will polish the look of the payout for printing, but I have exactly the solution I was hoping for, and I dont have to keep recreating new pages to hold overflow. Perfect!

                 Thanks for your help.