We maintain our organisation wide calendar through glideapps. It would be really nice if a certain event could be added to the user’s calendar. Sort of a ics file. This feature could be added as an ‘action’ in the dropdown.

This looks to be the format for dates that’s needed. Glide does store the zulu date behind the scenes when using a date time picker. You just need to make sure the date in the column looks like that. 2016-05-26T15:00:00-04:00 (with static time offset); or 2016-05-26T15:00:00Z (in UTC, a.k.a. Zulu time)

This method helped me: [image] Convert Date and Time to Zulu Ask for Help Is there a math formula I can enter into a math column to convert a standard date and time column into Zulu date and time? Thanks!

[image] Jeff_Hager: Glide does store the zulu date behind the scenes when using a date time picker. Continuing this conversation because I really want this to work:

You can use my notifications script to do this without using a 3rd party and append the necessary info to allow it to be added to google calendars. [image] Free push notifications Workaround Community Resources I have a solution for PUSH NOTIFICATIONS. It works with IOS and ANDROID. It is quick and has ZERO cost to everyone. You can do this in your google sheet or a separate sheet that is linked to your original (I used 4 linked sheets, I’ll explain later). 1st you setup on your sheet a variable or value you are wanting to trigger the notification. This data will need a VLOOKUP formula to link to the person you want notified’s phone number and phone carrier, so when the vlaue on the sheet is found usin…

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.

[image] Jeff_Hager: 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.

[image] Jeff_Hager: 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. Indeed. [image] Convert Date and Time to Zulu Ask for Help US East is GMT -4 So you should just be able to do ‘date + 4/24’ PS. I’m on my phone right now, so I haven’t tested that. But I think it should be right. I’m sure Jeff will correct me if it’s not wink

Epale @Robert_Petitto I am sure you already thought about this but here it goes.

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.

Isn’t the solution just to collect the users timezone offset when they sign up, and store that in their user profile?

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.

Add to Calendar

Feature Requests

Darren_Murphy April 26, 2021, 3:49pm 27

Indeed.

Topic		Replies	Views
Make a google calendar Event when the user click buttom Ask for Help actions	23	2450	December 5, 2022
Calendar reminder Ask for Help	26	1163	March 2, 2023
Add to calendar with multiple options Ask for Help	18	1103	May 15, 2023
Hello, and, On Extending Glide with Google Apps Script Ask for Help	36	5228	February 27, 2022
Send google calendar invites Ask for Help	20	2982	February 26, 2022

Add to Calendar

Related topics