I’d like to create a table, one row per files in a subfolder, one column per section in these files.
I have currently 2 different but related usecases
- I have to prepare user stories for a project
- I have to prepare architecture principles for a roadmap
I started these tasks using Excel but ended with worksheets impossible to display on small screens (<15"). And in the end, with Excel, it’s far from practical, having too much text in a cell.
If I take the example of the architecture principles, I made an obsidian template corresponding to the columns I had in the Excel file.
---
creation-date: <% tp.file.creation_date("YYYY-MM-DD") %>
tags:
aliases: []
index:
parent:
---
Last update: <%+ tp.file.last_modified_date("YYYY-MM-DD") %>
# [[<% tp.file.title %>]]
## statement
## rationale
## implication
## exemption
## reference(s)
## note(s)
But reviewing it with my team, or when preparing a slide deck for management validation, having all these notes is a bit impractical. I’d like, with dataview, to prepare a dynamic index note, one row per files in a subfolder, one column per section. I started with:
| AP file | statement | rationale | implication | exemption |
| ------------- | --------------------- | --------------------- | ------------------------ | --------------------- |
| [ap1](ap1.md) |  |  |  |  |
| [ap2](ap2.md) |  |  |  |  |
As you can guess, that is not dynamic (not even dataview).
Using dataview, I got as far as:
TABLE WITHOUT ID
index AS "Index",
rows.L.text AS "statement"
FROM ""
FLATTEN file.lists AS L
WHERE contains(file.folder, "Architecture Principles")
AND !contains(file.name, this.file.name)
AND meta(L.section).subpath = "statement"
GROUP BY file.link
I am now stuck.
Before adding another plugin to my vault (I was thinking about Database Folder), has anyone any lead on the topic?
Thanks, a lot.