Describe the bug:
I’m working with the time zone UTC+7, and I realize something weird with the filter or visibility when I’m using a date as a condition.
when I’m using the condition “within today”, data will appear at 7 AM my time (that indicates the condition date using UTC).
in my case, this is a problem because “today” data should appear with my timezone because my user sometimes starts accessing my app at 5 AM
so when the user access at 5 AM, data shows data from yesterday or blank.
Expected behavior:
I’m expected the condition date to work with the user’s time zone
How to replicate:
you need to use a different time zone to replicate the situation
using condition date
Link to demo recording:
I’ll update the link later, I need to wait until 12 AM my time to report this bug
Yes, that specific checkbox feature is only for glide tables.
OK. I was curious because the person in that other thread had an underlying time in one of his examples that was 9am, but he also was in a timezone 9 hours from GMT. I haven’t byet got a response from them if all of their dates have a 9am time, but based on what you found, maybe that’s not the issue and instead it’s in fact the timezone.
I’d be curious if you find anything in your experimentation.
It almost seems to be timezone related, and maybe it’s a bug introduced when glide added the 'Respect timezone option. @SantiagoPerez, this may be something to look into.
because i can’t sync data automatically from google sheet and Glide Table,
So for a solution, i add another column in my google sheet with the name “Show” with this formula =ARRAYFORMULA(if(A2:A=“”,“”,if(C2:C>=today(),C2:C-today(),“”)))
A2:A is for column ID
C2:C is for the column containing the date
and i change the filter or visibility condition on Glide:
if i want to show today only i’ll set “Show” equals “0”
if i want to show data today and after today, i’ll set “show” is greater or equal to “0”
please make sure Google sheet time zone same as your timezone
i’ll be back tomorrow to give the result of my experiment