Search code examples
excelfilemaker

FileMaker Pro - Loop data


I have an excel sheet where I am pulling and names, email and password but I would like to loop the 20 entries per excel file so when I print the FileMaker Pro entry I am not wasting paper.

How do I have FMP loop and display multiple values instead of just one.

This is what I currently have but I would like to have more displayed and not just one entry.

enter image description here


Solution

  • The simple answer to your question is to create a new layout for printing and select "List view" as the layout type. The rest should be pretty obvious as you follow the New Layout/Report assistant.

    Before printing, go to the printing layout and find the records you want to print. This can (and should) be scripted.


    Note also that if you switch your current layout to List view, you will be able to print several records per page (as many as will fit on a page given the height of the body part).