Hi Gliders, I am creating an app that allows the users to edit the data in the app. The changes are reflected in the google sheets and it takes a while before the changes in the affected variables can be seen. Is there a way that I can add a countdown timer to a specific time for refreshing? This ensures that the user can pull the updated data on each refresh.
So you want a timer to show between the time when the user finished editing the data, and when the data finished syncing back to the app?
I’m not sure how well a timer could work (or how you could even make it work as the value has to come from somewhere, likely the sheet, and the update times are too slow) , however you could use another column to hold a validation function that only turns true once all submitted fields are populated with valid data. You could base the visibility of the components showing the newly entered data on this value.
If I am understanding your end goal.
Like Chris said above, I don’t think a timer would work as well. Might try the method Chris proposed and add in a “loading” image that would only be visible when it’s considered to be in a “calculation” period.