...
...
| Table of Contents |
|---|
Labels Sheet
The Labels sheet controls the format of the labels to be printed for this product type.
...
This requires the installation of the BUZ Labels Windows program to print to a Label.
...
BUZ recommends the 203dpi printer with a label size of 100mm x 25mm Zebra Printer Installation
...
Add this formula to your job sheet template in a tab titled “Labels”
Ensure that you have updated/included this table in your data settings table Job sheet - Data Tab
Header | Barcode | Field 1 - Order Date | Field 2 - Order No/Revision/LineNo | Customer Name | Order Ref | Product | Location | Dimensions | Print Qty | End Format |
|---|---|---|---|---|---|---|---|---|---|---|
=IF(OR(Data!$AV11="",Data!$AW11>999),"","^XA^LH0,0^PRB,D^MD20^JMA^FS") | =IF(A11<>"","^BY2,2.7,13^FO506,20^B2N,132,Y,N,N^SN"&BarcodeValue(Data!BC$5,Data!BD$5,Data!AW11,1,0)&",N,Y^FS","") | =IF(A11<>"","^FO20,20^A0N,28,37^CI13^FD"&TEXT(Data!AY$5,"d/m/yyyy")&"^FS","") | =IF(A11<>"","^FO220,20^A0N,41,48^CI13^FD"&Data!$BC$5&Data!$BD$5&"/"&RIGHT("000"&Data!AW11,3)&"^FS","") | =IF(A11<>"","^FO20,55^A0N,30,30^CI13^FD"&Data!$BF$5&"^FS","") | =IF(A11<>"","^FO20,95^A0N,30,30^CI13^FD"&Data!AX$5&"^FS","") | =IF(A11<>"","^FO20,135^A0N,30,30^CI13^FD"&Data!BE11&"^FS","") | =IF(A11<>"","^FO20,175^A0N,30,30^CI13^FD"&Data!AY11&"^FS","") | =IF(A11<>"","^FO300,175^A0N,30,30^CI13^FD"&"W:"&Data!BA11&" H:"&Data!BB11,"") | =IF(A11<>"","^PQ"&Data!$F$10&",0,"&Data!$F$10&",Y","") | =IF(A11<>"","^XZ","") |
Multiple Labels
To print the labels multiple times in the order line sequence, set the number of copies required in the data settings (as per the example below to print 3 copies) and configure the Print Qty cell to
=IF(A11<>"","^PQ1,0,1,Y","")
...
To print the labels multiple times, set the number of copies required in the data settings (as per the example below to print 3 copies) and configure the Print Qty cell to
=IF(A11<>"","^PQ1,0,"&Data!$F$14&",Y","")
...
For more information about labels, we have a few links that can assist your setup
Installing Barcode Label Printer
Zebra Printer Installation
Zebra Programming and Label Format
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page Properties | ||
|---|---|---|
| ||
|
Zebra Programming and Label Format