mikimonster Posted May 25, 2006 Posted May 25, 2006 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!
Ender Posted May 25, 2006 Posted May 25, 2006 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.
mikimonster Posted May 25, 2006 Author Posted May 25, 2006 I created the letter using a new layout but based on the Donor Table which contains the print button. Does that answer your question??
Ender Posted May 25, 2006 Posted May 25, 2006 Not really, since I don't know the context of the layout(s) where the button resides.
mikimonster Posted May 25, 2006 Author Posted May 25, 2006 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.
Ender Posted May 25, 2006 Posted May 25, 2006 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.
mikimonster Posted May 25, 2006 Author Posted May 25, 2006 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.
mikimonster Posted May 25, 2006 Author Posted May 25, 2006 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.
Recommended Posts
This topic is 6748 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now