Yeah, so do I
I was thinking in something like this too, nice thought
I did kind of work out the logic for reoccurring calendar entries but only to the point where it shows in the calendar once. Then when the day is passed, it will show up on the next day.
I demonstrate here with multi-day events. I haven’t had a chance to get back to it and work out the logic for weekly/monthly events. I’m also kind of waiting to see what new calendar features we get from glide. Basically the start date is calculated on the fly based on the original start date, the end date, and the current day.
Neat! Does it check for conflicts?
No, it doesn’t. I figured like a Google calendar, there can be concurrent events. This was just me playing around with date math and the event picker. I focused more on trying to accomplish reoccurring events.
Gotcha. Well hats off to you!!! It’s a tricky concept for sure.
Yes I had seen your calendar concept before and liked what you did there. The ultimate is a combination of that concept and @Robert_Petitto’s template here. I honestly don’t know how (or if) it can be done the way I’d need it to be done, but who knows. I’m basically trying to replace a booking method that is done through email appointments (with multiple options for recurring dates — weekly, monthly, custom). I love Glide, so moving to its interface would be amazing. I just don’t think it’s all possible yet!
Working on it!
Interesting. Is it difficult to come out with the logic that prevents conflict?
Preventing conflicts is the most complex thing I have ever done in Glide.
Indeed!
For recurring events, are you guys open to using Apps Scripts to create those? I believe you are adding a row for each event to prevent conflicts, can do the same when a user selects a recurring booking by writing a script that creates multiple rows for recurring bookings.
Open to that for sure! Not making much headway with my ArrayFormulas
Yeah may be necessary… that may prevent the template from being accepted into the Template Store though (I don’t think they like the reliance on scripts in the store). I’d still buy it outside the store though! Haha
Yeah because duplicating scripts as well when selling a template is gonna be a nightmare.
Going to experiment with Scripts then!
Tried my attempt at creating the recurring events with Scripts. Ofcourse because GSheets and Scripts are involved, there’s a lag but it achieves exactly what’s needed.
The app needs a major UI upgrade though!
Try the app here: https://average-dinner-6541.glideapp.io/
(Create a recurring event and wait for a few minutes or open the app after sometime and all events should be loaded)
Great job!
Nicely done bro!
Daily Recurring Events!
Uses Spreadsheet formulas—so there’s a 5-10 second lag. But it works!