Update Data in Googlesheet

[Thomas1]

Hi everybody,

I have created a barcode scanning app.
Everytime a barcode is recognized it shows information such as a location or a check date.(In the app)
This information can be updated by a user. In case there are changes, it should change the fields in the googlesheet.
What currently happens is that there is just a new row in the googlesheet with the info provided by the user and a row with the old info.

So what i would like to have:
If the Barcode is recognized, the row of the Barcode (in Googlesheet) should be edited/updated by the info the user provided.

Can someone help on this?

Best,

Thomas

[TyAlevizos]

Hello,

I believe that this will help your situation, yes? Please let us know if not.

Edit instead of insert for existing key Tips & Tricks 💡

I have an app where the user scans a barcode and then enters some inventory information about it. They do inventory once a day. Thus, if the inventory was already recorded, there’s no point doing the inventory again. So is this behavior possible? User scans barcode If barcode exists, retrieve and edit the current record If barcode does not exist, present an empty form for new values Thank you for you time, Doug