[Solved] how can I decrement an inventory item stored in google sheets using a barcode scan?

Here’s how I would do it:

https://x.thunkable.com/copy/7ab2ea98368729c65812ac6ed0169760

(See the first screen which has your username on it.)

There used to be a bug with the Get Value block in Thunkable. I don’t know if it has been fixed yet. I noticed that when the inventory value is 1, it doesn’t subtract 1 the next time you click the Scan button.

2 Likes

do I need to give any value to the “scanned barcode” part and the part below it, or can I make a reduction if I make the parts here directly to my code page and get the amount of inventory that matches the barcode directly @tatiang

i have tried the codes, but what I want to do is how to give the number of the scanned barcode to line a, which should appear in front of the user, when he scans, the user will add the barcode by scanning it himself, if I do it according to the list, this will not happen, so I’m wondering if I can do something to scan the data, so the user added 100 products for example, when he entered here, when he clicked the scan button, I want the number of stocks to come according to the barcode he scanned, how should I make changes here (i.e. should I do something to find the row id itself to pull it by the barcode number
@tatiang

The project I provided is just a starting point. You should be using variables to store things like scanned barcodes. So yes, you need to replace the sample value I provided with one from the user.

You can look up the inventory value for a specific barcode by looping through the rows of the table (as I showed in the project and if the barcodes match, then display that inventory amount. I think that’s what you are asking. The project already does this, by the way.

3 Likes

many thanks for your help

@tatiang
finally, when I update the number of stocks, the number of stocks remains the number of stocks that came first, even if I go out and enter it comes as the number of stocks that came first, when I press the “-” button, how do I update it, how do I show the number of stocks that have been replenished

i have updated the code structure as follows :

when I update the number of stocks I get from the barcode, it doesn’t update the information I get below

code structure :

1 Like

There is an error with the get value that it uses cache data and therefore does not show updated values in the table.

You will notice that if you exit the app and start it again you will see the values you updated

If you can see this then it means the get value error is not resolved yet.

1 Like

Yes, the inventory amount is updated when I log out through the application is there any chance to update it without logging out of the application? @muneer

1 Like

Use get row block instead of get value` to see the updated information in the required column.

1 Like

i don’t understand how to use it, I’m sorry if you can give any examples

it would be better if there is a visual example

1 Like

In my table (test) I want to show the number saved in column CodeValue in the selected row, this is how it is done using get row block

3 Likes

thanks for your help, thank you very much

1 Like

Hey muneer,
I’m experiencing the same problem with the get value block. It’s not updating until I close the app. Unfortunately, I’m having the same problem with the get row object block.

Any idea what could cause this?