Referencing One Column Within A Database To Pull Out Information From Other Columns Within The Same Row
To begin, I work in a lab where we receive samples from the field that already have barcodes with a unique ID embedded within them. These samples are seed packets, and when they arrive in lab, they first need to be ground to flour for further processing. This means we need the ability to scan the unique ID barcode from the seed packet label and have the ability to print another label with the same information on a replacement label, so that the replacement label can be placed on a new packet that will hold the flour. As my lengthy topic title mentions, I'm trying to find out how to reference one column within an excel sheet database (i.e. scan a barcode that is embedded with text from an excel sheet- let's say specifically column 1 and row 1) and have bartender populate other single-line text fields within a label template with information from the same row of that excel sheet, but from other columns. So when I scan the barcode that is embedded with text from column 1 row 1, I want it to systematically put information from column 2 row 1 into a separate single text line on the label. Sort of like the vlookup feature in excel? For all the samples we receive in lab, we will have access to the same database that the members in the field are using to produce the original labels. I have already watched all of the training videos provided by Seagull, but I did not find information that would help with what I'm trying to perform. Please let me know if I can better explain what we are trying to accomplish and I appreciate any help that can be offered. Thank-you.
-
You're looking to configure a database query. Select file>database connection setup, then the 'query' tab, then select the field that you're wanting to use, the operator, and under 'criteria' you'll want to select 'new prompt...' to configure your data entry prompt. 0
Please sign in to leave a comment.
Comments
1 comment