# Coming Soon: Reserve a Room w/ Recurring Daily, Weekly & Monthly Events **URL:** \ **Category:** Project Showcase\ **Created:** [October 2, 2020, 2:33pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661 "2020-10-02T14:33:53Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 5, 2020, 6:38pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/41 "2020-10-05T18:38:21Z")
Nicely done! That potential conflict for recurring events might be tough to overcome — and honestly could be an issue, at least for me. I guess that repeat choice can’t happen pre-form eh? Ideally, an extension of the event picker component could/should be repeatable or multiple choices. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 5, 2020, 7:08pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/42 "2020-10-05T19:08:33Z")
Nice, Bob! > [@Robert\_Petitto](#): > > Uses Spreadsheet formulas—so there’s a 5-10 second lag. But it works! That’s why I dont like to use spreadsheet formulas at all 😬 ---
**Author:** ![Manan\_Mehta](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manan_mehta/32/13957_2.png) [@Manan\_Mehta](https://community.glideapps.com/u/Manan_Mehta)\ **Post date:** [October 5, 2020, 7:23pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/43 "2020-10-05T19:23:22Z")
Are you adding rows in another sheet? Is it like a pivot table or a query that you are using? With the script I am adding rows for each recurring booking. ---
**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:** [October 5, 2020, 7:33pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/44 "2020-10-05T19:33:55Z")
Correct. I’m adding rows in another sheet using a complicated array formula. ---
**Author:** ![Thomas\_Dahm](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_dahm/32/142_2.png) [@Thomas\_Dahm](https://community.glideapps.com/u/Thomas_Dahm)\ **Post date:** [October 5, 2020, 8:05pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/45 "2020-10-05T20:05:23Z")
pretty cool!! ---
**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:** [October 5, 2020, 8:30pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/46 "2020-10-05T20:30:08Z")
## Figured out Weekly Recurring too!!! ### Daily or Weekly all done through ArrayFormulas! _(lag and future conflict still present…will work on that next)_ ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [October 5, 2020, 9:08pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/47 "2020-10-05T21:08:24Z")
Nice one ☝ ---
**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:** [October 5, 2020, 10:46pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/48 "2020-10-05T22:46:46Z")
Great Job!!! ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [October 5, 2020, 11:47pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/49 "2020-10-05T23:47:06Z")
Looking good!! I wish form submissions could force a sheet refresh. Or I guess new rows across the board should force refresh in the app in order to prevent the lag as much as possible. I honestly can’t see Glide Tables getting all the functionality of sheets and I think there will always be a reliance on sheet formulas for some apps (like this one). If there were a way to make apps (maybe a Pro feature) somehow refresh more quickly upon row updates/additions, it would be awesome. ---
**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:** [October 5, 2020, 11:49pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/50 "2020-10-05T23:49:54Z")
100% agree. ---
**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:** [October 6, 2020, 1:27am UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/51 "2020-10-06T01:27:35Z")
> [@Robert\_Petitto](#): > > a complicated array formula. ![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e7ef204e54547fbee5a4ffb5c64aecbdd1283840.gif) You to me after figuring out there’s a much easier way lol. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 6, 2020, 8:25am UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/52 "2020-10-06T08:25:20Z")
Guys, I found a way to do it without spreadsheets formulas!!! ---
**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:** [October 6, 2020, 10:31am UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/53 "2020-10-06T10:31:53Z")
Seriously?! That would be amazing. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 6, 2020, 3:59pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/54 "2020-10-06T15:59:48Z")
Actually, I found what you said it’s hardest: prevent conflicts Today has a busy day, but when get a time here, gonna improve the dates to appear in event picker also ---
**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:** [October 6, 2020, 7:20pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/55 "2020-10-06T19:20:49Z")
# Monthly recurring as well! Thanks to @ThinhDinh for finding the correct spreadsheet function to make this happen. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 6, 2020, 8:40pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/56 "2020-10-06T20:40:24Z")
The only problem (and that’s why we’re still depend on spreadsheet formulas) is to show in event picker component… Event picker get only Start and End time… So, we **must** have more than one row for a better UX showing them… But I still got the logic to prevent conflicts of the dates if we wouldnt need to show them… well, in the way I thought actually ---
**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:** [October 6, 2020, 8:49pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/57 "2020-10-06T20:49:50Z")
You’re exactly right. I had to use formulas so dates would display in the event picker ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 6, 2020, 8:51pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/58 "2020-10-06T20:51:58Z")
That’s the only thing I got stuck, to show them. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [October 6, 2020, 11:44pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/59 "2020-10-06T23:44:14Z")
I tried my best, but with glide Data editor limitations, we cannot do it. Now I was thinking about it, how many rows would it create using arrayformula? 🤔 Because I was trying to do everything in DE at least to save as much as I could ---
**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:** [October 6, 2020, 11:57pm UTC](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661/60 "2020-10-06T23:57:12Z")
Potentially quite a bit…depends how many people are going to be booking events that recur daily. Weekly and monthly are nominal. [Previous page](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661.md?page=2) [Next page](https://community.glideapps.com/t/coming-soon-reserve-a-room-w-recurring-daily-weekly-monthly-events/16661.md?page=4)