Have you tried using one of the commercially available filemaker plugins that manage printer settings? FileMaker has very limited scope control over printer settings, and usually defaults to "last used" settings.
A plugin allows you greater control in the ability to set printer options via script. I'm not exactly sure what sort of support is offered for duplexing, but they are certainly better for task-specific printing than the default options.
This can be done using duplex printing, but not from a list view layout created by the layout wizard.
This has to be done from a form view layout that is two pages tall, one page for the front and one page for the back.
To place data from multiple records on that layout you use either a series of one row portals or a calculation field defined as a repeating field. Either method pulls the data from a related table of labels info.
We have no problem printing 8.5 x 11 documents, with a Filemaker layout, through our duplex printer. For example, we currently print an invoice with all the pricing and order details on page one, and images of the artwork and/or product on page two that match up with project from page one. It works great and our clients like it.
I would just like an easier way to do the same with smaller documents on 8.5 x 11 stock.
Thanks Phil...We do currently use duplex printing in the form view, and it works great. Our invoices are 8.5x11, and of course, so is the paper size. The split between pages kind of came naturally in the layout.
My challenge is creating a front / back layout, i.e. "two pages" in the smaller formats. Let me ask you this...When creating a New Layout for a postcard, would you go New Layout > Computer or New Layout > Printer? It looks like I would go to Computer > Form, and then proceed to layout the form.
I've been trying to change parts in the Part SetUp to get a page break (front / back) but don't seem to be setting it up right. I was using the Body as page one, with the Footer as page two. So far, it hasn't worked. Should I continue tweaking or is there a better way?
You have to replicate the same layout as that needed for your page of perfed labels/cards/badges
This assumes that you have multiple items per page as you've mentioned before so there would be no "smaller page sizes" used here.
If you have, say 9 items per sheet of stock, then you would set up an 8.5 x 11 sized layout and position 9 1-row portals or 9 repetitions of that calculation field on that layout to print the front. Then you'd drag the bottom edge of the layout down to double the height of the layout. You'd then position another 9 such portals or fields to show data from the same 9 records, but this time, the data for the back of the stock.
I've helped someone else with the same issue not too long ago. Check out the info and demo file found here:
Yes, I read all three pages of that thread yesterday. I'm obviously missing something. In my wish list, I have a form layout that displays my invoice off to the right. (I am already in our invoice database. This is just a different layout in that file. The invoice will not be printed in this layout, it's just there for reference.)
On the left side is page 1 / page 2 (front / back) of a smaller form. Let's say a postcard.
The address on the p/card will be duplicated from the invoice. Actually, the address fields will be duplicated. Same as the photos from the invoice. They will also be duplicated on the postcard. There is a block for text on the postcard form.
This set-up would allow me to Find a set of records (invoices) and scroll through them, one at a time, and jot a quick note on each postcard form referencing info on the invoice. Such as, "Hey Phil, it's that time of year again, would you like us to start working on artwork for X? Here are images of what you did last year." You get the idea. We really want to be able to personalize our direct mail on the fly.
Once completed, I would print to our duplex printer. Only the postcard info would print.
Where does this fail for you? I can't tell what you are missing.
You do realize that you need to put the front side (page 1) at the top and the back side (page 2) BELOW page 1?
Once you can pull up a found set of records with the data for both front and back side, it's a matter of capturing the ID's of those found records in order to set up a relationship that matches only to those records in order to bring them up in the one row portals. You also have to "paginate" the records by assigning page numbers so that you can create as many records on the form view record as you need sheets of stock for printing the found set and still get the right set of records showing up on each record.
Phil...I think I'm not doing something related to portals and pagination. While I've created forms, documents, and registers that have allowed us to run our business on Filemaker since it was a Claris product, I'm still a noob in some regards. Portals and pagination are probably a couple of those.
I did create my dream page as mentioned above, with the invoice showing to the right, and a layout for postcards to the left. You'll find the draft of that layout below. (Minus our company name) I created a duplicate of this layout to print the address side, with additional personalized copy. It works great, but it means printing everything twice.
By the way, I really do appreciate your assistance. This is a project I've wanted to get finished for...oh...a few years.
That layout won't work for printing duplex to an avery type sheet of cards, labels or badges.
The only thing to put on that layout would be the one row portals. These have to be arranged in a gird format to match the layout of your stock. You then have to create a second grid for the back side of the stock to position below the first. The layout you show does not do that. This was all discussed in detail in the other discussion that I referred to earlier.
There are multiple options possible, here's one scenario that you might use for a 9 card per sheet format. For other numbers of cards to a sheet, just update the number 9 where found:
a) Define a new table in your solution named DuplexPrint. Define two fields: gPrimaryKeyLIst--global text field and SheetNumber (number field).
b) define a relationship between it and Invoices like this:
DuplexPrint::gPrimaryKeyList = Invoices::PrimaryKeyFieldHere And
DuplexPrint::SheetNumber = Invoices::SheetNumber
c) Perform a find for the desired invoice records on a layout based on invoices. This can be via script or manual find.
d) Use a "list of" summary field to get the list of the primary keys for this found set of invoice records. Set DuplexPrint::gPrimaryKeyList to the value of this summary field.
e ) Add a number field, SheetNumber to the Invoices table. Use Replace Field Contents with the following calculation to assign a sheet number to each invoice:
Ceiling ( Get ( RecordNumber ) / 9 ) // the first 9 records will be assigned to sheet 1, the next 9 to sheet 2....
f) switch to the DuplexPrint layout where you have your 2 page form view layout. set up a found set of records equal to Ceiling ( ValueCount ( gPrimaryKeyList ) / 9 ). Put the values 1, 2, 3... into the sheet number fields of these records.
g) Use the "records being browsed" option to duplex print.
Now, I feel like one of those contestants on Shark Tank..."OK, does anyone else have an option?" To someone who is not a professional developer, that seems like a bit to chew, BUT, I will begin to start working my way through this. You took the time to assist, I'll try and follow your instructions. It may take a while, and I may post back with some noob questions, but I'll give it a go.
Layout For Two-sided "Labels" Printed with Duplex Printers
Perhaps a few folks could visit that post, and vote it up. Seems like a great feature for FM Pro.
It's not as hard as the written description sounds. Much of the layout can be created by setting up one portal and duplicating it. You then modify the initial row setting in portal set up of each duplicated portal. For page two, you swap out the field used for a different field to show the back.
The tedious part is aligning the portals to the layout of your card stock. Typically, you end up doing a number of test prints to thin paper and then comparing alignment to the actual stock.
I have no objections whatsoever to others chiming in if they have a simpler method. That's how all of us learn here in the forum.