# Calendar reminder **URL:** \ **Category:** Ask for Help\ **Created:** [August 24, 2021, 11:32pm UTC](https://community.glideapps.com/t/calendar-reminder/30901 "2021-08-24T23:32:29Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 24, 2021, 11:32pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/1 "2021-08-24T23:32:29Z")
Hi, what is best way to set an event reminder from Glide to a calender, eg Google calender? Thanks ---
**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:** [August 24, 2021, 11:38pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/2 "2021-08-24T23:38:25Z")
To be clear, you can’t set it for your user. Best case is you provide them a button to do so with a service like Agical. > **[Introducing Agical.io, the smarter ICS file generator](https://blog.teknkl.com/introducing-agical-io-the-smarter-ics-file-generator/)** > > If you've used Marketo's dynamic ICS files (the "Calendar File" token type) you're probably not completely happy with 'em. While undeniably useful, they lack certain key elements we're used to when sending invites and requests via Outlook or other... ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 25, 2021, 12:02am UTC](https://community.glideapps.com/t/calendar-reminder/30901/3 "2021-08-25T00:02:22Z")
Thanks Thinh…I did come across your recommendation when searching this community, but could not really figure out how to do it. First time I am looking at this. Could you provide more example of the setup please. ---
**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:** [August 25, 2021, 12:28am UTC](https://community.glideapps.com/t/calendar-reminder/30901/4 "2021-08-25T00:28:21Z")
[https://agical-glide-yes-code.thinhdinh.repl.co](https://agical-glide-yes-code.thinhdinh.repl.co) This is not the complete version where I test all possible errors, but plug that link in an experimental code column and you can find the parameters needed. Please also take into account your starting and ending times must be formatted correctly (ISO). ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 25, 2021, 12:36am UTC](https://community.glideapps.com/t/calendar-reminder/30901/5 "2021-08-25T00:36:44Z")
thanks Thinh. will try it ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 26, 2021, 1:40pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/6 "2021-08-26T13:40:56Z")
Hi @ThinhDinh, Agical works nicely. However, I am using Glide Table and the date/time is 9/16/2021, 7:00:00 AM Is there a mathematical formula we can use to convert to ISO 20210916T07:00:00 Thanks ---
**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:** [August 26, 2021, 1:45pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/7 "2021-08-26T13:45:09Z")
I haven’t figured out that part, when I have time tomorrow I will try with XC and let you know if I find something. ---
**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:** [August 26, 2021, 2:44pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/8 "2021-08-26T14:44:59Z")
Something like this? ![Screen Shot 2021-08-26 at 10.35.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/3/c3643ddbbe8ed422a959b846812e3164b388ce7e.png) [https://mcdarren.github.io/glide-to-iso-string/](https://mcdarren.github.io/glide-to-iso-string/) Note that this will actually return the time in UTC, adjusting for the users timezone. ie. in my case I am UTC+8, so the returned times are 8 hours earlier. If you don’t want that adjustment made, you could use a math column to take the UTC offset into account before passing to the YC column. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 26, 2021, 2:52pm UTC](https://community.glideapps.com/t/calendar-reminder/30901/9 "2021-08-26T14:52:21Z")
thanks @Darren_Murphy, exactly what is needed. I just used 24 columns in Glide Table splitting, extracting and putting it back…also using IF-Then-Else I wonder which method is faster. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 1:05am UTC](https://community.glideapps.com/t/calendar-reminder/30901/10 "2021-08-27T01:05:56Z")
I did some testing. Attached is the image of 3 sets of time 1. 1st set - manually key in the ISO time → works as expected, able to link to GCAL with correct date & time 2. 2nd set - I did calculations inside Glide Table (GT) using about 30 columns to split, extract, calculate and then put together inside a template. The display looks good. When I use this column in your code, the GCAL date is always 1, Jan 1970, 7.30am for both start end end. I tried to display text, it shows --AMT. This means that for some reason the value is not being passed properly 3. 3rd set - using @Darren_Murphy formula. The value is correct (have not adjusted for timezone). The display looks good. When I use this column in your code, the GCAL date is always 1, Jan 1970, 7.30am for both start end end. I tried to display text, it shows correct value. However, when I do the select during setup of the text display, the value does not exist. This means that for some reason the value is not being passed properly. Appreciate your comments. Thanks ![ISOtime](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7fef062b1aed043f1f96f6f29cb137103169456e.jpeg) ---
**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:** [August 27, 2021, 1:12am UTC](https://community.glideapps.com/t/calendar-reminder/30901/11 "2021-08-27T01:12:42Z")
The difference seems to be that when you manually type it in, you aren’t using any separators. I can quite easily tweak the YC to produce that same format. Just give me a little while and I’ll do that for you. @Mns_Glide give that a try now ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 1:42am UTC](https://community.glideapps.com/t/calendar-reminder/30901/12 "2021-08-27T01:42:24Z")
thanks @Darren_Murphy . It does not help. Just to confirm, I also add in the “-” for the one I manually key-in. It works. So “-” or no “-” is both acceptable. I think it has something to do with the time it takes to pass the parameter over. As I mentioned before > [@Mns\_Glide](#): > > 3rd set - using @Darren_Murphy formula. The value is correct (have not adjusted for timezone). The display looks good. When I use this column in your code, the GCAL date is always 1, Jan 1970, 7.30am for both start end end. I tried to display text, it shows correct value. However, when I do the select during setup of the text display, the value does not exist. This means that for some reason the value is not being passed properly. ---
**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:** [August 27, 2021, 1:44am UTC](https://community.glideapps.com/t/calendar-reminder/30901/13 "2021-08-27T01:44:36Z")
Okay - what about the milliseconds part at the end and the Z suffix, could that be causing the problem? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 1:59am UTC](https://community.glideapps.com/t/calendar-reminder/30901/14 "2021-08-27T01:59:23Z")
Doesn’t help. Have tested changing time key-in manually to with microseconds or with Z…all working well. The one I calculated on GT was modified to add as well but NOT working. If you see the attached photo where I wanted to display the values in the APP, you can see clearly 1st set manually key-in shows the value 2nd set where I do internal calculation shows “AMTZ” 3rd set using your formula have no values yet (I guess it needs to retrieve from calculation?) I am narrowing it down to timing of populating the value before GCAL is called as main factor. Your thoughts? ![ISOtime1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf651c622aa68d407746af2789591cee53686b49.jpeg) ---
**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:** [August 27, 2021, 2:16am UTC](https://community.glideapps.com/t/calendar-reminder/30901/15 "2021-08-27T02:16:03Z")
yeah sorry, I’ve never used Agical so I’m not sure. At this point, I’m thinking @ThinhDinh will probably have a better idea. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 2:21am UTC](https://community.glideapps.com/t/calendar-reminder/30901/16 "2021-08-27T02:21:01Z")
thanks, The strange thing is - why I cannot display inside the app, the values in my template column. I can see it in GT, but when I do a text display, it comes out as AMT. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 7:38am UTC](https://community.glideapps.com/t/calendar-reminder/30901/17 "2021-08-27T07:38:58Z")
Just an update @ThinhDinh and @Darren_Murphy 1. Using both of your codes together are working well 2. Using construct URL and @Darren_Murphy 's conversion is working well @Darren_Murphy , the Timezone UTC+8 is right time for me also. Any chance of you changing this in the future that may affect my app? Thanks ---
**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:** [August 27, 2021, 7:50am UTC](https://community.glideapps.com/t/calendar-reminder/30901/18 "2021-08-27T07:50:17Z")
I have no immediate use for it myself, so it’s unlikely that I’ll change it in the near future. But if you want to be safe, you are welcome to clone the repo: `git@github.com:mcdarren/glide-to-iso-string.git` or > **[GitHub - mcdarren/glide-to-iso-string](https://github.com/mcdarren/glide-to-iso-string)** > > Contribute to mcdarren/glide-to-iso-string development by creating an account on GitHub. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [August 27, 2021, 7:51am UTC](https://community.glideapps.com/t/calendar-reminder/30901/19 "2021-08-27T07:51:29Z")
thanks…now need to go and learn how to clone ---
**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:** [August 27, 2021, 7:55am UTC](https://community.glideapps.com/t/calendar-reminder/30901/20 "2021-08-27T07:55:20Z")
haha, I’ve been a Github user for many years, so wasn’t really comfortable using replit. To get these YC columns up and running using Github: - Sign up for a Github account - Clone the repo - Publish it as a “page” To do that last step, you need to navigate to the repo, then go to Settings → Pages Everything you need to know about Github Pages: > **[GitHub Pages Documentation - GitHub Docs](https://docs.github.com/en/pages)** [Next page](https://community.glideapps.com/t/calendar-reminder/30901.md?page=2)