Dataview: Getting contact infos in inline-fields with tags and file links in a table

What I’m trying to do

I have several notes that have contact infos in them with the inline field [Kontakt: some info]. These notes all have some tags and they obviously have a name. What I want to achieve is a table with the columns “Tag”, “Kontakte”, “Notes”. In every row there should be only one tag in the first column, all the contact info on any note with this tag in the second column and links to all notes with that tag (and preferably at least one [Kontakt: …] in it) in the third column.

Things I have tried

I have tried several querys, all only partly successful. For example:

TABLE WITHOUT ID tag AS Tags, rows.Kontakt AS Kontakte
FROM ""
WHERE file.tags
WHERE Kontakt
FLATTEN file.tags AS tag
GROUP BY tag

That looks pretty decent (apart from the akward lists in the second column), but I can’t figure out how to add the file notes.

Any help greatly appreciated!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.