September 21, 201411 yr Hello All, I'm using Filemaker 13 Advanced and have a solution in which we use a barcode scanner on a laptop running window 7. The barcode scanner is wireless and we are checking in products that have a model number (field 1) and serial number (field 2) into our database. The person checking the products, scans the model number, then has to go back to the computer and tab to the serial number, scan the serial number, and then go back to the computer and go to the next field. I'm looking for a way that when the first barcode is scanned, filemaker just automatically goes to the next field. So the person barcode scanning does not have to keep going back to the computer to tab to the next field. Suggestions?
September 21, 201411 yr You need to program the scanner to signal the end of scanning by outputting a known character. A tab would be (obviously) best, but any character would do (use an OnObjectKeystroke script trigger to react to it). If you're unable to program the scanner, consider scanning a pre-printed barcode label at the end of each "real" scan. There's a third option, but it can work only if all your barcodes have exactly the same number of characters.
September 22, 201411 yr Author Hello and Thank You! Our barcode scanner does not have programming functionality and the barcodes we scan are different sequences of numbers and letters at various number of characters. It does automatically go to a new paragraph at the end of the scan, or working with excel spreadsheets will go to the next cell. Does that help?
September 22, 201411 yr It does automatically go to a new paragraph at the end of the scan, or working with excel spreadsheets will go to the next cell. Does that help? Oh yes, it does. That means it outputs a return at the end of the scan. So all you need to do is go to Layout mode and set the two fields to "Go to next object using: [x] Return (in Inspector > Data > Behavior).
September 23, 201411 yr Author Oh yes, it does. That means it outputs a return at the end of the scan. So all you need to do is go to Layout mode and set the two fields to "Go to next object using: [x] Return (in Inspector > Data > Behavior). That did it! Works like a Charm! Thank You!
Create an account or sign in to comment