i have this use case which i need help in :
i have 3 types of RECURRING tasks:
1-daily task: i can finish a task as much times (x) as i entered daily
2- weekly task : i can finish a task as much times (x) i want for a duration of 7 days from the creation day.(1 time every day)
3- monthly task: i can finish a task as much times (x) i want for a duration of 30 days from the creation day.(1 time every day)
for the daily task i think the video from Robert Petitto solves my issue for just for 1 time task done daily.
link to the video for reference:
-and for the weekly and monthly tasks i tried to replicate the same but of course it all started to be hard.
how can i configure this in the database and show different messages based on number of completions and if a weekly task is done for (x) number of times 7 days from the creation time and …etc
my issue is with the logic inside the tables and sure some visibility conditions for some buttons will solve the display issue but how can i implement this in the database, i have no problems in making 3 tables for these 3 types of tasks if needed
thank you guys very much for the support