How to send a Quantity parameter
As already explained in the Keyboard emulation article, Barcode to PC is able to type the barcodes for you, but in addition to that, there is the opportunity to send a Quantity parameter along with the scanned barcodes.
For example, in the video you can see an example where it is able to type the scan date/time, the barcode, and the quantity:
Every time that you scan a barcode the app will also ask you to insert a “quantity” value, that will be sent to the server along with the barcode.
To enable the Quantity parameter:
- Open the server Settings by clicking on the gear icon
- Drag and drop a TAB component from the Available components field to the Output template field (it is used to move the focus forward)
- Drag and drop a NUMBER component from the Available components field to the Output template field
- Click Save & Apply
Like this:
Note: the order matters! Barcode to PC server will type the components in the exact same order in which you put them in the Output template field.
That’s it! Now you should be able to scan and send the quantity parameter.
Bonus tip 1: you can change the type of keyboard that pops out when you have to insert the quantity from numeric to alphanumeric by using the TEXT component instead.
Bonus tip 2: you may also need to type the quantity parameter inside a field that is located farther away from the barcode field, so in order to move the cursor inside it, a single TAB may not be enough.
To fix that you can use multiple TAB components to move the focus of the UI elements of your software.
Thanks for this nice tool. I have one more question. Can we use more than one barcode in the same form? For example one Code_128 for the part number and one QR code for the storage location?
Yes, the app by default scans any barcode format. However to improve the scan speeds you should disable the formats that you do not use from the app settings.
Thanks, but how can we move from one order (group of items, barcode numbers) to another ? thanks
Can you please describe better your issue at [email protected] and send some screenshot?
The tool looks nice and stabile.
But we have a specific need:
We need to start with scanning or typing an ID, then scan a number of barcodes and each time send the combination of the ID and the barcode.
Is it possible to do this with your tool?
Yes, you should be able to do that using this Output template:
Hi Fillippo,
Is there any way to change the default quantity to zero?
No, at the moment it’s not possible, but since it may be a useful feature it’ll be added with the next updatesNow it’s possible. Just click the NUMBER component to set it.
Your method of describing everything in this paragraph is in fact fastidious, all be capable of without difficulty understand it,
Thanks a lot.
How can I load the scanned barcodes and quantities into a file on the PC — e,g, a spreadsheet? I need to update quantities for each barcode on the PC.
See this: https://barcodetopc.com/csv-files/3-ways-to-save-scans-to-csv-files/
and this: https://barcodetopc.com/csv-files/how-to-import-csv-files-to-excel/
Another solution could be to create two Output templates to keep track of the in/out of the inventory and compute the quantity later in Excel.
In my application I need the pc to do a quick lookup based on the barcode just scanned and send a yes/no feedback to the cell phone scanner before the next scan. The lookup table is a dual list of two elements, the scanned code and a corresponding value. If a match, the feedback is “yes”, otherwise “no”, this could be a feedback sound such as a beep. We are dividing the scanned items into two groups based on the feedback.
Is this possible with your application? If not, what would it take to add that functionality?
Yes, it could be done with both a visual and a sound alert using the ALERT and BEEP components respectively.
The Output template should look like this:
See the full tutorial here: https://barcodetopc.com/csv-files/how-to-send-a-feedback-sound-to-the-smartphone-based-on-the-csv_lookup-result/
Hi Filippo,
I am trying to get this app to output to a CVS file. Right now it outputs it in a Notepad.
What I would like it to do is Scan the order # (to name the file) then Scan the Product ID Column A then tab then scan however many serial # in Column B. Then a new product in Column A again and repeat the process. Is this doable?
any advice would be appreciated.
Thank you
You can do that by using two different Output templates for each column.
Items: https://barcodetopc.com/examples/Item.btpt
Serial number(s): https://barcodetopc.com/examples/Serial number(s).btpt
Download and double-click to import them.
To organize the output files with different names see this: https://youtu.be/LYN6KV3LiYo?t=174
Se puede poner en cantidad números negativos? Para que en el excel me figure negativos salidas y positivos ingresos.
Hello, yes it should work with negative values as well. But remember to select the Number format in the excel spreadsheet, as explained here: https://support.microsoft.com/office/available-number-formats-in-excel-0afe8f52-97db-41f1-b972-4b46e9f1e8d2
Se podría instalar en una Tablet el programa y el aplicativo? Para usar la tablet como lectora y tener el excel en la misma tablet?
Hello,
We are looking to use barecodetopc app for inventory. Actually, the quantity is part of the QR code. Is it possible to allow the warehouse employee to update the scanned quantity coming with the barcode ? how can we do this ?
Thank you for your help.
Yes, it can be done using the JAVASCRIPT_FUNCTION component, as explained here: How to extrapolate data from QR Codes.
Send over your QR code to [email protected] so that I’ll help you write the correct function.
Se puede leer de un archivo .csv el Product_ID, este desplegarlo en un cuadro de texto para poder ver el Product_ID, luego con la funcion PRESS KEY, pasar a leer el codigo de barra y que el archivo final me quede:
Product_ID, Barcode
ejemplo
Product_ID , Barcode
40221R1 , 4005900036711
La problematica es que tengo el product_Id y necesito asociarle el codigo de barra
Gracias.
Puede utilizar el componente CSV_LOOKUP para extraer datos de un archivo .csv y luego mostrarlos usando el componente ALERT. Sin embargo, todavía no entiendo completamente su pregunta sobre el componente PRESS_KEY. Me pondré en contacto con usted por correo electrónico para obtener más detalles y poder ayudarle de manera más efectiva. Gracias