I’m trying to create a “To do” page to make new tasks very easy to make and manage.
Because i want it to be the most organized possible, i made 6 checkboxes in my “to do” template (“Administration”, “School”, …).
I want to display the title of the completed checkbox in my “To do” home page
I read the documentation about dataview a couple times and tried each tasks annotation, but none really works with what i’m trying to do.
In fact the ‘file.tasks.completed’ should only results the checked tasks if i understood correctly, so i tried using it with WHERE but it doesn’t work, instead it displays all the tasks even if they are not “completed”.
TABLE WITHOUT ID file.link AS File, choice(Tasks.completed, Tasks.text, "\-") AS Type FROM [[_002 Todo MOC]] WHERE file.name != "Todo Template" FLATTEN file.tasks AS Tasks SORT Tasks.completed DESC
I want to remove the blank fields from the table, i thought that maybe i could do it with dataviewjs but i don’t want to spend so much time just to do this.
Thanks for anyone responding to my request.