Google sheet not updating

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

2 Likes

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

1 Like

Screenshot_20211103-180506_Chrome
Screenshot_20211103-180447_Chrome
When i click the button it updates the sheet but in the app it stays the same value it was before clicking the button

1 Like

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

2 Likes

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.

3 Likes

Has this been filed on Github?

2 Likes

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

@tatiang
This is a long standing issue but see my comments in the last few posts

2 Likes

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

1 Like

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.
1 Like

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)

1 Like