Multi-Method Search

[Dominick_S]

I am trying to search by barcode, part name, and part number in a dropdown in a form.

I have a Parts Table with a Part ID key and a Part Name label. The barcodes and part numbers are appended to the end of all in the Part Names (labels). When I use the search-bar in the Part View via scanning a barcode, it scans the barcode and inserts the barcode number into the search-bar, this pulls up the Part key and label. Perfect, this is what I want.

I have an Inventory Table with the Part Name (label) as a ref variable to the Parts Table. When I use the scan feature in the Inventory Form --> Part Name dropdown, it simply returns "The scan result did not match any known entries" and does NOT put the barcode number in the search-bar. If I type the barcode in manually, the associated Part Name appears but it will not populate the field using the scanner.

What am I doing wrong? What can I do better? I am not the best at appsheet but any assistance would be helpful. I just want the barcode scanner to type the barcode number in for the user, wouldn't think that would be too difficult...

[WillowMobileSys]

Barcodes should be unique.  When scanning a barcode to lookup an Inventory item, you probably want the app to compare against ONLY the barcode column.  

I am not certain why you are having issues with your current implementation as I have never tried using the scanned barcode to compare against a Label column.  I'll try it and see what happens.

[Dominick_S]

The barcodes are unique but I cannot use them as the key/label because not all parts have UPC codes (not all items have barcodes). It is weird to me because it works in the view but not in the form. I think it might be a scanner problem... or like an exact match problem... like in form drop-down list search-bar it only accepts exact matches (which it never finds because the barcode is only part of the name) while in the view search-bar it accepts non-exacts and just shows the related parts to the non-exact match (of which there is only one)... I really don't know but at this point I would welcome even a workaround otherwise users will have to key in barcodes manually (aka everyone will hate me :P)