#31

Hi! New user here, how did you get the sort arrows in your table header?

1 Like
#32

Nice work!
Can you share how to set up ScriptKit for quick add like in that video?

1 Like
#33

As far as I can tell, the above scripts donā€™t work natively in Obsidian with DV. The reference to ScriptKit appears to be a MAC thing.

Can an expert rewrite the above for DV or DVjs only implementation?

#34

This is beautiful @arminta!
One thing I didnā€™t quite catch is whether or not youā€™re using checkboxes in this system? If so, how?
P.S. Nice to see a fellow Obsidian user also putting Scripture notes in there. :grinning:

#35

Hey, if possible could you please tell from which github repo you found the template? Iā€™m trying to replicate a few parts, but Iā€™m not really able to put into how I would want dataview to output stuff.

#36

i second that - dave, show us your set up! the people want to see! :)) please :sunflower:

but seriously, thank you to @arminta and @davecan for taking time to explain your workflows and show examples. SO appreciated, alleviates tension of having important project details locked in cloud based task management services. sending yall lots of sunshine :sunny:

1 Like
#37

Obsidian is not FOSS and is the same as Notion for all intensive purposes as far as licensing goes.

#38

Hi, you could also try eliminating files from your template folder. That way you can use this same line for all of your Dataview recipes.

for example, I exclude my templates folder using: !"System/Templates"

#39

I think she is using a field Completed:: and if it is marked 1, then it is completed.

#40

Yes, You are right.

#41

Thank you @armint, for typing out your workflow here. Iā€™m currently trying to do something similar, and I have a question for you.

If I understand your setup correctly, you have a note for each project, which contains the Dataview query to get the task notes associated with that project. What I donā€™t get is the ā€œProjectsā€ overview page. In your code example, you query length(tasks) as Total, for example. If I try to reconstruct this, the tasks variable is empty. I assume that is because the project page does not actually have tasks written in the note, but uses Dataview queries to get them from other pages.

Any help with this?

1 Like
#42

Hello @armint,

Iā€™m facing the same issue as @Joern. Is you clever workflow still working with latest Dataview (0.4.5)?

Thanks and regards

#43

For anyone if they stuck at length() function not working to get the progress show, I stuck the same question like you, and use the group by syntax to get the similar result, hope it can helps you.

table length(rows) as total, sum(rows.completed) as completed, sum(rows.completed) / length(rows) * 100 + "%" as Progress, rows[0].file.link as Next
from #tasks
sort file.mtime asc
group by project

if anyone know the answer why my length() is not working (seems like I am not only one meet this problem), please let me know.

#44

Fabulous resources @arminta!
Quick question here: Under available tasks and completed tasks, I keep getting this error.

Any guidance on how to fix this? Thanks!

Dataview: Every row during final data extraction failed with an error; first 3:

            - Operator '/' is not supported for 'null' and 'number
- Operator '/' is not supported for 'null' and 'number
#45

The only way I got the Projects dv to populate with
@armintaā€™s code above was by adding more than 1 task as a [[]] on the individual project template in the tasks:: field

#46

I too am getting a similar error in Dataview, it just started happening in the last 24hours:

Dataview: Every row during operation 'where' failed with an error; first 3:

            - Operator '+' is not supported for 'null' and 'number

If you find a solution @Keys , Iā€™d appreciate a ping.

@blacksmithgu or @Moonbase59 have you any ideas what is going on here? (I pinged Matthias as, in my case it is your ā€˜upcoming birthdayā€™ script that is no longer working for me).

1 Like
#47

No luck on my end. Couldnā€™t find a fix anywhere. Looking forward to seeing if you find out anything

#48

do you need to write a time value - e.g. recur length:: 7 days

#49

Besides all the useful information in this thread: @arminta , may I ask which theme you are using in your first post? Looks very refined and focused.

#50

This is such a great example.

Iā€™m keen to hear if/how anyone has implemented task scheduling into #mermaid gantt chart OR into the Daily Planner / #daily-note
This would aid in bringing it visually to life.

1 Like