Barcode scanner - status update
Ninox Profile

I have table of ordered serial numbers with statuses, all statuses of these serial numbers are "Ordered". I would like to use barcode scanner to search and if match - change status of signe serial number to "DeliveredSlika zaslona 2019-08-13 u 22.29.14"

Ninox Profile

You could create a "Receive Order" table.. with a field for the Serial Number.   Then .. position the cursor within a row on that table and use the bar code scanner to scan the what was recived.  You will either have to tab off that field .. or click a button .. then have an Trigger After Update that searches your above table.. if it gets a match, it can set the status to Delivered.. 

I am not sure what you want to happen if it does not get a match.. perhaps an alert message. 

Reply