How to add quantity without create new row on spreadsheet

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.

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,

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

2 Likes

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

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)

hi sir, i decided to sort of change the concept, so i split the add and update blocks, the add blocks is fine, but on update blocks, i sort of do a simple test, where i use the get block from the data source and set a label to changer to whatever the value the being get from the spreadsheet is, but on test, it does not change to anything, do you have any suggestion on how i can get data correctly from a spreadsheet? thank you.

Please show your new blocks of code.

https://x.thunkable.com/copy/1aa55f10fccb625c287e6b7df7b5426a

here sir

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.thunkable.com/copy/d5b70394e8dda76db7ca118a0057c040


1 Like

thank you so much sir, it is beautifull

1 Like

You’re welcome. Let me know how it works out.

i want to make sure, how do create a pop up like when scanned?

Can you be more specific? Do you want only a new item to have a pop-up menu? If so, then use an if/else block that check to see if the item is new or if the item is not.

1 Like