I am working on a warehouse picking app for multiple pickers. Each picker can see what orders are not picked and select it for picking. The key challenge after testing the prototype in the field is synchronising of what is being picked vs what has been picked. This is because picker needs to make sure that the syncing is done every time which order is not picked yet. If I put a status change tag when an order is being picked, it adds to the sync time.
Once way of overcoming the sync issue is to allocate orders to different pickers, but this is not a flexible approach as some orders may take a short time to be picked, and it takes time to allocate orders too.
Another way that I can think of to make the order pick status dynamic is to use formulas to hide or lock some fields.
Any other ideas and methods to achieve the outcome is much appreciated