Easily use Bases formulas and view file properties in any note

[peeragetalkers]

I found a super easy way to use formulas and view file properties—both enabled by Bases—for any note that is currently in focus:

All you need to do is to create a base with a filter that outputs the current note only:

file.path == this.file.path

You could then embed that base into note:

Or drag it to a sidebar:

The base will then always reflect the note that’s currently in focus.

Though it might be annoying to have to scroll horizontally if you add lots of properties to the base. Related feature request:

Bases: Transposed Table View

Use case or problem At the moment, in the Bases Table View, each selected file is a row and the properties are columns. It’d be great to have a view where rows and cols are switched so that each property is in a row and each file is in a column. Check out the GUI for https://loophabits.org/ as an example.

A couple of uses for this that I’ve come up with is to view the modified time file property and to calculate mins to read based on the word count property.

The Virtual Content plugin does something similar—without having to modify the note.

I’d love to hear what uses you’ve come up for this

Inspired by a post from kepano.

Also, I made a feature request for dynamic properties in YAML:

Dynamic file and formula properties from Bases in YAML

Use case or problem Bases introduced powerful formula properties and dynamic file properties like file.mtime and file.size. Unfortunately, both can only be used and viewed within a base. Proposed solution Add support for the two new property types—file properties and formula properties—to frontmatter in-note. For example, if we input the following values in note YAML: --- reading_speed: 250 words: 1000 time to read: "words / reading_speed" modified time: "file.mtime" file size: "file.siz…

[g_hz]

Very good idea! With the card view it’s more pleasant to see than the default table.