I have been running my app on the basic plan for a year and a half.
Since 9/12, the data is no longer reflected in the spreadsheet, even though the spreadsheet has the data.
And every day since then, without fail, the data suddenly appears after 9:00.
The data source is Google SpreadSheet and the filter is set to show only the data of the day.(DATE is within today.)
Since we are using this service in Japan, it is probably because the time zone is UTC to determine if it is today or not.
Is there somewhere I can set the time zone for the application?
Or is there a way to have it determine if it is today in JST?
The result is not changed.
If the problem is due to the time zone, the previous day’s data should be displayed until 9:00, but nothing is displayed after 0:00.
Therefore, we assume that this is not a time zone issue, but rather that a process was incorporated around September 12 that does not reflect today’s data until 9:00.
I don’t know if you’ve seen this post I’ve attached below, but it sounds like it’s the same issue. If you read through it, @Darren_Murphy provided an alternative solution that should take care of your issue as well. It does seem like you have run into a bug that’s dependent on your timezone, so feel free to report that to Glide support if you want, but the Darren’s solution should work just as well for you.