So basically I have a set of data in google sheets ! These are order data, I want to be able to scan the order no (Barcoded) and update the different stages of the work flow.
For instance -
Ordering Team - scans the bard code for their login once the order is placed and the pre filled data would update the field on scanning
Materials receiving team - once the materials are recd they scan from their logins and pre filled data is updated against that order.
The challenge I am facing now is that when I can scan the order no (which is the key data) it says key is already added, I tried removing the adding option and retaining only the updates if I do that the order no key field does not appear