Jump to content

Printing quantity based on variable


Cong
 Share

This topic is 6498 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Is it possible to print a label X amount of times base on a variable in the database? The variable is not inputted by the user, but rather, is retrieved from a different database via odbc.

FileMaker Version: 6

Platform: Windows 2000

Link to comment
Share on other sites

Search through the Forums, there have been a couple of solutions posted in the past.

Most involve either multiple layouts, or creating multiple records for each label.

Link to comment
Share on other sites

  • Newbies

I found two ways in the forum to get this done, however, both methods are not practical for what I need. The first method is to duplicate the record until you get the number of labels needed and the second is to write a loop that will send a print job of one label and loop it until you get the correct amount of labels. For small qty of labels, it is perfect. The average number of labels that are generally printed is around 1000. I have to believe there is an alternative method that creating 1000 identical records for every lot number or sending 1000 print jobs to the printer. Is there a way we can pass a variable to the print copies field when printing?

Link to comment
Share on other sites

Maybe it can be done with a plug-in or a third-party scripting language like WinBatch.

Most people try to create solutions that avoid plug-ins or OS scripts because they add cost and complexity and make the solution less portable.

Link to comment
Share on other sites

How about a script that loops through, filling 14 (Avery 5162) global text fields with the approriate label text. As it sets each field, it updates a counter, when the counter hits the number desired, it moves on to the next record. When all 14 fields are filled, it prints it, and starts again from the top.

Link to comment
Share on other sites

This topic is 6498 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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