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.
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.
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