# Make a google calendar Event when the user click buttom **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [November 28, 2020, 10:36pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082 "2020-11-28T22:36:56Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![MartinLana](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martinlana/32/13943_2.png) [@MartinLana](https://community.glideapps.com/u/MartinLana)\ **Post date:** [November 28, 2020, 10:36pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/1 "2020-11-28T22:36:57Z")
Hello! I have a question. In my app there is a calendar with event dates, place and time. I need to make a button that when the user presses it, this event is created in their personal Google calendar. Is it possible to do this? Can somebody help me? I’ve been trying with Zapier but couldn’t do it. ---
**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:** [November 28, 2020, 10:40pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/2 "2020-11-28T22:40:15Z")
Hello @MartinLana You might wanna check this [post](https://community.glideapps.com/t/how-to-add-to-calendar/9820). You can also find a tutorial [here.](https://community.glideapps.com/t/add-event-from-glide-to-calendar-with-addevent/14784) ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [November 28, 2020, 11:23pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/3 "2020-11-28T23:23:40Z")
I was able to do this with a free resource, Calendar Link. Works like a charm with the template column and their API. [https://calndr.link/api-docs](https://calndr.link/api-docs) > [@toolbox Resources for building Glide apps](https://community.glideapps.com/t/resources-for-building-glide-apps/12563/29): > > A MUST ADD! Generate “Add to Calendar” links with URL parameters love_you_gesture:t4[https://calndr.link/](https://calndr.link/) ---
**Author:** ![Christophe\_Thomas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_thomas/32/21860_2.png) [@Christophe\_Thomas](https://community.glideapps.com/u/Christophe_Thomas)\ **Post date:** [March 19, 2021, 9:17am UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/4 "2021-03-19T09:17:31Z")
Hello, I have tried to use it, but it doesn’t work with the european date fomat : DD/MM/YYYY. Even if my timezone=Europe%2FParis ☹ So I have search a solution… Here is the solution : In order to convert my euro dates in iso dates, I use the Glide column Type “Template” with my original column with my date with European format. The template date is in raw format ie ISO like in my Google Sheet. And I use this template column in the template with calendr link 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/f/3f16cad56c1f68e9a597bb57661cc62309b430d0.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [March 19, 2021, 9:42am UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/5 "2021-03-19T09:42:11Z")
In Google sheets use substitute function to change date format, and than using scripts create event in your calendar ---
**Author:** ![Gideon\_Lahav\_Busines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gideon_lahav_busines/32/41121_2.png) [@Gideon\_Lahav\_Busines](https://community.glideapps.com/u/Gideon_Lahav_Busines)\ **Post date:** [August 24, 2021, 2:09pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/6 "2021-08-24T14:09:34Z")
> [@Lisa](#): > > Calndr How? ---
**Author:** ![Lisa](https://avatars.discourse-cdn.com/v4/letter/l/f08c70/32.png) [@Lisa](https://community.glideapps.com/u/Lisa)\ **Post date:** [August 24, 2021, 5:57pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/7 "2021-08-24T17:57:58Z")
You can use the URL column or Template column to set the URL parameters in their API documentation. The final result will be a URL that generates the correct calendar when selected ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 7:13pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/8 "2022-01-23T19:13:14Z")
Hi, I came across your solution. I have tried to apply the API but it seems not to be working. How did you do it that it was able to work for you. Kindly assist please. Kindly find attached a screenshot of the table and how I was trying to apply the API. Is there anything I am missing. ![Screenshot 2022-01-23 201742](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3bcf14f64e9f8a5784093062cdf68518d1516f1.png) Thank you ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 7:19pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/9 "2022-01-23T19:19:08Z")
Hi, I used the template but it seems not to be working. I also tried it with the construct URL, but it was not working as well. Please find attached a screenshot of the table and how I was trying to apply the API. Is there anything I am missing. Please help me. ![Screenshot 2022-01-23 201742](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/3/f3bcf14f64e9f8a5784093062cdf68518d1516f1.png) ---
**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:** [January 23, 2022, 7:50pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/10 "2022-01-23T19:50:09Z")
One possible issue is that your template replace values are going to replace EVERY instance it finds in that text string. Your template has SERVICE, START, END, and TITLE listed twice in the template, so it’s probably replacing each one twice. For any value that you want to replace in a template, I recommend making it a unique value that is nowhere else in the template. Something like {service} or {end} or @service or @end. That way you don’t unintentionally replace a value in the template that you didn’t intend to replace. Since your screenshot doesn’t show the entire result of the template column, it’s hard to say if that is what’s happening, but that would be my guess. ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 7:56pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/11 "2022-01-23T19:56:00Z")
Thank you so much for the quick response. I will apply this and give you an update. I sincerely appreciate your quick response. Thanks ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 8:03pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/12 "2022-01-23T20:03:35Z")
Hi. This is the result I got. I couldn’t get the link to work. ![Screenshot 2022-01-23 21042811](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56773e0f4899dd5732b8691da8155f3fd5ce4225.png) ---
**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:** [January 23, 2022, 8:21pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/13 "2022-01-23T20:21:47Z")
That looks better. I’m not sure what the problem could be though. I’ve never used calndr.link myself. Hopefully one of the others you replied to can chime in. I would recommend at least looking at the link @Lisa provided that describes how to build the link. [https://calndr.link/api-docs](https://calndr.link/api-docs) One thing I see off the top of my head is that you are not using the recommended date format. Also your title has a space in it in some cases, so that may cause issues. Using the Construct URL method is probably better because it applies the correct URL encoding to handle characters such as spaces and other characters that usually aren’t allowed in a url. ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 8:23pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/14 "2022-01-23T20:23:40Z")
Okay. Thank you. I will try out what you observed and if it does not work, I will wait for others to help. Thanks so much for your time. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [January 23, 2022, 8:35pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/15 "2022-01-23T20:35:11Z")
Try changing the Date Type. > Start date of the event. Most formats are parsed and accepted, but avoid those that can be ambiguous (for example, europe uses d/m/y and america uses m/d/y meaning the date 1/2/2020 could be either). > > It’s best to use ISO format (YYYY-MM-DD) dates. > > Examples: 2020-04-25 01:05 pm or 2020-04-25 15:30 ---
**Author:** ![Agape\_Kiss](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agape_kiss/32/36848_2.png) [@Agape\_Kiss](https://community.glideapps.com/u/Agape_Kiss)\ **Post date:** [January 23, 2022, 9:13pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/16 "2022-01-23T21:13:54Z")
Thank you so so much. I think it’s working now. I sincerely appreciate the help. ---
**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:** [January 24, 2022, 1:44am UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/17 "2022-01-24T01:44:51Z")
> [@Dilon\_Perera](#): > > Try changing the Date Type. Well spotted, Dilon 👍 Any time you see Glide datetime columns with dates that look like “yyyy-mm-ddThh:mm:ss.000”, that’s a sure sign that the columns were created in an attached Google Sheet, and Glide hasn’t automatically set the column type correctly. ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [June 24, 2022, 10:14am UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/18 "2022-06-24T10:14:35Z")
Hej, I’m running into similar issue with the date format. How have you finally solved it? I’m using directly the glide builder (not based on GS) and the format I have is the following: 26/06/2022, 11:02:00 Thanks ![Screenshot 2022-06-24 at 12.24.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/211cea223499c918e750aa8f54c054fdc10f83e2.png) ---
**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:** [June 25, 2022, 3:14am UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/19 "2022-06-25T03:14:46Z")
You can use a JavaScript column to return the bare format. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/3/9394e750c446e4903e775d28718e0bbc74ac74b4.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4363d73bbe027fea63edf52d981fe221ab6875b5.png) I’m UTC+7 so it’s returning a timestamp that is seven hours earlier (in UTC+0). ---
**Author:** ![Thibaud\_Dubrule1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thibaud_dubrule1/32/24485_2.png) [@Thibaud\_Dubrule1](https://community.glideapps.com/u/Thibaud_Dubrule1)\ **Post date:** [June 28, 2022, 12:09pm UTC](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082/20 "2022-06-28T12:09:52Z")
Nice thanks for the tip. I’ve kept it simple with just a template column replacing / with - like @Christophe_Thomas was suggesting. I also need to get a bit more familiar with Javascript. [Next page](https://community.glideapps.com/t/make-a-google-calendar-event-when-the-user-click-buttom/19082.md?page=2)