Hi, I want to create an automation that creates different events based on a form submission and pushes them to our website. 80% of all the events organised are recurring and we have over 400 per month. Recurring in this case means weekly, bi-weekly, certain day of the month or certain day in a specific week.
Currently have two tables set-up (check table for internal purposes & live table).
The live table contains all the events for the current month and are 2-way synced with the website.
Struggling with the events that take place after the current month. For the 80% recurring about 20% is able to small changes (e.g. same date, but different location or starting time). Whenever an event passed, the event itself is automatically swapped with a new upcoming one to maintain the live URL on the website, instead of creating new pages for every event.
What would be an efficient way to easily moderate the all the upcoming events? Do we have to set-up copy tables for all the months (January until December) throughout the year? Or would it be smarter to create all the events in the check table upon creation? Or would a coming up table that replaces the starting dates be smart here?
