This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi, as part of a work order app we are using barcode scanning to pull parts to add to a work order. We are using code 39 barcodes. In the app, we have a service ticket table with a parts used column thatโs referencing a parts spreadsheet. Iโve set all pertinent columns to be scannable and Iโve set the โproduct barcodeโ column in the parts sheet as the key column. Iโve verified the output of the barcode is correctly entered into each spreadsheet row using a standalone barcode scanner to output directly to the spreadsheet cell. Once everything is updated, the mobile phone scanner spits out โThe scan result didnโt match any known entries.โ Any ideas? Thanks in advance for the assistance!
Hi Aleksi, I canโt figure this out! Iโll tell you how I have it structured. I have a Service Tickets table with a Parts Used column. Itโs a ref column that references a Parts table. Itโs set to scannable. The Parts table has a Product Barcode text column that is the key column. This references my Google Sheet where the product barcode text output is stored. No matter what I do, I canโt get the app on my phone to recognize the barcode as being connected to data in the app. If it matters, Iโm in prototype mode right now. Any directions you could give would be very much appreciated!
Hi Aleksi, definitely. Account ID is 831877, app name is Gate service, tables are Service Tickets with columns First part used, Second part used and Third part used and Parts with column Product Barcode. Thanks in advance!
Hi @Aleksi, definitely. Account ID is 831877, app name is Gate service, tables are Service Tickets with columns First part used, Second part used and Third part used and Parts with column Product Barcode. Thanks in advance!
Hi @Aleksi, 00 ABC-1234 is a barcode value tied to part number MA-1031.0321 for test purposes. Code 39 format. If I use a handheld barcode reader, the value 00 ABC-1234 is what is output to the spreadsheet. Iโve tried to type in by hand as well but no change.
Hi @Wallace_Service and sorry about the delay. Are you able to add some records that are assiged to my email address so the security filter wonโt filter all data away. Please use aleksi@appsheet.com
Hi @Aleksi, no worries at all. Iโve added a couple of records for you. Iโve put in 3 parts with confirmed barcode values that work fine with an external barcode scanner. Iโve set the Parts table with Product Barcode as the Key so youโll only see the 3 I set up.
Hi @Aleksi, good news, got this figured out! I built a simple test app separate from my service ticket app. Turns out the barcode scanner I am using is outputting slightly different than the app scanner. Not totally sure why but good enough to get the problem fixed. Thanks again for the help and guidance with this one!
LinkedIn
Twitter
