Barcodes for Individual Job Lines
- Shonal Singh
- Alex Morrisson
You can generate barcodes in BUZ for individual job lines, which can be scanned and statuses updated as required.
The formula for this is =IF(ISBLANK(Data!AV11),"",I2OF5MOD10(BarcodeValue(Data!$BC$5,Data!$BD$5,Data!$AW11,1),0))
For the barcode to work in Job Scanning, the Data!$BC$5 & Data!$BD$5 cells cannot be changed. The only variable will be Data!$AW, which will start from AW11 and then AW12, and so on…
Breakdown of the formula:
IF(ISBLANK(Data!AV11),"", If the job sheet has data for that line, then produce a barcode
I2OF5MOD10 - Used by the conversion program to populate the barcode
BarcodeValue - Formula to generate value for the barcode
Data!$BC$5 - Order number
Data!$BD$5 - Revisions number
Data!$AW11 - Fixed line number. This can be a variable to allow BUZ to scan individual lines in the job
1),0) - Parameters for barcode value
Here is an example of the Job Sheet:
The Barcode width is dependant on the row height. Our recommended minimum row height is 75. You can set it lower; however, it may cut off the bottom of the barcode.
Here are some examples of what the barcode will look like with different row heights
Row Height 25 | Row Height 70 | Row Height 75 |
|---|---|---|
 |