User Add Google Calendar Event from Link

This may be obvious to many, but I had to figure it out for myself. I have a list of events that are displayed in a table and I wanted the user to be able to add these events to their google calendar using a link. Knack has some of this functionality if the data is in a calendar view, but I couldn't figure out how to add this from a table view.

I found this explanation on Stack Overflow and it was very helpful. https://stackoverflow.com/questions/5831877/how-do-i-create-a-link-to-add-an-entry-to-a-calendar/19867654#19867654

In short, I created a 2 text formulas with a start and end time and then a third text formula with the link template below. This allowed me to pass the start and end time, event title, location and details into the link.

Here's the template google calendar link from SO.

https://calendar.google.com/calendar/r/eventedit?text=My+Custom+Event&dates=20180512T230000Z/20180513T030000Z&details=For+details,+link+here:+https://example.com/tickets-43251101208&location=Garage+Boston+-+20+Linden+Street+-+Allston,+MA+02134

The text formula for the dates are:

formatDate({Date/Time},YYYYMMDDTHHmmss)

Make sure the HH is capitalized so that the hours are reflected in military time. I don't think it works if you don't have a start and end time. I preferred to have 2 fields for the start and end time rather than using Knack's built in start/end time feature.

Hope this helps!

Sure! Happy to help.

Nice. thanks for this, don't have a need right now, but I may int he future, so thanks for sharing :)