# How to add quantity without create new row on spreadsheet **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [February 15, 2024, 2:59pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533 "2024-02-15T14:59:39Z")\ **Posts on this page:** 15\ **Page:** 2
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [February 27, 2024, 2:55pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/21 "2024-02-27T14:55:08Z")
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. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/9/89acdb38373736418bfb738a4947dc728b2734f2.jpeg) ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [February 27, 2024, 3:14pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/22 "2024-02-27T15:14:16Z")
[https://x.thunkable.com/copy/2c6e68ed64d251c6c1c9f05c70199f47](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 ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [February 27, 2024, 3:31pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/23 "2024-02-27T15:31:02Z")
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](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/d/7d7795e19c9c742c4e4e61d661fcc24894793a83.png) ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [February 28, 2024, 4:36am UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/24 "2024-02-28T04:36:11Z")
it worked sir, thank you very much @tthompson41231 @tatiang , really appreciate it ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [February 28, 2024, 3:24pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/25 "2024-02-28T15:24:22Z")
[https://x.thunkable.com/copy/f7afdf7b695f610c29aac824c4c1cf97](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 ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [February 29, 2024, 3:43am UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/26 "2024-02-29T03:43:22Z")
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)](https://community.thunkable.com/t/debugging-in-thunkable-x-video/849471) ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [March 3, 2024, 1:59pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/27 "2024-03-03T13:59:08Z")
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. ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [March 3, 2024, 2:18pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/28 "2024-03-03T14:18:19Z")
Please show your new blocks of code. ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [March 3, 2024, 3:00pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/29 "2024-03-03T15:00:05Z")
[https://x.thunkable.com/copy/1aa55f10fccb625c287e6b7df7b5426a](https://x.thunkable.com/copy/1aa55f10fccb625c287e6b7df7b5426a) here sir ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [March 3, 2024, 5:49pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/30 "2024-03-03T17:49:16Z")
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](https://x.thunkable.com/copy/d5b70394e8dda76db7ca118a0057c040) ![thumbnail_IMG_2011](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/5/c5a58937c6fbe3baf47f848b80391d660bfa9636.png) ![thumbnail_IMG_2013](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6392c3e85d48a5abb77e9a3cb345616738a7433.png) ![thumbnail_IMG_2012](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/e/5e771601bc9fe7fa9bbf419e53677af83d05e73d.png) ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [March 4, 2024, 8:12am UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/31 "2024-03-04T08:12:22Z")
thank you so much sir, it is beautifull ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [March 4, 2024, 1:19pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/32 "2024-03-04T13:19:42Z")
You’re welcome. Let me know how it works out. ---
**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\ **Post date:** [March 10, 2024, 1:26pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/33 "2024-03-10T13:26:12Z")
i want to make sure, how do create a pop up like when scanned? ---
**Author:** ![tthompson41231](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tthompson41231/32/161401_2.png) [@tthompson41231](https://community.thunkable.com/u/tthompson41231)\ **Post date:** [March 10, 2024, 7:16pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/34 "2024-03-10T19:16:07Z")
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. ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [June 8, 2024, 7:16pm UTC](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533/35 "2024-06-08T19:16:49Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. [Previous page](https://community.thunkable.com/t/how-to-add-quantity-without-create-new-row-on-spreadsheet/2835533.md?page=1)