Need to enter random serial numbers on a data entry form

Mike Wolfe

• 26. April 2021 16:00

We remanufacture many products in large quantities and need to print a part number label with the serial number on it. Much of the label data comes from a database except for the serial number which is not yet in the database at the time the label is printed.

The serial numbers are quite random since these are returned products for remanufacture. When I go to print the labels, I'd like to enter the item number for the product which will pull data from a database. Then I'd like to enter a list of the serial numbers for the labels to be printed.

We are using BT2021. Does anyone have any suggestions on how to easily create a list at print time?

Thanks,

Mike

0

• 

  Kendra Newman

  ★ BarTender Hero ★

  • 3. November 2023 19:51

  I realize this post is a few years old, but I am trying to do the exact same thing and wondered if anyone had a suggestion.

  We're using BT2022

  Thanks,

  Kendra

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • 6. November 2023 10:06

  There is a random function in VB however that would only randomise the number for that print run and would not check with that number has already been used and so if you need that then you would need to generate the number outside of BarTender and pass the number to use to use it.

  If you include a serialised field to your label (or off the side so it does not print) and link this to the number of labels you want to print then including an OnSerialise Event Contrlled VB Script field with the RND command will give you random number each time the serial number/count increases. For example this will print a number between 1 and 1000

  Value = Int((1000 - 1 + 1) * Rnd + 1)

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.