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

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 a…

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…

[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 (automation…

[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/2…

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 info…

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	24	2327	January 17, 2024
Calendar reminder Ask for Help	27	1077	January 17, 2024
Add to calendar with multiple options Ask for Help	19	1004	May 21, 2023
Hello, and, On Extending Glide with Google Apps Script Ask for Help	36	4979	February 27, 2022
Send google calendar invites Ask for Help	20	2863	February 26, 2022

Add to Calendar

Related topics