so i am trying to create a scanner like what every store have, so when i scan a barcode the series number is added to the spreadsheet row, but i don’t want to every time i scan, it creates a new row, rather i just want to add the quantity, what model of blocks should i build? thank you

I added a few things for you to get started. Right swipe to update an entry. Left swipe to delete. When a new item is found a menu will open to input the product information. Change the data viewer table to yours and update the code to your tables paying attention to the columns, https://x.thun…

It might be, depending on the country.

@tatiang Interesting, I never knew that. That might be his problem though. Thunkable might see that as a string.

is it because you set it on list? so it returned on list

Try this. In this version of your app, when the screen opens it sets a variable to a list of all the products on your google sheet. When you scan a new product, it will save it to your google sheet and also the local list variable. This will help speed up the scanning process as well. Edit: You …

[image] still stuck on 2,00 on spreadsheet sir, i do not know why, but im still trying to figure it out

Can you see if Google sheets is treating that as a number or a string? Try adding those two numbers within your sheets using a formula. if it’s not get rid of that comma and put a decimal. This is what happens when I do it, but like @tatiang said I don’t know what country this format is in. [ima…

https://x.thunkable.com/copy/2c6e68ed64d251c6c1c9f05c70199f47 i have fixed the format number sir, it is able to add quantity, but still can not more than 2, so confused where i get the blocks wrong, and i am from indonesia

I just tested your project and it works for me. Try to sync your table again. Try testing it with a local table and not a google sheet. If the local table works, try creating a new google sheet, remove the old one, and refresh your browser, [Screenshot 2024-02-27 102736]

it worked sir, thank you very much @tthompson41231 @tatiang , really appreciate it

https://x.thunkable.com/copy/f7afdf7b695f610c29aac824c4c1cf97 i am sorry sir, just want to check out on another device, last night it worked, it can increase more than 2 quantity, but now it is stuck again on 2, i have no idea what happen, is thunkable error, or blocks error, thank you

How to add quantity without create new row on spreadsheet

Questions about Thunkable X

tthompson41231 February 29, 2024, 3:43am 26

Everything looks ok. I’m not sure what’s happening on your end. You’ll have to debug it to find out what the problem is. @tatiang created a post a while back on this. Debugging in Thunkable X (Video)

Topic		Replies	Views
[Solved] how can I decrement an inventory item stored in google sheets using a barcode scan? Questions about Thunkable X solved , beginner , help	33	2367	July 14, 2022
Stuck getting NaN trying to add numbers in a column Questions about Thunkable X	1	38	August 21, 2025
Update all rows value for one column Questions about Thunkable X beginner	5	594	October 2, 2021
Creating row in spreadsheet Issues / Bugs	5	235	June 13, 2023
Sample Google Sheet project? Questions about Thunkable X google , spreadsheets	11	1034	September 13, 2020

How to add quantity without create new row on spreadsheet

Related topics