# Google sheets update only once

**URL:** https://community.thunkable.com/t/google-sheets-update-only-once/2514829
**Category:** Questions about Thunkable X
**Created:** [July 21, 2023, 5:31pm UTC](https://community.thunkable.com/t/google-sheets-update-only-once/2514829 "2023-07-21T17:31:00Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![mail.uavsp13jk](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mail.uavsp13jk](https://community.thunkable.com/u/mail.uavsp13jk)
#### Post date: [July 21, 2023, 5:31pm UTC](https://community.thunkable.com/t/google-sheets-update-only-once/2514829/1 "2023-07-21T17:31:00Z")

</div>

Hi all, I have a simple program to update a cell in a google sheet by 1 for each time the submit button is clicked.  
The issue I have is that it works the first time I click submit but then does not work the next time I click submit.

I have set a variable for “CurrentCycles”  
when it is clicked Thunk gets the value from the google sheet and assigns the variable (works the first time) lets say it is “1”  
Then I change the variable by 1 and update the cell in the sheet (again works the first time no problem)  
I display it on my app so I can see what the variable is at the end of the code block, the app displays “2”  
The I click submit again and I would assume that it would check the sheet for the current number which is now “2” and add another to make it “3”  
However the program just maintains “1” in the variable and does not increment the google sheet. It also of course displays “1” in the message box on the app.

I am sure it’s something silly but I just can’t get it to work!!!

Any help appreciated

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/3/b3339053134bcdff5c3308d1241f1ae55109e1df.png)

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [July 21, 2023, 6:40pm UTC](https://community.thunkable.com/t/google-sheets-update-only-once/2514829/2 "2023-07-21T18:40:55Z")

</div>

There is a known issue with the “get value” block. See this: [Google Sheets data source doesn't update every time - #6 by matt\_conroy](https://community.thunkable.com/t/google-sheets-data-source-doesnt-update-every-time/2504230/6)

---

<div class="post-metadata">

### 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: [October 19, 2023, 6:41pm UTC](https://community.thunkable.com/t/google-sheets-update-only-once/2514829/3 "2023-10-19T18:41:48Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.