The database entries in the table below automatically go to an archive database view after satisfying the following conditions:
- Task is done
- Task's deadline is more than 1 day in the past
Next, if the date is very far in the past, more than a month ago, there will be a third database view to prompt the user to delete the entries. Those conditions will be:
-Task is done
-Task deadline is more than 1 month in the past
Each database view can be achieved with simple filters.
To Do List
Name
Deadline
Done
Force Archive