# Create recurring calendar events in mobile calendars

**URL:** https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347
**Category:** Feature Requests
**Created:** [February 6, 2020, 9:53pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347 "2020-02-06T21:53:32Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Adam\_Thornhill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_thornhill/32/180_2.png) [@Adam\_Thornhill](https://community.glideapps.com/u/Adam_Thornhill)
#### Post date: [February 6, 2020, 9:53pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/1 "2020-02-06T21:53:32Z")

</div>

Based on user inputs, I want them to be able to create recurring events that they can add to their native mobile calendar. Is this possible with glide?

---

<div class="post-metadata">

### Author: ![melissa\_powell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melissa_powell/32/185_2.png) [@melissa\_powell](https://community.glideapps.com/u/melissa_powell)
#### Post date: [February 6, 2020, 10:08pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/2 "2020-02-06T22:08:11Z")

</div>

I was literally about to ask the same question 🙂

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 7, 2020, 4:02am UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/3 "2020-02-07T04:02:25Z")

</div>

At this point in the evolution of Glide that is not something that can be done. There is no real back end calculation logic that would make this possible now in Glide. Yes it can do math and create virtual columns of data based on this math but not actually create new rows of data. That leaves any logic back in Google Sheets. Maybe someone has figured out a way to do this with just sheet formulas but I think it would be difficult and have limitations. I can think of a few options but each would require some Google script code to pull off.

First would be to send all created calendar events to a Google calendar and let the Google calendar deal with these reoccurring events. The resultant events from the Google calendar would be imported back into a sheet which would be the one displayed in the app. I have not done the export myself yet, but do import nightly from a Google calendar into one of my Glide apps. The export logic wouldn’t be that much different from the import and there are a lot of cross functions available to connect the sheet to the calendar.

Second would be to write all of the calendar and reoccurring logic, again using Google scripting (javascript), in the script attached to the spreadsheet. This logic would create those reoccurring events. The would be significantly more difficult that the first option.

---

<div class="post-metadata">

### Author: ![Adam\_Thornhill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adam_thornhill/32/180_2.png) [@Adam\_Thornhill](https://community.glideapps.com/u/Adam_Thornhill)
#### Post date: [February 7, 2020, 8:17am UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/4 "2020-02-07T08:17:42Z")

</div>

Thanks, George. Do you know if this is in the Glide roadmap for any time soon?

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 7, 2020, 1:19pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/5 "2020-02-07T13:19:36Z")

</div>

Sorry I have no idea if it is or not. If it is however I would believe it is at the bottom of the list, but again I’m just speculating.

---

<div class="post-metadata">

### Author: ![ablx](https://avatars.discourse-cdn.com/v4/letter/a/8baadc/32.png) [@ablx](https://community.glideapps.com/u/ablx)
#### Post date: [February 7, 2020, 5:06pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/6 "2020-02-07T17:06:52Z")

</div>

> [@Sending a calendar invite by use of glide and users email](https://community.glideapps.com/t/sending-a-calendar-invite-by-use-of-glide-and-users-email/4352/3):
>
> Hi @Krivo I have just been having a play around with this! Depending on your PHP skills you can easily generate a HTTP request for this to be generated slight_smile I have just managed to link this to a button on my app and it downloads the ical and asks the user to add it straight away slight_smile The content of the URL could be made dynamic by using the Glide template fields slight_smile Heres a demo link slight_smile http://ablx.co.uk/ICALDEMO/index.php?location=123%20Test%20Str…

> [@Sending a calendar invite by use of glide and users email](https://community.glideapps.com/t/sending-a-calendar-invite-by-use-of-glide-and-users-email/4352/4):
>
> Here a demo app to show you it in use slight_smile

> [@Sending a calendar invite by use of glide and users email](https://community.glideapps.com/t/sending-a-calendar-invite-by-use-of-glide-and-users-email/4352/5):
>
> Small Update - Weekly Reoccurring events can be made by adding &weekly=yes to the end slight_smile Ive updated the demo to show this in action slight_smile

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [April 23, 2020, 8:38pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/7 "2020-04-23T20:38:41Z")

</div>

Hi guys. I have been hoping that 2-way calendar sync is on the roadmap as it’s a key feature I need.

Abix - Would you be able to create a video of how you have structured your spreadsheet/app as your solution looks like a potential work around for now. I haven’t used columns before.

With the app that I have that needs 2-way sync I know I have all of the details available within the app. I.e.  
User email address  
User Google calendar URL (you can get this from within Google Calendars to allow input.  
Appointment title  
Appointment UID (from Glide)  
Appointment start time  
Appointment duration

I am sure a piece of Google script could be written to be running in the background to sync new and any changes but I have no idea where to start as I’m not a programmer (hence using Glide apps!).

Thanks

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [April 23, 2020, 8:41pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/8 "2020-04-23T20:41:14Z")

</div>

George,

Would you be able to share some more details of how you achieve the import/export.

Assume I know nothing about programming and you’d be near my level of understanding!

Thanks

---

<div class="post-metadata">

### Author: ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [April 23, 2020, 9:06pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/9 "2020-04-23T21:06:54Z")

</div>

I just did a Google search and found this article [https://opensource.com/article/19/1/automate-calendar](https://opensource.com/article/19/1/automate-calendar). When I did a pull from a Google Calendar to a sheet I googled it and found some code that I modified.

Sharing more detail about code to someone who has no understanding of programming is kind of an oxymoron. Coding is all about details, which would not be understood by someone how has no knowledge. In any event take a look at the article and see if they do a good or bad job of dumbing it down to understand. If it’s too deep, do another search and keep looking at examples. I’m sure there are 100’s if not thousands of them. Good luck!

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 23, 2020, 9:08pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/10 "2020-04-23T21:08:29Z")

</div>

I was just thinking of this the other day too. Using Zapier, managed to at least import new calendar events from Google calendars to sheets (for all future events)…but if the repeating event is canceled the sheet still retains the rows that were created.

> [@Meet with Me: A Booking App that Prevents Conflicts](https://community.glideapps.com/t/meet-with-me-a-booking-app-that-prevents-conflicts/5916/25):
>
> Had to try this out! The Zap: Here’s the zap that imports to the Response tab of the Google Sheet: Proof of concept: Made a new 30-min Google Calendar Event on 4/6 at 7:00. You can see it generates a new row in the sheet which is recognized by Glide and results in the time slot being unavailable. If you try this out for yourself, make sure you leave the end date\_time tag empty. The sheet fills this in automatically based on the duration. Adding this tag will break the Ar…

---

<div class="post-metadata">

### Author: ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)
#### Post date: [April 23, 2020, 9:23pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/11 "2020-04-23T21:23:43Z")

</div>

Thanks George. I had found the same article actually and yes - It’s beyond me!

I’ll keep digging.

Thanks

---

<div class="post-metadata">

### Author: ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 8, 2022, 3:22pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/12 "2022-05-08T15:22:53Z")

</div>

Hello,

By any chance, would there have been an evolution since that makes it possible to add recurring dates (Birthdays for example) in the same calendar. I was told how to automatically generate anniversary dates for the following years: 2023, 2024, 2025 but this adds the dates in new columns and I don’t know how to insert them into the calendar.

Can I create a column that aggregates several dates for the same event: anniversary date 2022, anniversary date 2023, anniversary date 2024 and use this grouped column as a “date” field for my calendar. If yes, how to do please?  
Thanks

---

<div class="post-metadata">

### 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: [May 8, 2022, 3:44pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/13 "2022-05-08T15:44:36Z")

</div>

This is doable, but I have a question: do you actually need the dates for multiple years to show up in the calendar at the same time? Or would it be good enough to just show the anniversary dates (dynamically generated) for the current year? Either way would be possible, but the approach for each might be slightly different.

---

<div class="post-metadata">

### Author: ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 10, 2022, 2:26pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/14 "2022-05-10T14:26:15Z")

</div>

Hello Darren,  
Indeed, I would like to be able to offer a view on the current year and if possible on the following 2 years, therefore 2022, 2023 and 2024 for birthdays, wedding anniversaries in particular.  
Is there a solution to take into account all these upcoming dates in the calendar?  
Thank you  
Florence

---

<div class="post-metadata">

### 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: [May 10, 2022, 3:25pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/15 "2022-05-10T15:25:40Z")

</div>

What I would suggest is just show one year at a time, and use a choice component to switch years.

I made a small demo app to demonstrate how I would do it. You can make a copy and see if that would work for your use case.

> **[Recurring Birthdays](https://fluffy-payment-4745.glideapp.io/)**

---

<div class="post-metadata">

### Author: ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 11, 2022, 2:34pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/16 "2022-05-11T14:34:02Z")

</div>

Thank you very much Darren, it indeed works 🙂  
The problem is that I don’t only have birthday dates to integrate into this calendar, I also have “punctual” dates.  
When the user wants to add an event:

- either he adds a date of birth (DOB) = a birthday date that will be recurrent
- or he adds a “single” date (date-event) like wedding, baptism, etc… in this case the event will not be repeated in the calendar thereafter.

I tried to create a new column “All-date” with this rule “if DOB is empty, then Date-event”, “else mth/date-selected-year” but display calendar by year 2022 / 2023 / 2024 does not work anymore. Do you see a solution ?

---

<div class="post-metadata">

### 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: [May 11, 2022, 2:49pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/17 "2022-05-11T14:49:08Z")

</div>

> [@Fleau75](#):
>
> Do you see a solution ?

yes 😉

- Add a boolean column for the user to indicate if the event is recurring or not (true == yes)
- Add a math column to extract the year from the event date
- Add an if-then-else column to decide if the row should be visible or not:  
– If recurring is true, then true  
– If event year equals selected year, then true
- Use the if-then-else column values as a filter for the calendar

I’ve made the above changes to the demo app.

---

<div class="post-metadata">

### Author: ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 12, 2022, 12:13am UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/18 "2022-05-12T00:13:22Z")

</div>

Many thanks Darren, I managed to solve this part thanks to you, finally I believe 😉 Another question, and not least, is it possible with this new configuration to add a “+” button so that the user can add new dates to his calendar? I don’t see the option “Allow users to add items” anymore  
Thanks  
Florence

[image]

---

<div class="post-metadata">

### 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: [May 12, 2022, 12:41am UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/19 "2022-05-12T00:41:35Z")

</div>

> [@Fleau75](#):
>
> I don’t see the option “Allow users to add items” anymore

yeah, that’s because I used a Details layout instead of a List layout in order to accomodate the choice filters. All you need to do is add a button - floating button works well - with a Show Form Screen action.

I just added that to the demo so you can see.

---

<div class="post-metadata">

### Author: ![Fleau75](https://avatars.discourse-cdn.com/v4/letter/f/73ab20/32.png) [@Fleau75](https://community.glideapps.com/u/Fleau75)
#### Post date: [May 15, 2022, 10:12pm UTC](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347/20 "2022-05-15T22:12:27Z")

</div>

Perfect Darren, it works !  
Thanks so much for your help

[Next page](https://community.glideapps.com/t/create-recurring-calendar-events-in-mobile-calendars/4347.md?page=2)
