1 Reply Latest reply on Jun 30, 2011 3:32 PM by philmodjunk

    Trouble Creating a Flexible Layout



      Trouble Creating a Flexible Layout


      I am trying to make a layout for a printed report for a quote generating system.  The report will consist of a header with company info, a body with opening statement from a field, and part itemization (portal), and a closing statement, from a field.  Finally there is a footer with company info.

      The part that I cannot seem to get to work is the body.  All three parts of the body (opening statement, itemization, and closing statement) need to be able to contract and expand based on the amount of information included in the quote.

      For example a very simple quote may contain a very short paragraph for the opening statement, one or two items in the itemization, and a very short closing statement.  But, a complex quote may need to be several pages long with a very detailed opening statement consisting of several paragraphs, a large itemization, and a closing statement of several paragraphs.

      1. Is it possible to create a flexible layout like this in FileMaker, and

      2. Can I get some direction on how to begin?



        • 1. Re: Trouble Creating a Flexible Layout

          I think you'd be better off designing your layout so that it is a list view layout based on your portal's table rather than the quote table. That takes care of your itemization list varying in length. You can still pull data from your Quote table and place that data in a header and a footer. If you look at the invoices starter solution, you'll see that's how it prints an invoice.

          For your opening and closing paragraphs, use leading and trailing summary parts with a text field sized to the maxium practical size, then set them to "slide up" "resize" enclosing part.

          To print a quote, you'd use a script from your Quote layout that uses either Go To Related Records or performs a find to pull up just the item records for your current quote.

          Key facts about sliding objects:

          1. It's only visible in preview mode and when you print/save as PDF...
          2. All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
          3. Objects in headers and footers will not slide.
          4. Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          5. Consistent side borders are difficult to achieve with sliding fields.