Printing Different Template Or Layer In Middle Of 1 Record
Hi,
We are using Bartender 10.1 SR3
Scenario: Btw template is connected with Excel (Excel has multiple rows with varying quantities). Operator selects which record (records) to print.
Issue: If the quantity to print from one record is 1000 every 100 records we would like bartender to print 1 label of a different template or layer. This is so that we can easily sort and pack every 100 labels without stopping the printer.
Current solution: We are using a Data Entry Form, where the operator enters 100 pieces on jobs over 100 pcs. Issues with these are operator has to constantly monitor printer. Operator has to independently keep track of the sum of what they have printed...
Possible solution: Edit the excel so it has multiple rows of 100 pcs. Downside of this solution, is the operator is manually highlighting the records to print, so it is also tedious if the quantity for one record is huge i.e. 25000 (operator highlights 250 rows?)
Any suggestions on how Bartender or Excel can help me solve this?
Thank you.
-
Update: So far this is the work around for the issue of printing a different label within the same record.
In my case I would like a different label to print after every 100 copies so I can sort and package every 100 labels easier without having to stop the printer.
Create field on layer of Quantity, set it as Serialized, Reset Serialized value after every 101 or new record. In the VB scripting of the Quantity Properties,
OnPostSerialize add script.
If Value = 101 Then
Value = "SEPARATE PACKAGE"
Else
Value = ""
End If
This will cause Separate Package to print on the 101st label, so the operator when packaging needs to search for this...
0
Please sign in to leave a comment.
Comments
1 comment