Hi everyone. I have a row for scanned items, the barcode is basically the order number and I want to prevent the wrong item being scanned.
I have put into place a ValidIF
check between the ScanCode row and the OrderNumber row
I tested the expression and it is valid and works in the test sheet. However when I test via a mobile, I can actually scan a completely different number and it seems to accept it.
I would like to ask, is there a way I can prevent the wrong item being scanned? A visual or audible warning and not allow the user to save until the right item is scanned?
Many thanks JIM