Look up excel data based on user input?
I have a label that the uses a print form to scan in various serial numbers and print them. What I would like to do is take the serial number input and cross reference that on a spreadsheet to get another value that also prints on the label. For simplicity assume I have the following:
A label with a text box (part number) and a barcode (serial number). At print, the form pops up and asks for the serial number to be scanned. A lookup is then done for that serial number on a spreadsheet column A (serial number) and the corresponding column B (Part number) value is found and printed on the label along with the barcode.
Any ideas on how I can do this would be appreciated.
-
Connect the database to your label and then add a Filter in the Database connection setup. On your Data Entry form link the a Text Input Box to the query/filter you just created whilst on your template link the serial number and part number fields to column A and B in the spreadsheet
0 -
I have the same issue, but I cannot find the "filter" option in the Database connection setup.
I managed to create an Input field, where scanner data gets imported. This Scanned input is successfully shortened to a lookup string which can be found in my database.
This is how my Database connection setup looks like:
0 -
It looks like you are using an older version of BarTender and so is not called filter in that.
From memory I think you are in the correct place, if you select the Abrage.../Query... button you can set the name and text the operator sees at print time and then on the above screen select the Field to search from the Felder option and then select the Query Prompt/Abfrage you created from the Kriterien box.
0 -
Hi Pete, i am trying to capture the price based on the UPC input by user. How can link this filter option to the user input?
0 -
Click into the box with <Enter a Value> in it and scroll down and select New Query Prompt, then configure the screen that appears to adjust the name (if you want) and the Text Label to the message that the users should see and that should be all you need to do
0
请先登录再写评论。
评论
5 条评论