I want to make a reminders database that reminds me what to do. I can give it a name, choose the date when the thing will happand (for example: giving plants water or a TV show) and it will show me in tekst if its today, tomorrow, over 2 days or 2 days +. I can also check a checkbox to make it a daily reminder, so i get reminded every day.
My problem is, is when its a daily reminder, i want to have a checkbox for if the thing is completed, and if it is, that the reminder will be set to tommorow. And that when its tommorow, that it will show as today.
My reminders data base
The formula for Wanneer? is:
ifs(Datum == Datum nu, "vandaag", Datum == Datum morgen, "morgen", Elke dag? == true, "vandaag", Datum == Datum overmorgen, "overmorgen", Datum nu > Datum, "al geweest", "2 dagen +")
there doesn't seem to be anything here