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.
Please provide screenshots of your blocks and of the effect your are describing. We can’t easily guess about what’s causing it…
When i click the button it updates the sheet but in the app it stays the same value it was before clicking the button
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”?
There is a bug with the
get value block. It will get the value only once and then will read from cache.
get row block instead and you will see the updated values.
Has this been filed on Github?
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
This is a long standing issue but see my comments in the last few posts
Thanks @muneer that works.
However it’s really slow.
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.
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)