I have this system in place. For me the eventtype may be emails/actioned/calls/visits/meetings etc all created in the daily note via QuickAdd plugin
So far it appears to do what I want.
Daily Note would contains
eventtype:: my notes go here with [[link to note]]
eventtype2:: data with [[link to note]]
eventtype3:: data with [[link to note]]
Note where I want to display data
TABLE eventtype
FROM #DailyNote
Where eventtype
WHERE contains(eventtype ,this.file.name)
FLATTEN eventtype
WHERE contains(eventtype ,this.file.name)
SORT file.name DESC
No idea why or how it works, thanks to others really. Adding an extra line WHERE contains(eventtype ,this.file.name) seems to isolate all the variables for each note from including all those variables listed for other notes in the daily note.
Check out this really ingenious use of daily notes, dataview, and tracking events by gentrygibson. It gave me lots of inspiration on setting up similar ideas in my daily notes.
Thanks to everyone
With this material I think I’ll be able to finish implementing my idea, although clearly I’ve to study a lot about dataview, QuickAdd, tasks and templater.