I have a PDF fillable form and I want to use a barcode scanner to bring data into the form.
I have barcode number 001 attached to an item with a serial number of 123456, but when I scan the barcode it inserts the barcode number (001) as you would expect it to do.
I have created an excel spreadsheet with barcode 001 in a table linked to serial number 123456, but cannot work out how to create an equivelant PDF (VLOOKUP) function which, when I scan barcode 001, it pulls the serial 123456 into the PDF fillable form.
Can anyone be of assistance?
Hope you are doing well and sorry for the trouble. As described you want to to create an equivelant PDF (VLOOKUP) function which, when I scan barcode 001, it pulls the serial 123456 into the PDF fillable form.
Hope this information will help
I don't think that this option will work. I know I have only mentioned 1 barcode. but my spreadsheet containes over 100 barcodes linked to a number of different serial numbers.
So the lookup function would need to be from Excel to Adobe for any of the assigned barcodes I have on my spreadsheet.
The latter option is better because it allows you to update the list more easily, and you could even open that file (CSV or tab-delimited) directly in Excel. It's not possible to use an XLS(X) file directly, though.
I can put it into a CSV without any issue. Any chance you could gelp with the script?
If you're interested I could write the full script for you, for a small fee. You can contact me privately via [try6767 at gmail.com] to discuss it further.