# Add to calendar with multiple options **URL:** \ **Category:** Ask for Help\ **Created:** [May 5, 2023, 7:38pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402 "2023-05-05T19:38:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 5, 2023, 7:38pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/1 "2023-05-05T19:38:47Z")
Does anyone know how to create something like this (see photo) in Glide? ![Screenshot 2023-05-05 at 20.36.09](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06b3fdf4645979542a71e580bfa52f51fbf1aebb.png) I have Google Calendar set up using the new Actions feature but most of my users are iPhone people so it’s not great. ---
**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:** [May 5, 2023, 11:44pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/3 "2023-05-05T23:44:45Z")
I typically use Agical for use cases like this. One button for Google Calendar, one for “Other Calendar”. Basically, it downloads an ics file that lets you add events to your device’s Calendar app. > **[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:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 13, 2023, 12:33pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/4 "2023-05-13T12:33:41Z")
Thank you for sharing Agical!! ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 13, 2023, 5:47pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/5 "2023-05-13T17:47:07Z")
Sorry to come back to this but Agical keeps adding an hour on to my timezone - any idea for a workaround? From the page I can see that this has been flagged by other Agical users ---
**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:** [May 13, 2023, 11:36pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/6 "2023-05-13T23:36:27Z")
I don’t see that problem. How are you setting the column up? Do you use the Construct URL column? ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 14, 2023, 10:04am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/7 "2023-05-14T10:04:56Z")
I’ve tried with both Construct URL and Template. I’ve used the Format Date column to convert the existing Date column into this format: yyyy-MM-ddT:mm But I’m still having difficulties. Here’s how it appears using Template: [https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9](https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9) Russell street&dtstart=2022-05-2318:30:30Z&dtend=2022-05-2318:30:30Z&format=gcal - Now in the UK the clocks go forward in March, so that could be why the time generated is an hour ahead but I’ve not specified that I want that to happen… Here’s how it appears using Construct URL [https://ics.agical.io/?subject=Redfarm&reminder=1440&location=9%20Russell%20street&dstart=05%2F23%2F2022%2018%3A30%3A00&duration=2H&](https://ics.agical.io/?subject=Redfarm&reminder=1440&location=9%20Russell%20street&dstart=05%2F23%2F2022%2018%3A30%3A00&duration=2H&) format=gcal [space added on the end for format=gcal because otherwise it asks you to log in when posted on this page] - This generates today’s date and time. ---
**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:** [May 14, 2023, 10:40am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/8 "2023-05-14T10:40:31Z")
Your ISO start and end dates don’t look valid. > [@saucy](#): > > yyyy-MM-ddT:mm How does this even work? Where is Hour and Second? Where is 'Z’ulu? > [@saucy](#): > > Here’s how it appears using Template: > [https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9](https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9) Russell street&dtstart=2022-05-2318:30:30Z&dtend=2022-05-2318:30:30Z&format=gcal There is no ‘T’ in the dates in your url. > [@saucy](#): > > Here’s how it appears using Construct URL > [https://ics.agical.io/?subject=Redfarm&reminder=1440&location=9%20Russell%20street&dstart=05%2F23%2F2022%2018%3A30%3A00&duration=2H&](https://ics.agical.io/?subject=Redfarm&reminder=1440&location=9%20Russell%20street&dstart=05%2F23%2F2022%2018%3A30%3A00&duration=2H&) format=gcal Your date is not in ISO format. You have MDY instead of YMD. In any case, your need to make sure your date is in the correct format, and you need to specify the time offset or enter times in UTC time. ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 14, 2023, 10:55am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/9 "2023-05-14T10:55:40Z")
I couldn’t figure out how to add the T in Glide - that didn’t work for me. How do I do this? **Using the Format Date function** yyyy-MM-ddT:mm generates this for me in Glide: 2023-08-0819:00:00 yyyy-MM-ddTH:mm:ss generates this for me in Glide: 2023-05-2518:0018:00:00 The URL generated by the Template function on Glide works for me though - as mentioned it just added an extra hour onto the end, which is incorrect. [https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9](https://ics.agical.io/?subject=Redfarm&organizer=&reminder=1440&location=9) Russell street&dtstart=2022-05-2318:30:30Z&dtend=2022-05-2318:30:30Z&format=gcal **How do I specify the time offset? I’ve tried various different variations based on the example provided on the Agical page and nothing is working.** Could you elaborate on your points above further please? I’ve just been left with more questions here. ---
**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:** [May 14, 2023, 11:32am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/10 "2023-05-14T11:32:55Z")
‘T’ is a code that returns time. If you wrap it in single quotes, then it will be interpreted as a letter instead of time. This should help. > [@new "Respect time zone" support for Date & Time column in Glide Tables & Airtable](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/15): > > Try this. yyyy-MM-dd'T'HH:mm:ss'Z' [image] Or, this if you want the timezone offset instead. yyyy-MM-dd'T'HH:mm:ssZZ [image] This is also an easy alternative to using the Format Date. > [@Convert Date and Time to Zulu](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/34): > > @Jeff_Hager I just figured this out recently, You can do it by using a JavaScript column and returning the column itself. > [@saucy](#): > > How do I specify the time offset? I’ve tried various different variations based on the example provided on the Agical page and nothing is working. The agical document that @ThinhDinh linked to shows how the data should be structured and how to specify the offset. ![Screenshot_20230514-062048](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec0c2644c9988c5c29c0e770d72d5abf7209d0e5.png) ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 14, 2023, 5:04pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/11 "2023-05-14T17:04:17Z")
Thanks Jeff - when I use the static time offset it is adding an hour instead of taking an hour away. This is the same issue I had before. Is there a way to **subtract an hour**? ---
**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:** [May 14, 2023, 10:59pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/12 "2023-05-14T22:59:37Z")
What does your static offset value look like? Is it correct that your current time zone is -1 hour from GMT/UTC? ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 15, 2023, 6:20am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/13 "2023-05-15T06:20:49Z")
I live in the UK. We are currently on GMT+1. This is currently reflected in the time that the agical formula generates for the calendar invites. For example, if an event starts at 20:15, agical generates a calendar invite for 21:15. This is not the correct start time. I need an hour to be subtracted away so that the correct time is reflected. Can this be done? ---
**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:** [May 15, 2023, 10:07am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/14 "2023-05-15T10:07:08Z")
Where do you store your dates? Google Sheets or Glide Tables, or somewhere else? ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 15, 2023, 10:18am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/15 "2023-05-15T10:18:02Z")
Google Sheets ---
**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:** [May 15, 2023, 10:39am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/16 "2023-05-15T10:39:24Z")
Can you show us an example of a link you generated? ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 15, 2023, 10:52am UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/17 "2023-05-15T10:52:55Z")
[https://ics.agical.io/?subject=Cinema&organizer=Sarah&reminder=1440&location=Manchester&dtstart=2023-05-27T20:15:00Z&](https://ics.agical.io/?subject=Cinema&organizer=Sarah&reminder=1440&location=Manchester&dtstart=2023-05-27T20:15:00Z&) format=gcal **remove the space between “&” and “format” before pasting into your browser bar - if I do that here, it asks you to log in to Google for some reason** ---
**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:** [May 15, 2023, 12:03pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/18 "2023-05-15T12:03:27Z")
Have you tried to encode the dtstart part as this: 2023-05-27T20:15:00+01:00 It would result in something like this: > [https://ics.agical.io/?subject=Cinema&organizer=Sarah&reminder=1440&location=Manchester&dtstart=2023-05-27T20%3A15%3A00%2B01%3A00&format=gcal](https://ics.agical.io/?subject=Cinema&organizer=Sarah&reminder=1440&location=Manchester&dtstart=2023-05-27T20%3A15%3A00%2B01%3A00&format=gcal) ---
**Author:** ![saucy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/saucy/32/21556_2.png) [@saucy](https://community.glideapps.com/u/saucy)\ **Post date:** [May 15, 2023, 12:07pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/19 "2023-05-15T12:07:12Z")
Ahhh no thank you!! I didn’t realise that was possible. Thank you so much Thinh!! How would I encode that using Template/Construct URL? ---
**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:** [May 15, 2023, 12:17pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/20 "2023-05-15T12:17:51Z")
> [@Convert Date and Time to Zulu](https://community.glideapps.com/t/convert-date-and-time-to-zulu/24471/34): > > @Jeff_Hager I just figured this out recently, You can do it by using a JavaScript column and returning the column itself. Maybe use this first to convert the time, then instead of return p1, you use return p1 + “+01:00”. And use the result in Construct URL. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 21, 2023, 5:56pm UTC](https://community.glideapps.com/t/add-to-calendar-with-multiple-options/61402/22 "2023-05-21T17:56:41Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.