Does anyone know how to create something like this (see photo) in Glide?
I have Google Calendar set up using the new Actions feature but most of my users are iPhone people so it’s not great.
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.
2 Likes
Thank you for sharing Agical!!
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
I don’t see that problem. How are you setting the column up? Do you use the Construct URL column?
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 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& 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.
Your ISO start and end dates don’t look valid.
How does this even work? Where is Hour and Second? Where is 'Z’ulu?
There is no ‘T’ in the dates in your url.
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.
1 Like
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 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.
‘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.
This is also an easy alternative to using the Format Date.
The agical document that @ThinhDinh linked to shows how the data should be structured and how to specify the offset.
2 Likes
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?
What does your static offset value look like? Is it correct that your current time zone is -1 hour from GMT/UTC?
1 Like
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?
Where do you store your dates? Google Sheets or Glide Tables, or somewhere else?
Google Sheets
Can you show us an example of a link you generated?
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
Have you tried to encode the dtstart part as this:
2023-05-27T20:15:00+01:00
It would result in something like this:
1 Like
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?
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.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.