You could create two layouts and run the badge stock through the printer twice.
Hard to do though. The users will be doing this, not me.
We print about 200 pages of badges.
They would have to feed it in the right way.
so unlikely to work well.
Have done duplex reports and it works well.
If you have done duplex reports and "it works well", how does this differ from using duplex printing to get your name badges?
I'm thinking that you may need to set up a two page form view report where single row portals or another method is used to produce a "grid" of badges from a related table. Page one would show the front side and page two would show the back side for the same grid of badges.
This is not a layout that you can set up using the Layout Wizard's label option
What jaymo said. Or print in "2 columns" (front in column1 and back in column 2), then fold in the middle. I guess it depends on the paper/label stock used?
I have a client that uses the 'fold' method and it works well for them.
I assume that the back and front have to match (that is information from the front relates to some data on the back. We have done this. We did use 2 layouts and also have a rather long script that reverses the sort order and adds in a blank record if the original record set is an odd number. If you
If you want a copy of the script we use, let me know and I will send it to you.
- Phil, did not think to use portals to make a grid.
- Scot, if I get something close to what I want but have trouble with
the front/back info will then ask for your script.
Will work on this tomorrow, and will see.
Thank you all.
I made two layouts using the label/badge form, 6 to a sheet.
On second layout I checked the 'facing pages' option in print setup/printing.
When printing one sheet at a time it works well.
If printing (say) 3 sheets, 18 records/badges, the side 2 for badge 1
is printed on the back of badge 13.
Typically staff print 50 sheets at a time.
Why wouldn't filemaker allow two page label layouts? The facing pages
checkbox makes the back of badge 1 print in the right place.
Will explore some more but this should not be difficult.
And Phil, printing 2 sided labels is not the same as printing a 2
sided sheet for 1 record. I just wanted to put aside that I knew how
to print duplex.
Did you try the single layout with two pages of portals? The first set of portals prints the label fronts. The second page the label backs?
The complexity come when you realize that the order of your record must change before printing the back side of the badges. Also, you have to add a record if the number of badges is odd and then delete that record after printing the back side. Our 27 step script checks for even/odd record count, adds a record to the end and then swaps the records, right vs. left so it will match the correct record. We are also saving the badge as PDFs, but that is due to the fact that they are printed away from the
location FMP is run.
The real trick is in the sort order, this is our calc for the sortOrder field that is done as a replace before producing the PDF:
Mod( Get(RecordNumber ) ; 2 ) = 0 ;
Get ( RecordNumber ) - 1 ;
Get ( RecordNumber ) + 1 )
Good Dog Database Design
- I do not understand how a grid of portals will each be assigned a
- the name badges have a graphic background, particular to that
person. Then the person info is placed on top of that graphic, then
there is more graphic/special text added to the badge. Very colorful
and special . I do not know how to get the graphic as a background
to the portal info.
(Something simple has been made complicated because we cannot do
duplex printing of labels. A shame).
Each label on a layout layout is a different record. You just create a parent table so that a portal can show the records from that labels table. These can be one row portals each with a different "initial row"--sometimes called a "horizontal portal" here in the forum though in this case, we are setting up a grid.
Basic layout details:
- Enter layout mode on a layout based on the parent table not the labels table.
- Select your duplex printer, page size and orientation
- Select "Page breaks" from the view menu.
- Drag the bottom edge of the layout body down until you get two page break lines. Then reduce the size just enough to make the second break disappear.
- Put one set of portals with the fields needed for the front in a grid above the remaining page break line.
- Duplicate all of these portals and put the duplicates below the page break line. Change the fields in the one row portals to show data needed for the back of the label.
- Print to plain paper and adjust portal size and location until all align correctly with your labels stock.
To control how the label records appear in your portal, use a script with replace field contents to put a number in a match field used in the portal relationship:
LabelsPrint::pageNumb = Labels::PageNumb
If you have stock that prints 5 labels to a page, the replace field content script would look like this:
Go to Layout ["LabelRecords" (Labels) ]
Show All Records
Sort Records (optional)
Replace field contents [Labels::PageNumb ; Ceiling ( Get ( RecordNumber ) / 5 ]
You then go to your LabelsPrint layout (with the portals) and set up a found set of as many LabelsPrint records as you need with LabelsPrint::PageNumb numbered from 1 to the total number of pages.
Note that on your Labels layout, Ceiling ( get ( FoundCount ) / 5 ) tells you how many pages that you need.
Something simple has been made complicated because we cannot do duplex printing of labels.
Well this SHOULD work to print duplex labels, but it's definitely not simple.
If this works it will be used again and again so will try.
A page is attached to show I have: the parent table, the label table,
the page 1 and page 2 of the labels using portals to make a grid. It
is lining up nicely with the labels. There will be more added to them
but this is good for now.
Now must work on getting each portal to be a different record.
That is the part that I don't get but will start that soon.
(one thing, no one thinks it should take a person any time to make
LablePage1.pdf 90.1 K
If you open portal set up and look at the bottom of the dialog, there are two important settings:
Initial Row [ ] Number of Rows [ ]
All the portals would specify 1 as the number of rows.
For the top/left portal, you specify an initial row of 1. For the next portal to the right, specify an initial row of 2 and so forth. Since "page number" is used as the link, all Label records with a page number of 1 will appear on the LabelPrint Record that also has a page number of 1 and so forth....
Well, I changed the initial row (so info disappeared) but do not have
a page number link. Will work on that Monday.