Bases: Column showing notes linked from a property, that also have a specific value in another property

Help
1

What I’m trying to do

I want to make a base of my books, and I want a column with links to the author(s). To reduce the number of properties across my vault, I link to authors via the broader property, which I also use to link to other broader concepts notes belong to (in the case of books, a non-fiction book could link to the note ‘productivity’, as well as its author).

So in this author column I only want to display notes linked in the book’s broader property where the linked note also has the type property value of book author.

Things I have tried

Searched the web, forum and discord.

2

If type is a list:

broader.filter(value.asFile().properties.type.contains("book author"))

If type is a text property, the above would include notes with a property like type: "not a book author", so you would want this formula instead:

broader.filter(value.asFile().properties.type == "book author")

the docs on formulas

1 Like
3

Thank you! It is indeed a list :slight_smile: