Print from barcode input?

Matthew Grisewood

• April 12, 2023 10:02

Hello, I've tried to search for this to no avail, one post was 8 years old and just went to a getting started guide. I am trying to print labels with 4 pieces of dynamic content that is being pulled from a database, I'm struggling to set this up. Basically I need to scan a barcode, and then it will print me the correct label using the database infomation, like a vlookup I've tried to use the prompt query and filter function so I am prompted for the part number so when I scan it will filter the data to the correct row I need, but I don't get how to tie the data headers to the main label, I can do this by mapping the fields to database fields but I don't want to print 30k labels I need to on demand print a label at a time on demand

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • April 12, 2023 13:23

  You need to use the Database Connection Setup option and then use the Wizard to select the type of database you are using and then what database. The settings will vary depending on the database used with some needing User/Password entry etc.

  Once you Finished the link you can then configure a Filter to allow you to type/scan a value into an Input box and then that will perform a lookup for that value on the linked field (bottom image).

  Once the label has been linked to the database, the fields will appear in the column on the left and if you are just using text fields you can just drag the field onto the label to add a database linked field. Alternatively you can go into the Properties of a field on the label and set the Type to Database and then choose which field to link to. 

  You could also use a Data Entry Form and add an Input Box that links to the Database filter/query so that appears on the form. Manual print time entry fields can also be added to this (such as for the number of labels or a batch number etc) and if you add an Image>Preview of Template you can add a dynamic preview onto the form which will update when you select the database product and type in manual information etc. This can be really useful to operators to see that they have selected the correct product and entered the right data before they start printing a batch of labels. 

   

  

   

  Filter config screen - choose new query prompt from the dropdown

  

   

  0

Please sign in to leave a comment.