Sweet Weights with Barcode
I apologise now as I am more than likely not to explain this very well!
We sell Pick and Mix sweets. I have an excel spreadsheet with all 168 sweets we sell. PM0001 is record 1, so the database works well. The warehouse simply change the weight of the bag they are packing. These will either be 100g, 250g, 500g, 1000g or 1500g. Now we want to use barcodes for picking and packing, we need to have separate barcodes for each size. With this, we can no longer have record 1 for sweet number 1 as it will now need 5 row in the database.
I was wondering if it was possible to use a form for us to enter the sweet number, a drop down box for the weight and for it them to cross reference both these in the database to get the correct barcode.
I have tried the select records, but when we scan the SKU and then tick the correct record, we then start entering the next record, it unselects the original one, so unable to do it this way.
Any pointers will be appreciated.
Jamie
-
Yes, this should be possible as long as you had a line in the database for each product and weight combination.
In your Database Connection Setup add two filters, one that is linked to the product number and the second that is linked to the weight.
On your Data Entry Form add a text entry box for entering your product code, linked to the product number filter you just created and then add a drop down list entry box linked to the other filter. The list items will probably need to be fixed or you could try getting the values from that database field but I think you will see multiple weights the same (ie for every line in the database) if you try it this way.
1 -
Hi Peter,
Thanks for your input. I have started to look at this. Is this where I should start by creating the filter:
I have had a read of some of the filtering data help articles, but not sure if this is where I should be doing it and how I would create 2?
Thanks again.
0 -
In the Filter box click on the little green plus sign next to the AND and then that will start the first filter.
For yours select the P/N field and I would suggest leaving the operator as Equals and then in the dropdown on the right scroll down to New Query Prompt and then setup what the user will see.
Once done click on the green plus again to add a second filter for the Weight selection.
1 -
Hi Peter,
Thanks for this, working like a dream.
Is there anyway that the form can stay open after they print a label instead of being returned to the Designer? As they have over 100 labels to print each time, would be handy if they can stay in the Entry Form as they will not really need to be out of it.
Thanks again,
Jamie
0 -
Yes, on the File>Print>Options tab you need to tick this
0 -
Thanks Peter!
Another couple of quick questions, which may be pushing it too far, however:
Can you have it print as soon as you click print without it taking you to the print screen and then having to click print?
Also, I have been playing with the validation on the first text field. Our P/N is PM0001 to PM0168 currently. Is it possible to just type 168 and for it to validate the rest (Starts with PM, and missing 1 digit, so put in the missing zero?
Thanks again,
Jamie
0 -
Enabling this option from Tools>User Preferences screen will skip the printer selection screen. You can link the number of labels value to an entry box on your Data Entry Form if necessary and also make add a selection box on there that is linked to which printer to use etc.
For the record selector, you could adjust the filter from Equals to Contains potentially. Probably adjusting the More Options settings for the Filter/Query Prompt would be the better option though, such as adding a prefix of PM onto the entered value, setting the minimum number of entered characters to 4 padding zeroes to the the left if less and perhaps making the maximum 4 too and setting the entry to be numeric only
0 -
Hi Peter,
Thank you so much. This is working great now.
Thanks again,
Jamie
0
请先登录再写评论。
评论
8 条评论