Advanced Obsidian Dataview Hack: Auto-Link Meetings to Companies (less metadata!)

This video we go through an advance use-case of dataview! Updated dataview query: *** ```dataview table max(rows.created) as "Created", join(unique(rows.participants), ", ") as "Participants", join(unique(rows.participantLinks.company), ", ") as "Companies" FLATTEN participants as participantLinks WHERE contains(tags, "#type/meeting") AND contains(participants.company, this.file.link) GROUP BY file.link SORT max(rows.created) ASC ``` ----------------------------------------- SERVICES AND PRODUCTS ------------------------------------------ 📁Buy demo vaults here: https://www.constructbydee.com/services 👨🏻‍🏫 For PKM Consulting services: https://www.constructbydee.com/services ----------------------------------------- SHOW YOUR SUPPORT ------------------------------------------ ☕ If this Video helped you - show your appreciation by sponsoring a coffee for me (I write out a short story to thank people for sponsoring... personalized to you 😉): https://buymeacoffee.com/deeconstruct 📫 Mail me for any suggestions/queries/collaboration - always keen for a chat: [email protected] ----------------------------------------- TIMESTAMPS ------------------------------------------ --- 0:00 The overview 01:16 Vaults and consulting 02:24 The problem visualized 05:44 Creating the notes in the problem 09:28 The magical dataview query 13:10 Limitations and considerations 14:35 kay bye