Hello,

I hope this is the best section to ask this question. I'm using BarTender 2022 Automation and think VB script is the answer but not sure how to go about it.

I have an item that starts as a single large item, which is then sectioned into 10 rows. Not all rows pass QC so they're may be rejects which are not processed further and don't need a label.

In turn each row is then coloured but this is not always uniform and can vary for each row, so there is a dropdown to select a different colour from the default. 

The aim is to produce a label for each row (where the row passes QC) which starts with the parent item ID, then has the Row number 1-10, then finally has the colour. This would be in a human readable Aztec barcode label. They would all be printed on the same job.

I have setup a Form with the following:

• An input for the parent sheet ID (the start of the identifier)
• For each of the 10 Rows an individual checkbox with a "Don't Print" option and a drop down to select the colour.

So far so good.

How can I use this information to print a unique label for each Row that is not checked "Don't Print" and has the correct Row and colour information?

Any help or pointers on this would be great!

Thanks,

Paul