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...
LinkedIn
Twitter
