# Google sheet not updating **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 3, 2021, 3:47pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769 "2021-11-03T15:47:33Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [November 3, 2021, 3:47pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/1 "2021-11-03T15:47:33Z")
Hi all. I am using google sheets in My project. However whenever i update a value e.g. dark mode: On/Off the value does not update and the screen stays in dark/light mode depending on the users setting. How do i solve this? P.s. When refreshing the app it does update. Thanks ---
**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:** [November 3, 2021, 4:59pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/2 "2021-11-03T16:59:43Z")
Please provide screenshots of your blocks and of the effect your are describing. We can’t easily guess about what’s causing it… ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [November 3, 2021, 5:06pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/3 "2021-11-03T17:06:08Z")
![Screenshot_20211103-180506_Chrome](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1e24343272d74ef7077e56480d222451f83c67d5.jpeg) ![Screenshot_20211103-180447_Chrome](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/7/e707f0220bdf3c0548b1ee16420f2319b49b115b.jpeg) When i click the button it updates the sheet but in the app it stays the same value it was before clicking the button ---
**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:** [November 3, 2021, 6:48pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/4 "2021-11-03T18:48:21Z")
It sounds like the problem you’re having is that you have an updated value in a Google Sheet but when you check a condition to see if the value = ONWAAR, it doesn’t return true. I would need to see more of your blocks to know how to help you. Can you simplify things and just check for an existing value in Google Sheet and see if you can get the condition to return true? I get that you’re trying to change to dark mode but dark mode has nothing to do with this problem. It’s just how you happen to be using the values in your project. It could just as easily be called “tomato”… what we care about is the Google Sheet value and whether or not it’s triggering your if/then condition. What happens if you do `if → get value from user data = ONWAAR → set label’s value to “TRUE”? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 3, 2021, 6:58pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/5 "2021-11-03T18:58:00Z")
There is a bug with the `get value` block. It will get the value only once and then will read from cache. Use the `get row` block instead and you will see the updated values. ---
**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:** [November 3, 2021, 7:35pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/6 "2021-11-03T19:35:30Z")
Has this been filed on Github? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 3, 2021, 7:37pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/7 "2021-11-03T19:37:53Z")
I don’t think so. It was reported by a member and @jane worked on it and fixed it at that time. I tested it myself. But for some reason it came back again. I noticed it because this is the second issue raised these couple of weeks for the same **update** issue. See this post > [@Data Sources: List Of Values from \[Column\] block does not update during app runtime](https://community.thunkable.com/t/data-sources-list-of-values-from-column-block-does-not-update-during-app-runtime/1257205): > > I am been searching around but not found best solution. i am using data source and it connect to airtable. after do operation such as edit, update or delete and it reflected to airtable but not in apps it self. it remain like keeping cache for it. i have to exit from app and login again and then only reflected. any way to reload data sources or refresh the screen? my component is using list viewer, text and label. @tatiang This is a long standing issue but see my comments in the last few posts > [@Data Viewer List - Incomplete list shown](https://community.thunkable.com/t/data-viewer-list-incomplete-list-shown/985897): > > Hello all, I have some strange happenings in one of my apps that utilizes both the Data Viewer List and Listviewer. Until recently both have functioned properly, but now when the screen loads only the first 10 items show. Refreshing using the swipe down method will load a large blank area where the rest of the items should be. So far the only way I can find to show the missing items is to click on the last item (On click: I have a custom pop up that shows more item details). I have yet to be … ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [November 4, 2021, 2:12pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/8 "2021-11-04T14:12:59Z")
Thanks @muneer that works. However it’s really slow. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [November 4, 2021, 2:47pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/9 "2021-11-04T14:47:56Z")
That is odd. You can use `list of values ....` instead. I checked it and it works. It can see updated values. This will work of course in two cases: - You are updating one single column - The number of rows is not too much. ---
**Author:** ![sketch](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sketch/32/109058_2.png) [@sketch](https://community.thunkable.com/u/sketch)\ **Post date:** [November 4, 2021, 6:38pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/10 "2021-11-04T18:38:10Z")
Yeah may be caused by the update block. It only happens when switching themes in the settings screen, in other screens it just loads correctly. (unless it’s a image) ---
**Author:** ![carlinmclellan](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/carlinmclellan/32/77831_2.png) [@carlinmclellan](https://community.thunkable.com/u/carlinmclellan)\ **Post date:** [December 19, 2021, 7:54pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/11 "2021-12-19T19:54:43Z")
Hi I am using Thunkable to create an embedded WebApp. I have made two separate versions of the app (Desktop layout and Mobile layout). Both these are hosted on my Wix site. The Desktop version is updating Sheets as it should. However even though the mobile one has the same blocks, it is not updating the spreadsheet. I have deleted and reconnected the Datasource which hasn’t resolved the issue. Screenshot of blocks below. Cheers Carlin ![Screen Shot 2021-12-20 at 6.47.11 am](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/f/4f8b909c0024768045da89b326242a8a7dfca049.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [December 20, 2021, 7:51am UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/12 "2021-12-20T07:51:54Z")
The creation of the row would fail if one of the variables (inputs to the row) is **null** or the sheet is expecting a certain type for a column but you are feeding this column with a type other than **text** or the preset type. One way to test is to use the `create row` with only one variable and check the result then add the next variable to see which one is causing it to fail. ---
**Author:** ![carlinmclellan](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/carlinmclellan/32/77831_2.png) [@carlinmclellan](https://community.thunkable.com/u/carlinmclellan)\ **Post date:** [December 21, 2021, 3:54am UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/13 "2021-12-21T03:54:55Z")
Thanks muneer, that did the trick. I updated the code to this to fix the problem. ![Screen Shot 2021-12-21 at 2.54.14 pm.png](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/c/dc9ee7f3c9ef028222cb5dcc553b6082ec7d8917.png) ---
**Author:** ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)\ **Post date:** [January 6, 2024, 11:29pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/14 "2024-01-06T23:29:46Z")
It appears this issue is back. Do you have a visual for using the objects in get row block ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:14pm UTC](https://community.thunkable.com/t/google-sheet-not-updating/1595769/15 "2024-11-08T13:14:31Z")