Record selection
We currently use bartender 2016 to print labels from a database, with some information (date, quantity of labels) selected at print time, some information populated from the record selector (description, EAN, units per outer) and a sequential number included with some information combined to make a barcode. I'm trying to design a label that can duplicate all of this information (except the sequential number) from scanning the original barcode. Whilst i can do all the user selected information i cant get the description as it's not stored in the barcode of the original, and i'm no longer using the record selection.
Is there a way i can select a single record using unique information (such as product number) i do have. if possible id rather not use scripting as this disables the preview at print time which we would use to check information visually before printing.
The way i envision it is like a vlookup in excel. Scan the barcode, find the product number, lookup the description for that product number in the database.
-
You need to create a filter in your Database Connection Setup, and set this up to query the field where the data is stored and then choose new query prompt and enter a name and description/question for your prompt:
So something like this, where i am setting up a search to use the First Name field for my value
You can also add the query/filter lookup entry field on to your Data Entry form like a normal Prompt at Print entry field as the name of your query (from above - I called mine EnterName) will appear in the list of fields that you can connect to from the LinkedFields option as per the image below.
Note: you will need to set the "Text Label" to something the operators would understand, such as "Scan Barcode" in your application etc.
I hope this helps
Pete
0 -
Thank you Peter.
I've tried to use queries and filters but the issue i have is the input is a barcode scan, 20+ characters long the filter i need is only the first 8 characters of this scan (i use the other information for other fields on the label.
I was hoping to be able to do this without any interaction other than scanning a barcode and selecting a quantity to print.
0 -
If you go into the Filters and click on the Query Prompts button you can access the More Options button and set up Truncation like a normal text field and so set it to only keep the first 8 character on the left and that should get your look up going.
You could probably set up something to scan, do the database lookup, and the then Tab and fill in the other data from the one scan too, but that would take a bit of setting up, and so it maybe better to just scan the code twice and set up truncation etc. on your other entry fields to only use the bits you want. The first scan being used as the database lookup (this can sometimes take some time to complete so again another reason to do a double scan), which could also be used to display the selected record data on the Data Entry Form (preview of template image option) and then the second scan that fills in the other fields which will also appear on the preview if configured correctly.
Pete
0
請登入寫評論。
評論
3 條評論