Create base for repeatable events?


#1

Say we have an event that is “Community Event” with materials and checklists attached to it but the community event can occur 4 times a year. I want to be able to schedule these four community events, attach the same type of task checklist to each event but still be able to check off tasks for each event.

It would be great if I could specify how many days before a task in the checklist has to be completed and compare that against the main event date. Any ideas? I’ve seen many project management templates but have not found a solution for repeatable events.


#2

I would have 2 tables, one for Templates, the events that are repeatable, and Events themselves.

For the second thing, you can use IS_BEFORE or IS_AFTER to compare with the Date of the Event.

Suggested threads: