this post was submitted on 21 Jun 2023
4 points (100.0% liked)

ObsidianMD

4196 readers
1 users here now

Unofficial Lemmy community for https://obsidian.md/

founded 2 years ago
MODERATORS
 

Hi! I've created a Book collection and, with Dataview, I've created also a table with a link to a folder containing one file for each author (where I can find all the book I have read or want to read belonging to this author). So I have a folder with the books and a folder with the authors. How can I create a table (or something similar, maybe a Kanban Board?) where I can see, for each author, the book in my folder. Hope to have explained clearly what I have in mind: sorry, English is not my mother-language as you can easily guess Thanks in advance for any help

top 1 comments
sorted by: hot top controversial new old
[–] [email protected] 2 points 2 years ago* (last edited 2 years ago)

Just to make sure I understand, you want your Author notes to have a Dataview table containing all the books they've written?

For each Book note, do you have a field (either in YAML or inline Dataview) pointing to the Author note? What I personally do is have an inline field that links to the Author note:

Author:: [[Stephen King]]

Then in the Author note I'll have this:

table without id link(file.link,title) AS Book, Year FROM "BOOK FOLDER" WHERE contains(Author, this.file.link)

Replace BOOK FOLDER with wherever your books are. Then you can paste this into all your Author notes. Even better, make an Author template so you don't have to type it each time you make an Author note.

load more comments
view more: next ›