# Add to Calendar **URL:** \ **Category:** Feature Requests\ **Created:** [February 3, 2020, 9:53pm UTC](https://community.glideapps.com/t/add-to-calendar/4230 "2020-02-03T21:53:42Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [March 21, 2021, 10:21pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/22 "2021-03-21T22:21:20Z")
This method helped me: > [@Convert Date and Time to Zulu](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471): > > 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! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 3:28pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/23 "2021-04-26T15:28:34Z")
> [@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: ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [April 26, 2021, 3:40pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/24 "2021-04-26T15:40:04Z")
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. > [@Free push notifications Workaround](https://community.glideapps.com/t/free-push-notifications-solved/6183): > > 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… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 26, 2021, 3:46pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/25 "2021-04-26T15:46:36Z")
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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 3:49pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/26 "2021-04-26T15:49:38Z")
> [@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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 26, 2021, 3:49pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/27 "2021-04-26T15:49:52Z")
> [@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. > [@Convert Date and Time to Zulu](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/4): > > 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 ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [April 26, 2021, 5:52pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/28 "2021-04-26T17:52:35Z")
Epale @Robert_Petitto I am sure you already thought about this but here it goes. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 5:56pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/29 "2021-04-26T17:56:08Z")
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. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 26, 2021, 6:02pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/30 "2021-04-26T18:02:23Z")
Isn’t the solution just to collect the users timezone offset when they sign up, and store that in their user profile? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 6:04pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/31 "2021-04-26T18:04:08Z")
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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 6:05pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/32 "2021-04-26T18:05:24Z")
> [@Darren\_Murphy](#): > > collect the users timezone offset when they sign up I’m also using only glide tables, so importing the list of available time zones is not going to be fun. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 6:07pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/33 "2021-04-26T18:07:33Z")
I know! Glide needs a current timezone column! 😁 @Mark ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 26, 2021, 6:14pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/34 "2021-04-26T18:14:34Z")
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 ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 6:27pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/35 "2021-04-26T18:27:37Z")
> [@Darren\_Murphy](#): > > there would be no way to get that data back into your Glide Table Exactly. Oh well. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 26, 2021, 11:21pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/36 "2021-04-26T23:21:06Z")
> [@Robert\_Petitto](#): > > I’m also using only glide tables, so importing the list of available time zones is not going to be fun. 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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 26, 2021, 11:27pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/37 "2021-04-26T23:27:59Z")
Does this still work if I didnt start with a Google Sheet? The app is built completey with a Glide table. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 26, 2021, 11:29pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/38 "2021-04-26T23:29:08Z")
Oh that’s a no go then. Due to cases like this I always start with a Google Sheet to have a fallback option. ---
**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\ **Post date:** [April 27, 2021, 3:38am UTC](https://community.glideapps.com/t/add-to-calendar/4230/39 "2021-04-27T03:38:38Z")
> [@Darren\_Murphy](#): > > Indeed. > > > [@](#): > > > > 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 This solution doesn’t work for you? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [April 27, 2021, 3:42am UTC](https://community.glideapps.com/t/add-to-calendar/4230/40 "2021-04-27T03:42:57Z")
It will, but Bob’s challenge is that his users will be in different time zones. So he really needs to have the GMT offset as a user attribute. And it’s further complicated by the fact that the offsets can change at certain times of the year due to daylight savings adjustments. And it’s even _further_ complicated by the fact that he’s using Glide Tables only, which pretty much rules out any automated option for keeping the values updated. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 27, 2021, 1:47pm UTC](https://community.glideapps.com/t/add-to-calendar/4230/41 "2021-04-27T13:47:44Z")
Seems like a problem only Glide can solve 😉 @mark [Previous page](https://community.glideapps.com/t/add-to-calendar/4230.md?page=1) [Next page](https://community.glideapps.com/t/add-to-calendar/4230.md?page=3)