This topic is locked
[SOLVED]

 Using Barcode Input in field for lookup table

1/27/2014 2:07:02 PM
PHPRunner General questions
C
Christoper.Brand author

Greetings Everyone,
I'm trying out the lastest PHPrunner v7 build 19901. I have a lookup table that contains sales order details. Using the sales order number, I'd like to be able to scan the barcode on a printed copy of the sales order and have it autofill in the relevant information into several other fields on the form. I can setup the lookup field and autofill the other fields with no problem. If I manually type in the order number, it does the lookup perfectly after I type in the last number of the sales order, but the problem I'm having is when I use the barcode scanner to enter the sales order number, it doesn't trigger the lookup, it just enters the sales number in the field. The barcode scanner (in this case a Unitech MS830) normally sends a carriage return after, but I've programmed it not to. I've searched thru the forums, but haven't found anything similar to this.
I'm sure there is something easy I'm overlooking, as this should be something simple to accomplish <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=21910&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' /> . Has anyone used a barcode scanner for inputting data for a lookup field? I'd appreciate any help on this.
Thank you kindly,

Chris

C
Christoper.Brand author 1/31/2014



Greetings Everyone,
I'm trying out the lastest PHPrunner v7 build 19901. I have a lookup table that contains sales order details. Using the sales order number, I'd like to be able to scan the barcode on a printed copy of the sales order and have it autofill in the relevant information into several other fields on the form. I can setup the lookup field and autofill the other fields with no problem. If I manually type in the order number, it does the lookup perfectly after I type in the last number of the sales order, but the problem I'm having is when I use the barcode scanner to enter the sales order number, it doesn't trigger the lookup, it just enters the sales number in the field. The barcode scanner (in this case a Unitech MS830) normally sends a carriage return after, but I've programmed it not to. I've searched thru the forums, but haven't found anything similar to this.
I'm sure there is something easy I'm overlooking, as this should be something simple to accomplish <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=73881&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> . Has anyone used a barcode scanner for inputting data for a lookup field? I'd appreciate any help on this.
Thank you kindly,

Chris


Greetings All,
I've figured this out. I had to program the barcode scanner to disable the Terminator. Normally it sends a "Enter" after the barcode, I've set it to "None" and the lookup field works as expected now. I wanted to post the solution in case anyone else out there had the same problem.
Thanks!

Chris