Google sheet not updating

[sketch]

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

[tatiang]

Please provide screenshots of your blocks and of the effect your are describing. We can’t easily guess about what’s causing it…

[sketch]

When i click the button it updates the sheet but in the app it stays the same value it was before clicking the button

[tatiang]

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”?

[muneer]

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.

[tatiang]

Has this been filed on Github?

[muneer]

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

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

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 …

[sketch]

Thanks @muneer that works.
However it’s really slow.

[muneer]

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.

[sketch]

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)

[carlinmclellan]

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

[muneer]

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.

[carlinmclellan]

Thanks muneer, that did the trick.

I updated the code to this to fix the problem.

[cresto.pgaxq2]

It appears this issue is back. Do you have a visual for using the objects in get row block