Skip 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 one letter at a time

Featured Replies

Hiya. I have a printing script set up such that when I hit the print icon it should spit out a standard thank you letter. And it does, but it only prints the first letter of the first person that I hit the print icon for. How do I get the script to print the record of the contact person I am actually viewing?

I have the script set up this way:

Go to Layout ["Thankyouletter" (Donors)]

Print Setup [Restore]

Print [Restore]

Thanks!

Is the letter's layout based on a different table occurence than the one you were on when you hit the button? If so, you'll need a Go to Related Record [] script step in there.

  • Author

I created the letter using a new layout but based on the Donor Table which contains the print button. Does that answer your question??

Not really, since I don't know the context of the layout(s) where the button resides.

  • Author

Hmm. Sorry, not to Filemaker saavy. Let me try again. I have a Donor Table in which I create a new record for each person who has given us money. Each record has a print button (as part of the layout, of course). I created a separate letter layout with merge fields from the Donor layout.

The hoped for action is this: After I fill out Mr. X's information, I would like to be able to hit that print button, have Mr. X's info merge into the letter that I have created and then print.

Thanks for your help by the way.

If your view/entry layout is based on the same table occurence as the print layout, then your print script as it is would either print a letter for the current record, all records, or a blank letter, depending on the option that's chosen in the Print Dialog (under FileMaker Pro).

But you said it prints a single record that's not the current record, which is why I suspect the two layouts have different table occurences as their source (check this under Layout->Layout Setup, and see what it says for 'Show records from:').

Maybe you can clarify, or post a zipped clone of your file.

  • Author

Looking under Layout/LayoutSetup

My layout Name is : Letter

Show Records From: Donor

I belive this is set up correctly in that the letter is pulling info from the Donor table. I've tried inserting Related Record and Record/Request into the print script but neither has worked. It still pulls record person #1. If I set the printer settingi to print ALL, then all records appear. I suppose I could always batch print. However. I was hoping to just print one at a time.

I would zip a copy of the database for you, but it's huge.

  • Author

One thing I should add (just realized) that the merge fields are culling from another table. But even so, the letters appear correctly in that the Donor folk are showing up. It's just a matter of getting the correct print order.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.