September 28, 201114 yr Anyone know how to go about printing a record (from form view) when the record contains a portal with a scroll bar and there are more child records than can be seen without scrolling? My portal shows 10 lines. Say there are 15 child records in the portal. How can I print the form view of the parent record showing the first 10 child records, then have a 2nd page print the same info from the same parent record in form view but have it automatically scroll to show the next 5 child records? I want it to be set up to require as little interaction from the user as possible. So a button on the layout linked to a script would be ideal, unless there's some built in feature that does this already that I'm not aware of.
September 28, 201114 yr Usually you would print from the child records view. From here you can show to the Parent data, and you can set an option on the Body part to make a page break at every 10 occurences. But if you cant fit your layout into this structure, with the child records full width in the middle of the page, you are out of luck. You can not control a portal in preview or print mode, it will always show from record 1 and up.
September 28, 201114 yr Actually - you can control which record will be the first in a portal. But this is done in Layout mode and can not be altered at run time.
September 29, 201114 yr Author Actually - you can control which record will be the first in a portal. But this is done in Layout mode and can not be altered at run time. What about altering it in browse mode? Can the scroll bar position be controlled via a script? I could have a "print" button that triggers a script to 'go to preview mode', print, 'go to browse mode', scroll 10 lines, and repeat until there are no records left. From post #2- Usually you would print from the child records view. From here you can show to the Parent data, and you can set an option on the Body part to make a page break at every 10 occurences. Does this mean that I would have to make a new layout based on the table that the child records are from, then add the fields from the parent records to the layout? What do developers do for invoices when the line items portal has too many records for one page? Say you have customer and vendor info above and below the portal that you want to appear on each page and can only fit 10 line items on a printed sheet, so your layout is limited to that. What do they do when they want to print an order with 15 line items if you want the same info outside of the portal (line items) but a new view (scrolled down) of the portal?
September 29, 201114 yr They print from a layout based on the child table, judiciously using all part types.
September 29, 201114 yr What about altering it in browse mode? Can the scroll bar position be controlled via a script? I could have a "print" button that triggers a script to 'go to preview mode', print, 'go to browse mode', scroll 10 lines, and repeat until there are no records left. No whenever you enter Preview or Print Mode the portal resets to whatever it was set up to in Layout mode. Does this mean that I would have to make a new layout based on the table that the child records are from, then add the fields from the parent records to the layout? Yes What do developers do for invoices when the line items portal has too many records for one page? Say you have customer and vendor info above and below the portal that you want to appear on each page and can only fit 10 line items on a printed sheet, so your layout is limited to that. What do they do when they want to print an order with 15 line items if you want the same info outside of the portal (line items) but a new view (scrolled down) of the portal? We do excactly that, and Filemaker will take care of the rest, it will print as many pages as it takes, fitted to the papersize you have chosen.
Create an account or sign in to comment