5 Replies Latest reply on Apr 29, 2015 2:23 PM by indiguy

    Hiding Lines in Empty portal row



      Hiding Lines in Empty portal row


           Hello Gurus,

           Can you please help me with this: I have a portal with 10 rows, my problems is that if I have only 5 items to be displayed there are empty rows in the portal. 

           Is there a trick that I can hide the empty portal rows?


           Thank you.



        • 1. Re: Hiding Lines in Empty portal row

               You mean that with 5 portal records, you have 5 additional empty rows showing? In Browse mode, this is pretty much the nature of the beast. In preview mode or when you print or save as PDF, you can make the unused rows disappear by setting the portal to slide up. But it's generally better to print or save as PDF from a list view layout based on the portal's table instead of using a layout with a portal if that is at all possible.

               Key facts about sliding layout objects:

          1.           It's only visible in preview mode and when you print/save as PDF...
          3.           Sliding fields will shrink but not expand.
          5.           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.
          7.           Objects in headers and footers will not slide.
          9.           Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
          11.           Fields will slide up only if Top alignment is specified for it and will slide left only if Left alignment is specified.
          13.           Consistent side borders are difficult to achieve with sliding fields.
          15.           In FMP13, hidden objects (”Hide object when”) will slide/resize.
          • 2. Re: Hiding Lines in Empty portal row

                 Hi Phil, 

                 My portal was set to 10 rows, Im using it into my dash board to display the products that will be expiring next month,my problem is if I only 5 or 6 products that will be expiring next month, the portal is having a 5 or 4 blank rows at the bottom, I want to eliminate the lines.



            • 3. Re: Hiding Lines in Empty portal row

                   And that will not be possible with that layout design.

              • 4. Re: Hiding Lines in Empty portal row

                     But note the screen shot that I've uploaded here. Note that by using fields with contrasting fill colors, it's very clear that there are only a 2 records in each portal. If I cleared the "allow creation of records via this relationship option", the bottom blank row would also disappear.

                • 5. Re: Hiding Lines in Empty portal row


                  if you are using portal to create records and not just display some related history then nstead of creating portal row via relationship, use script and you will get rid of that empty row..

                  here is the script I am using to disappear that blank row problem..

                  Add line Items To Order

                  Set Variable [ $Serial Number ; Value:Orders::Orders_Id ]

                  Go to Layout [ “Orders_LineItems” (Orders_LineItems) ]

                  New Record/Request

                  Set Field [ Orders_LineItems::Orders_Id_Fk ; $Serial Number ]

                  Go to Portal Row

                  [ Select; Next ]

                  Go to Layout [ original layout ]

                  hope this will help you..