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)

I’m glad you found that helpful! [image] ilias92: Have you tried/gotten duration to work instead of dtend. I haven’t tried this I’m afraid.

Been playing with this myself. Works great except that: I can’t get duration to work The appointments are created 1 hour later than what’s saved. All dates are configured in Zulu time. Not sure why it would be adding an hour on?

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. Here’s the article for reference: [image] Google’s ‘.new’ shortcut now works with calendar entries Try it out using ‘cal.new’ now

[image] alexs: To format the link so that it opens Outlook / Apple Calendar etc. remove the &format=gcal from the end so: Thanks for this! the &format=gcal is still there however…

@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… :face_with_raised_eyebrow: anybody has found a solution? Very cool feature btw

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.

Add to Calendar

Feature Requests

Jen_NYCP March 21, 2021, 10:21pm 22

This method helped me:

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