How to produce shipping labels with Box "Y" of "Z" Boxes on individual labels?

How to produce shipping labels with Box "Y" of "Z" Boxes on individual labels?

Post by Bubb » Mon, 21 Mar 2005 07:22:10


I need to print shipping labels with the usual customer info on them
(Name, shipping address, barcode, etc.) as well as which box of however
many boxes we are shipping to them, such as "Box 1 of 7", then a new
label with the same info except for the box count ( "Box 2 of 7" ).

It should be easy, but I'm stumped - I guess that happens when you're
down to three working brain cells!

Any help on this is greatly appreciated.

Thanks,

Guy

--
Final Score: Computer - 93, Brain - 0 !
 
 
 

How to produce shipping labels with Box "Y" of "Z" Boxes on individual labels?

Post by eyebrow » Mon, 21 Mar 2005 21:42:57

In article <190320051422100912% XXXX@XXXXX.COM >, Bubba



The solution depends on how you are making the labels in the first place.
There are many ways. The way I do it is to have a separate database with
label layouts that always starts with zero records. In your customer
database, there should be a number field for the user to enter the box
count. Then a button is clicked to generate labels.

The button's script first isolates the customer's record (Omit, Show
Omitted), then runs an import script in the empty label database that
imports all the needed info. It imports the box-count field into an "of"
field (BoxTotal). You now have one record for the first label.

Now you run a looping script that begins by setting a global field,
g_count, in the label database to the value of BoxTotal. Also set a
BoxNbr field to BoxTotal, then decrement g_count.

Set Field [g_count, BoxTotal]
Set Field [BoxNbr, BoxTotal]
Set Field [g_count, g_count - 1]
Loop
Duplicate Record/Request
Set Field [BoxNbr, g_count]
Set Field [g_count, g_count - 1]
Exit Loop If [g_count = 0]
End Loop

That should make a record for each box. The label layout has a spot where
you place the text and fields (in brackets) "Box" [BoxNbr] "of"
[BoxTotal]

This will print the labels in reverse order, i.e., 7 of 7 followed by 6 of
7, etc. If this annoys you, just add a sort on BoxNbr after the End Loop.

If you do not have a separate label database, and are printing straight
out of your customer database, the basic principle remains. But Filemaker
needs one record per label, so you'd have to duplicate your customer
records enough times, then carefully clean up after yourself by deleteing
all but one of the duplicate customer records. This is dangerous, which
is why I like a separate database where clean-up is as simple as "delete
all records."

If you print your labels with a separate print command for each label, no
need for duplicate records, and a version of the loop above would work.

Steve Brown

 
 
 

How to produce shipping labels with Box "Y" of "Z" Boxes on individual labels?

Post by Bubb » Wed, 23 Mar 2005 13:58:48


Steve: It would only have taken me a mer decade or two to figure that
out for myself - thanks much for your assistance.

Sincerely,

Guy

In article
< XXXX@XXXXX.COM >,