How To Auto Calculate Serialized Copies From Start No. And End No.

Shotaro Ito

• October 27, 2011 07:48

Posting a sample - It demonstrates how to control number of serialized copy from VB script.
[attachment=45:GenerateSerialCopies.zip]
[list=1]
[*]Create a text(or barcode if you want) for serial number.
In modify > datasource tab > switch to advanced datasource dialog. in Share / Name minitab, name the substring as "SERIAL".
In more option > Serialization tab, enable serialization.
In Prompt tab, create a text input box and set user prompt as "Serial Start:"
In Validation tab, select number only.

[*]Create a hidden text above label for end number.
In modify > datasource tab > switch to advanced datasource dialog. in Share / Name minitab, name the substring as "SERIALEND".
In more option > Prompt tab, create a text input box and set user prompt as "Serial End:"
In Validation tab, select number only.

[*]Set Script in Serialized copy.
In Print dialog > Quantity minitab > Number of Serialized Labels > Options, select [Set by Data Source]. Data Source tab appears.
In data source tab, select VB Script > Event control Scripts > Edit.
In AutoSelected Event, set script
[code]Value = 1[/code]
In OnPostPrompt Event, set script
[code]Value = 1 + Format.NamedSubStrings("SERIALEND").Value - Format.NamedSubStrings("SERIAL").Value [/code]
[/list]
To use VB Script you need Pro edition or above, the attached sample should work on BarTender 8.01 Pro and later.

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • July 02, 2014 03:50

  Found that old zip file not working, reattached the sample btw document.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • October 29, 2014 16:59

  I was wondering if this would be the solution to an issue that I am having setting up a serial label.  At the moment our need is to have a label that uses 3 fields, date, item description and a quantity count.

   

  The date is static as I added the time /date field box that will display current date /time

  the description is present to the general description that is used and allows manual entry in case the description changes

  the quantity normally ranges and this is where my problem begins.  I need to have this field serialized and it needs to be able to print 2 of each serial label.  I have attempted to use the serial option and printer setup and have not been able to generate the label that I need.  I can print 4 labels all containing the same quantity or 4 labels with serialized count (1-4) but cannot get 2 of each and serialize them.

   

  Any help would be greatly appreciated.

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • October 30, 2014 01:36

  the quantity normally ranges and this is where my problem begins.  I need to have this field serialized and it needs to be able to print 2 of each serial label.  I have attempted to use the serial option and printer setup and have not been able to generate the label that I need.  I can print 4 labels all containing the same quantity or 4 labels with serialized count (1-4) but cannot get 2 of each and serialize them.

   

  I'm not exactly sure what you intended - if you want to create serial number like

   

  2

  2

  4

  4

   

  for 4 serial labels, then you can set value as 2, then Increment by 2, and event interval 2.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • July 01, 2015 10:09

  How I can to add in the "Data entry form" the third field with quantity of labels (serial numbers)?
  1) To make this field is updated automatically when update the data in the first two fields.
  2) To be able to specify not only the first and last, but any combination of:
  -first and last
  -first and quantity

  0

Please sign in to leave a comment.