What I’m trying to do
I have recently started working with obsidian and trying to learn the basics.
I have setup a calendar and want to setup queries in table form in my homepage.
There is 1 thing I don’t seem to be able to do:
I have a table listing all events (no filters for now) and managed to add a checkmark in front of the event if completed. I also managed to list all tasks within the note in the next cell as well as a true/false statement for the completed status of the task.
However when I try to add a choice function to make it prettier (using symbols), it shows just one checkmark for the whole note.
Things I have tried
My current code which doesn’t show the completed status for all 3 tasks within the note:
TABLE WITHOUT ID file.link as Tarefas, title as Tarefa, date as Data, startTime as Hora, choice(completed = "true","☑","☐") as ✅, file.tasks.text as Etapas, choice(file.tasks.completed = "true", "☑","☐") as ☑
FROM "2023-2024/Calendário/Tarefas"
Sort date, startTime
Code that displays correctly but “true /false” instead of the pretty symbols.
TABLE WITHOUT ID file.link as Tarefas, title as Tarefa, date as Data, startTime as Hora, choice(completed = "true","☑","☐") as ✅, file.tasks.text as Etapas, file.tasks.completed as ☑
FROM "2023-2024/Calendário/Tarefas"
Sort date, startTime
This is my first post, so any feedback on how to properly ask questions would also be appreciated.
Thanks in advance.