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.
1 Like
Nice, Bob!
That’s why I dont like to use spreadsheet formulas at all 
1 Like
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.
Correct. I’m adding rows in another sheet using a complicated array formula.
pretty cool!!
Figured out Weekly Recurring too!!!
Daily or Weekly all done through ArrayFormulas!
(lag and future conflict still present…will work on that next)
5 Likes
Nice one 
1 Like
Great Job!!!
1 Like
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.
5 Likes
100% agree.
1 Like
You to me after figuring out there’s a much easier way lol.
3 Likes
Guys, I found a way to do it without spreadsheets formulas!!!
7 Likes
Seriously?! That would be amazing.
2 Likes
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
1 Like
Monthly recurring as well!
Thanks to @ThinhDinh for finding the correct spreadsheet function to make this happen.
5 Likes
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
3 Likes
You’re exactly right. I had to use formulas so dates would display in the event picker
2 Likes
That’s the only thing I got stuck, to show them.
2 Likes
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
1 Like
Potentially quite a bit…depends how many people are going to be booking events that recur daily. Weekly and monthly are nominal.
1 Like