Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Printing a list of records on to a form letter

Featured Replies

Ok, I am new to FileMaker so please ask any questions if I leave out an important detail.

What I am trying to do is print a letter that has a variable amount of information in it. 

I have a table with clients and a related table with invoices in it. 

What I would like is a letter that has some client information at the top, ie our logo, the date, and the client's mailing address, then a little message about the invoices. Then I would like it to print all the out standing invoices number, date, and description. (all fields in the invoice table) and end with a nice statement with the total number of outstanding invoices and please pay etc. 

I tried making a list layout using the invoice table with all the client info in the header, then the information I wanted in the body, then closing statement in the footer. 

Something like:

Header: Logo, <<client::address>>, dear <<client::fullname>>

Body: Invoice numb:<<Invoice num>>  On <<Date>> work done: <<Description>>

Footer: Nice message with a total and please pay etc

When I run the script to go to related records, do my find and sort by script it looks ok. All the invoices are listed.

But when I print the layout it breaks each invoice record in to a new page. ie

Header

Invoice 1

Footer

Header 

Invoice 2

Footer

etc

How Can I get a print out like looks like:

Header

Invoice 1

Invoice 2

Footer

I am so close on getting the letter done. I have the scripts selecting the correct invoices. Now I need to get all the invoices printing in the middle of the header and footer and I will be good. 

Help!!

-=fred=-

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.