The events in my app aren’t visible on a Chromebook and haven’t been since September. I’ve cleared cookies/cache, etc to no avail. Nowhere else is this an issue.
Thoughts?
Is this an older Chromebook? If so, it’s a very low-probability issue, but it could be that the Chrome Browser version is too old, which might prevent certain features from working.
Are you doing something weird with dates other than using a standard date type columns? Are you using format date or text to date or some other logic to build dates? If so, it’s possible that the Chromebook is formatting dates differently compared to other devices, which can break some of those other columns that are expecting dates in a certain format.
2 Likes
No. The calendar events were working fine and then just stopped being visible. I didn’t change anything. The components work on every other device, just not chromebooks.
I tried changing the component to cards instead of calendar entries. I left if to show if the dates are within today. It shows on a Viewsonic, on every other computer and phone, just not the Chromebooks. Why would it work and then stop a month later?
I’m a teacher who teaches my entire class through this app. It’s my everything. I await your legendary expertise.
Can you show the configuration for the calendar component? Also show the date columns in the table.
All of this is in Glide tables.
This is the calendar sheet.
This table checks the day and matches it with the corresponding date.
This is how it appears on every device except for a Chromebook. I just wanted it to show the date, not times. Is that the issue? If so, what do I do next?
It’s the same issue with the calendar on a Chromebook. This is what shows everywhere else but on the Chromebooks. On those, the calendar appears blank.
.
Can you show the column that the lookup is referring to? I’m trying to get to the root to confirm that the ultimate source of those dates are a legitimate date columns and not something else.
I remember some hacks I did several years ago where I could trick Glide into treating a template column as a date, but it wasn’t truly a date value and I ran into some odd limitations with what I was trying to do. When you set your replacement value as ‘DATE’ in the math column, it will default to something like ‘current date and time’ and the formatting for the math column to date formatting–but in some cases, if you then change the column to something else, it might still hold on to the date formatting options even if the source column is not a date column. Point being, I want to know the source of that date to confirm whether it really is a date or text that looks like a date.
1 Like
It’s got to be something with the formatting in the math column. I agree. Here’s what I have. If it helps, I copied the dates from an external spreadsheet and pasted into the table.
Ok, there we go. As soon as you did a Floor on the date, it became a number (days since dec 3th 1899) instead of a date. Even though everything looks correct in the data editor and it appeared to be converting it to a date, it wasn’t a date. I wouldn’t be surprised if some devices calculate and interpret that differently, leading to your issue only with chromebooks.
So I’m guessing your ultimate goal is to truncate hours/minutes/second from the date to get a date/time at midnight? There are some common tricks such as subtracting hours, minutes, and seconds individually from the date which works well, but doesn’t eliminate milliseconds. For the most part, that is not an issue for anyone, but it bothers me a little bit that it isn’t truly midnight. There are a handful of other tricks to isolate the time decimal and subtract it from the date, but it starts to require two or more math columns instead of one.
You were on the right track, but it obviously is not foolproof. The math column also seems to be a little aggressive with its formula validation which gets frustrating when you know it should be a valid formula. I would love to see a couple of minor things changed with the math column to make it function better with date math.
I’ve tried to solve this puzzle in a more graceful matter in the past, but always settled for some other solution. I took another crack at it today and came up with the following. I tested it using NOW for the date (which changes every 10 seconds), and the only issue I ran into initially was some sort of rounding or a floating point issue in the math. It would calculate to 12:00:00am midnight but occasionally float to 11:59:59 of the previous day. Not good when date must be accurate. With a small tweak I think I have the floating between days issue worked out, but be sure to test it thoroughly. I think this might be a lot more stable with static dates as opposed to NOW, which is constantly changing and may have time into the sub millisecond range.
date-(ABS(date)-TRUNC(date)-0.0000000001)
The result of this math will be a true date which hopefully works better for you on the chromebooks. It may not be a true midnight time, but at most it’s a small millisecond fraction after midnight. Just be sure to watch if the date happens to float to the previous day. I didn’t think it will, but something to be in the lookout for.
If it still doesn’t work as expected, we can try a different approach.
4 Likes
This looks incredibly useful. @nathanaelb can you add to your list please?
5 Likes
I cannot begin to thank you enough for this. I’m so incredibly appreciative for the time you put into finding a solution. I’ll get on this right away.
2 Likes
I realized I used the date(FLOOR) a couple of times and replace that formula with the one you suggested. Same issue remains. I can see the data everywhere but on the Chromebooks.
I don’t know how to use the text→date feature, but would that be of any use?
Thank you, again, for trying to solve this. It really is a can for my students at present. I can project the plans in class, but desperately need them to have access on their individial Chromebooks. That’s where they get their daily assignments. I love this service so much better than the other options I have for my students.
I’ve been using Glide since 2020 and cannot sing its praises enough.
I just need them to see the information for each day. I await your next wave of inspiration.
–>It really is a major issue for my students at present.
It didn’t work.
But…it only takes one time to invent a lightbulb. The rest are learning opportunities.
Can you access the builder from one of those Chromebooks? If yes, can you do so, go to the data view and double click on one of those math fields to see what the underlying value is?