Hi, I'm building a To-Do application where users can create recurring tasks like weekly, monthly etc where an email notification is sent three weeks before the due date.
But I can't figure out a good solution to handle the automatic creation of recurring tasks. The best I can think of is to query the database every night for recurring tasks and duplicate them if there is less than three weeks until the due date.
For information, in MS Outlook, the following task is populated only when the previous one is marking "complete".
It could be a way, even if you don't have a preview of all the following tasks, as some will be populated after (i.e. when the previous one is completed).