I am working on an application that uses google spreadsheet as a data source.
When I press a certain button, I am trying to add +1 to the value of a particular cell.
I constructed the app to get the value of the cell, assign it to a variable, and update the cell with the value of the variable.
It seemed to work well, but when I start the app, the update to a single cell is done only once.
If I relaunch the app, I can perform +1 to a single cell only once.
The block is designed to get the contents of the data source cell every time the button is pressed, but even if the +1 is executed once to update the data source cell, the next time the button is processed, it does not seem to read the value that was +1 in the previous operation.
In other words, it seems to always adopt the content of the data source that was read at app startup.
To solve this, I think I need a command that will reload the data source into the app.
Is there a solution?