I just wanted to add this here for anyone who might find it useful. Google released a new Calendar entry shortcut that I was able to use as a button action to open up a user’s Google Calendar and let them immediately add an entry. Right now it opens the desktop version of calendar entry in the mobile browser, so it’s not ideal from a UX/UI perspective, but it’s quick!
I added a Calendar URL column in a sheet and pointed it to “cal.new”. Then I added a button with an ‘Open Link’ action that uses that URL column.
@BigMac Same here, I also tried to set the format this way: `2016-05-26T15:00:00-00:00 (with static time offset) but 1 hour is added by default… anybody has found a solution? Very cool feature btw
Sorry, my post may have been misleading. By zulu, I meant the ISO format. Back in the day, Glide really struggled with different date formats, so I believe they introduced the underlying ISO format to be more globally recognized and properly convert to the user’s region format. With the exception of the log sheets, which I believe are possibly zulu/gmt (probably server) time, all dates and times are stored as local time to the user since that is being calculated on the user’s device.
The only solution I can think of is to get the user’s local time zone and do the math to store it as a true zulu/gmt time.
Ya, that’s what I was afraid of…Glide has made huge strides in figuring out date/time issues across timezones etc, but scenarios like this (automations/webhooks that use the timezones) still occur.
I also noticed issues when sorting by timestamp. If somebody half the World away is writing to the same log as I am, sorting is off.
Thanks for thinking of a solution! The issue I’m facing is that the 5 you’re referring to is different for everyone using the app based on where they’re at in the world.
Ultimately yes. The tricky thing is daylight savings time. Probably doable with an if then else column. Thinking maybe a drop down on the user profile sheet. If then else to check what the date is determined if it’s a -5 or -4 for example. And then only allow the add to calendar button if that information is filled out in the profile.
mmm, Glide Tables are great, but the problem is you continually run into dead ends when it comes to integrating with external services.
I wouldn’t mind betting that there would be an API out there somewhere that would return a current GMT offset given a set of co-ordinates. But even if there is, it won’t help you as there would be no way to get that data back into your Glide Table
Still want an upgrade over this workaround, but you can copy them all into a Sheet, have a “Moved?” boolean column.
Then show them as an inline list in the app, filter by Moved is not true, have a custom action to add row to the Glide Table and set the Moved column to true. I have been doing this recently.