Use AI To Help Build Your Second Brain in Obsidian MD (Dataview Plugin Queries Example)
Вставка
- Опубліковано 10 чер 2024
- 🤖 Get the Dataview prompts/notes publish.obsidian.md/johnmavri...
📚 FREE COURSES/RESOURCES:
🌌 Visit my second brain with 2000+ notes at notes.johnmavrick.com/
🧠 Organize your life and knowledge by building your second brain free.johnmavrick.com/code-method
📃 Get my FREE 4-part Obsidian beginner course with 20+ templates free.johnmavrick.com/obsidian...
👩🏫 3 Days to Lecture Note Taking Mastery: course.aidanhelfant.com/3days...
🤖 Get my FREE Ultimate Guide to using AI for PKM with 15+ prompts free.johnmavrick.com/ai-pkm
✨ PRODUCTS:
🧠 Get the ULTIMATE Obsidian MD Starter Vault shop.johnmavrick.com/usv
🎓 Master Obsidian for School and Studying shop.johnmavrick.com/obsidian...
📢 SOCIALS:
🔗 Check out all my socials beacons.ai/johnmavrick
✨ Join my weekly newsletter for insights on PKM, productivity, and self-actualization newsletter.johnmavrick.com/
🛠️ MY TOOLS:
📚 Get 20% off my favorite book summaries www.shortform.com/johnmavrick
📖 Try my favorite reading and highlighting app for 60 days free readwise.io/i/john5833
📆 Try my daily driver for task and project management: akiflow.com/?ref=mtewmzk
If you have any other video suggestions or tips, feel free to let me know!
⌚️TIMESTAMPS:
00:00 - Introduction
00:52 - Use ChatGPT to create Obsidian dataview queries
05:24 - Setting up AI assistants in Obsidian to create complex queries
08:39 - Creating the Dataview AI Assistant
🙌 CREDITS:
🎶 SONGS USED:
Bunny Girl Senpai ED Fukashigi no Carte [ Lofi Remix ]
BlockBuster 🎥 No Copyright Lofi Hip Hop & Chillhop Mix 2021 _ Chill lofi beats to study / relax to
uso (Fullmetal Alchemist but is it okay if it's lofi hiphop)
🏷 TAGS:
The Ultimate Guide to Using AI for Better Notes And Learning using ChatGPT and Obsidian Obsidian App,How to Get Started with Obsidian App,how to use obsidian app,how to use obsidian note taking app,obsidian for beginners,obsidian.md,Nick Milo,Obsidian Linking Your Thinking, Obsidian, app for students,Obsidian free course,obsidian app for students,Obsidian app features,imf framework obsidian,how to organize notes in obsidian,Obsidian app notes,Obsidian app notes tutorial,note-taking app obsidian,obsidian linked mentions, Obsidian review pros and cons, Best note taking app 2021, best idea organizer 2021, best writing app 2021, how to take smart notes, notion note taking app, roam research note taking app, taking book notes obsidian, book notes tutorial, permanent note obsidian, maps of content obsidian, article notes, obsidian templates obsidian,markdown notes,daily notes,roam research,obsidian.md,obsidian notes,obsidian workflow,how to use obsidian app,obsidian app,obsidian daily notes,obsidian daily notes template,Obsidian daily notes task,obsidian daily notes prompts,obsidian template examples,obsidian bullet journal,obsidian day planner,obsidian task management,obsidian calendar plugin,obsidian journal,obsidian time blocking,obsidian to do list,obsidian gratitude journal obsidian, obsidian.md, obsidian note taking,obsidian app,obsidian notes,obsidian note,obsidian review,obsidian tutorial,obsidian workflow,obsidian tips,obsidian templates,obsidian zettlekasten,how to use obsidian,note taking app,note taking,notes,obsidian.md, obsidian vs notion, obsidian app for students, bsdian, obsidian.md, obsidian note taking,obsidian app,obsidian notes,obsidian note,obsidian review,obsidian tutorial,obsidian workflow,obsidian tips,obsidian templates,obsidian zettlekasten,how to use obsidian,note taking app,note tiago forte, second brain, building a second brain,
Only AI plugin I'm prepared to try so far -- never heard of Assistants yet.
Bravo
I will be trying this one, but another that I have as standard included is Smart Connections, It does the usual converse with your notes thing and as long as you make sure to include a primer note that it can recognise as a bootup prompt to stop it from prefixing everything it says with "according to your notes".. It's really good. As the name suggests it's mainly there to provide an easy way to form connections between notes.
@@TimothyCoxon No support for Google AI Studio's (free) Gemini Pro. Copilot has support for that.
🎯 Key Takeaways for quick navigation:
00:00 *🧠 Using AI to simplify data view queries in Obsidian MD*
- Simplifying data view queries in Obsidian MD using AI assistance,
- Creating prompts to instruct AI in generating data view queries,
- Streamlining the process of creating complex queries with AI assistance.
01:43 *📝 Creating a basic data view query*
- Demonstrating the creation of a basic data view query with AI assistance,
- Generating a query to display specific note fields and sort by creation date,
- Modifying the query to exclude certain notes based on folder location.
05:23 *🛠️ Leveraging AI assistants for advanced queries*
- Exploring the limitations of manual prompts for complex data view queries,
- Introducing AI assistants for dynamically retrieving relevant information,
- Utilizing AI assistants to create advanced queries by leveraging uploaded notes.
Made with HARPA AI
Thanks for this video, it pushed me to make my own gtp with chatgpt 4 to help with obsidian when I am stuck. It managed to fix a problem I have been trying to fix for quite a while now. can intelligence use chatgpt 4 btw?
I’ve fallen in love with obsidian recently. Last night I was having epiphanies about my work and obsidian helped me capture those ideas in the best way possible. I’d love to share your content with my friends and family and professional network, but wish you would shake the anime theme of your profile so they wouldn’t be turned off. Be your authentic self, your true authentic self!
Hi, Jbar!
I'm glad to hear that Obsidian is working well for you during your late night spontaneous thoughts, and appreciate you wanting to share my videos with other people to help them achieve something similar! you do bring up a good point of my anime style not being the most appropriate for the average person / corporate coworker, i'll keep it in the back of my mind but one of my potential channel routes is to help this specific demographic improve their life and be more productive, as there's not many anime/vtuber productivity people out there (which could also be a sign of it not being the smartest play). i try to minimze the amount i use it in my videos like this one and focus on the content and workflows, but if that is not enough i would recommend fromsergio for workflows and nick milo for ideas in Obsidian. and yes this isn't my authentic self, but i enjoy the persona and theme i've built for my personal brand, and i don't think i would've had the courage or environment to do anything in person.
HeyJbar just a stranger on the internet here.. but wanted to share my opinion on this if you are up for it continue reading ✌️...
Don't you think this could potentially also be related to yourself and your friends ?
I mean why would you feel they are turned off like you could read their mind maybe some also like anime but are afraid to share that side of them ? Also even if they are turned off and can't differentiate between good content and their projections of people liking anime characters thinking it might not be professional that's kind of their problem would you agree on that ?
If you agree it really could be that you are not being your authentic self and feeling like you cant share this video because you are afraid of what they might think of you cause otherwise you would just share it and don't care about their opinions one could guess ? ...
Anyway thanks for reading and I hope you don't take this personally cheers and much success with Obsidian im also just getting started 🍻
@@Marcel-xs1er I think it does make sense that they would be turned off, but like you said it would be a shallow form of prejudice. If I do end up needing to cater to a more corporate audience I will change my personal branding but right now I feel like not being too professional helps me incorporate my 20-year old self in more ^^
Great video! Need some advice: My use case is:
I have a list of songs as atomic notes.
I have a list of albums as atomic notes.
Songs first appear on an album in a position, ie. the last song, second song, etc on the album.
The same song may also appear on a different album, like a compilation album, or a live album, in a different position in the track list. Or if I’m building a list of concert set lists, it may have been performed hundreds of times.
What’s the best way generate track lists containing the songs?
I was thinking the song would have tags for each album on which it appears, but that omits the track number on that album.
I could have a second tag, like album name and track number, but that doesn’t seem like it would scale very well for concert lists.
Any recommendations for how to do this with dataview?
Extra complexity I can skip if not feasible:
I also want to include other data for the song. For example, a live version one night might be a different run time. Say, someone took a long solo, or there was an extended jam, etc.
interesting and complex use case indeed ! are these going to be dynamically changing ? i am thinking it might be better to just use regular tables or links if they are a one-time creation.
Since you want it to appear in different parents in their queries, and each one has their own unique position, i think you can have an in-line field in each note for each album it is in, with the key being the album name and the value being the position
So if you have two albums Album 1 and Album 2, in your song note (that only has the tag #song) you can have fields like:
Album1:: 10
Album2:: 4
Then in Album2 you can create a query with the following content:
```dataview
table Album2 as Position
from #song
sort Album2 asc
```
as for run-time you can add another field called something like AlbumRuntime and then add that to the table field
```dataview
table Album2 as Position, Album2Runtime as Runtime
from #song
sort Album2 asc
```
Let me know if that helps :)
@@itsjohnmavrick That makes sense! Yes, once I create a new note with the song as one of the tracks (ie: a new concert set list, or new compilation album, etc.). it will be permanently associated with that album and in that position, and the song's time will not change.
Thank you!!!
I wonder if Obsidian can have properties dynamically loaded from a note, like you can with allowed values. I want to enforce consistency in the album names, as each will be applied for every song (or concert date of a tour - potentially hundreds of times). Or maybe this would be better handled with something like a text macro tool like Keyboard Maestro or TextExpander. I could load those up with all my albumTitles followed by :: and then just enter the numerical value, something less error prone. Thought?
@@douggottlieb with metadata menu plugin you can set the potential fields that a note with the #song tag will have, then you can use the menu to choose from there to prevent typos.
Thanks John! I’ll keep experimenting. It would be cool if the note used as the acceptable values could combine manually typed items on their own lines (like albumTitles) as well as results from a DataView query (like concertDates). You’ve put me onto a great path! THANKS SO MUCH!
Hey John, how did you get your date in properties to display correctly? YYYY-MM-DD
can you give an example timestamp ?
How do we do a translucent background on iOS? I just want a background for my graph views
sorry i'm not that sure :( if you know CSS you can maybe figure something out with a custom snippet though
Can I connect Ollama to your plugin?
not as of now :( i might change it and make a new one will see
8:09 😂!
that was the first time i have experienced anything like that 😭
Épico
2nd brain? I still need to make my first
GG
I just asked ChatGPT 3.5 and ChatGPT 4.0 if they are "familiar with the dataview plugin for Obsidian". They both answered that they are and provided the correct context. Are you sure you needed to train an AI assistant with the knowledge of dataview?
by correct context do you mean that when you asked it for a query it gave you one that worked?
@@itsjohnmavrick No, it just described what the plugin was used for. Let me try to come up with a prompt for my own stuff and see if it generates a good query. I'll let you know. 🙂
@@desertdwarf i already showed how you can use only chatgpt without the ao assistant to create a query with a single prompt , so what would be the difference in objective for your prompt?
@@itsjohnmavrick I felt like the prompt you provided was bigger than necessary by giving information about how it should structure the query output and what metadata was available. It seemed like a lot of extra stuff you were including in the prompt. Please excuse me for any critique of it as it may have been more on-point than I originally thought.
I want to thank you for teaching me about the AI Assistant feature. Even though I watched Sam Altman's presentation a month and a half ago, I haven't created one yet. So, thank you for that!
I did successfully test ChatGPT 3.5. My test prompt was, "I have an Obsidian vault with the dataview plugin installed. Can you write a query that shows only the 10 most recent notes from a folder named 'Test folder' sorted in date order with the most recent listed first?"
It gave me a query with only one thing incorrect: it used '==' instead of '=' in the WHERE clause and it hallucinated that there is a "file.type" metadata available. Its original suggestion was:
```dataview
table
from "Test folder"
where file.type == "markdown"
sort file.ctime desc
limit 10
```
I switched the where clause to use "file.ext" and one '=' and it worked fine.
```dataview
table
from "Test folder"
where file.ext = "md"
sort file.ctime desc
limit 10
```
Hi John, it was an amazing video. I never tried any AI plugin yet but you made me excited to try this one. I just have some questions:
1) Before creating api key do we need to setup some payment system?
2) How much this single query cost you including the creation of assistant and then the complex query from it?
3) Will the assistant be permanently trained with that data? Can I ask that assistant any query any time later in the future as well?
4) Can I train an assistant with a pdf file?
Thank you :)
1) Yes you will need to as it is pay per use, didn't mention in the video. If you have a ChatGPT+ subscription you can just make the assistant there and it will be free
2) You can see publish.obsidian.md/johnmavrick/Create+a+Dataview+Assistant+with+AI#Pricing for the experiment I ran
3) The files are uploaded to the assistant and will stay with the assistant until you delete it.
4) Yes but I think PDFs take up more GB which can be more expensive? not sure
@@itsjohnmavrick One common misconception with ChatGPT is that all data is removed once you close off a session. It's not. If you query them enough over this they will reveal that the data from within each session, once it finishes, is stripped of personal data, and then aggregated to be fed back into the model.
That is to say All interactions that people have with AI will have an affect on it's future. Saying it forgets everything sets a dangerous precedent where people are under the impression that they can behave how ever they want cause the AI won't remember anything.
@@itsjohnmavrick Thanks for reply. I think cost is good specially for this special help. We can strategically use these query for the time we need help which is worth paying in my opinion.
Hello, I am currently on the hunt to donate to whoever can help me achieve a time sensitive task.
I need an AI service to represent my entire obsidian vault, an AI assistant that can help specifically for preparing a speech. This AI would be able to take my input, analyze it and adjust the content of the speech accordingly. It would also be able to discuss the value/contrast of new points I periodically add, via raw notes and how they fit into the overall narrative of the speech.
Would anyone be able to direct me to a source that can achieve this?
Thank you.
would the smart chat mentioned in this video be a suitable solution?
@@itsjohnmavrick Thanks for responding, I already looked into that but it does not seem to operate the same as I described, unless I am misguided in its capabilities?
@@Qwellbrock.is.a.Weirdood i reread your requirements and you are correct. i think it would be most effective if you were to create your own GPT assistant / prompt Chatgpt to help you with the script revision aspect where you ask for changes, and then just use smart connections chat or files to look for the related ideas in your vault that can help in your speech. you would then be able to just copy the contents of the note that are relevant, paste it into input into your assistant, then say your specific instructions
@@itsjohnmavrick hmm, ok, thanks for the feedback, although that does sound admittedly intimidating, I would not even know where to begin w/ such a stage. Must it be through Openai?
@@Qwellbrock.is.a.Weirdood it would be the easiest way to get it up and running and it would be ideal if you had GPT-4 for more creativity and input length. yeah i think you would have to plan out the workflow based on the limitations of the apps and then have to actually do it which would take time.