Automatically creating event recurrences
Hi All -
I am creating an event calendar (to be coupled with the Calendar App) and I would like to enable folks to submit a recurring event, noting the frequency as once a week, every 3rd Thursday, etc. I capture the initial start date, but cannot figure out how to automatically generate the additional rows with incremented dates so that they can be displayed on the Calendar.
I've seen a similar question on recurring tasks, but the solution there seems to generate a new task only when the previous one has completed... I'd like all recurrences to be generated at one time (and I'll set an end date or maximum recurrences so I don't blow up the sheet...)
Appreciate any insight!
Tags:
0
Answers
Yup, I've built something like this in the past.
I set up a seperate recurring events sheet.
Hope that helps, sing out if you get stuck.
Hi @BullandKhmer,
I appreciate you taking the time to tackle my question - thanks!
If I'm following the logic correctly, (7) results in a copy of an event recurrence to the destination sheet, but only on the day of the next recurrence (start date = today). In that case, would a calendar built off of the destination sheet only show today's events, but not occurrences set to happen in the future?
Please let me know if I've mis-interpreted the flow or the outcome.
Yeah mate, you're right, I kinda read back the OP after posting and realized that I had misinterpreted what you were asking for... Thought about reposting, but it was late. Then I went to bed thinking about it but only came up with some half-baked solutions. Let me think about it some more, maybe I'll come up with something that works (maybe not)
Cheers,
AJ.