3 Replies Latest reply on Jun 8, 2011 12:32 PM by philmodjunk

    Customizing number of rows in portal display?

    sabrown

      Title

      Customizing number of rows in portal display?

      Post

      I find the portal layout with a fixed number of lines a little restrictive on my invoice layout. It would be ideal if the number of lines visible was based on the number of items entered into the portal, and not a fixed number. This way, if a buyer only buys three items, I won't have 8 empty rows displayed below it when the invoice is printed.

      Any advice or solutions for this?

      Thankyou,

      S

        • 1. Re: Customizing number of rows in portal display?
          philmodjunk

          You can set the portal to slide up/also resize enclosing part. This sliding will only be visible when you print/preview or PDF your layout.

          Better yet is to print from a list view layout based on your portal's line items table with fields from the invoice record placed in the header and a trailing grand summary.

          You can see an example of this in Comment's Invoice demo file:

          http://fmforums.com/forum/showpost.php?post/309136/

          • 2. Re: Customizing number of rows in portal display?
            sabrown

            I tried to do the list view version but I am struggling a lot with the layout. I tried to follow the system in Comment's invoice demo file, but the sub-summary areas werent displaying properly and when I print the invoice an individual sheet for each individual item comes instead of an overall list view.

            Maybe the first part of your solution would be easier for me than the list view layout? What do I need to do to set the portal to slide up or resize enclosing part? I didn't see anything about that under the portal setup menu, can you give some more details?

            Thanks,

            S

            • 3. Re: Customizing number of rows in portal display?
              philmodjunk

              Make sure your layout is set to list view, not form view.

              If you add sub summary parts to your layout, you must also sort your records by the "sorted by" field specified for that sub summary part.

              Object sliding is an option you set in the Inspector (FileMaker 11) or select from the format menu (older versions). But don't go there until you make at least one more try with your list layout.