Notion Tutorial: Relations and Rollups in Notion for Beginners! (Easy Guide)

  Рет қаралды 105,649

Productive Dude

Productive Dude

Күн бұрын

Пікірлер: 256
@ProductiveDude
@ProductiveDude Жыл бұрын
Get my Advanced Notion Workspace: hi.switchy.io/productive-brain
@jessicahagan
@jessicahagan Жыл бұрын
Finally! A tutorial that is not at lightning speed! Thank you for taking time with beginners!!
@Xistentialite
@Xistentialite Жыл бұрын
If someone had just told me that you needed BOTH of them to grab tags from other pages I could have saved so many hours! Thank you so much for explaining it in a way I could FINALLY understand 🙏🏻🙏🏻
@ProductiveDude
@ProductiveDude Жыл бұрын
Cheers!!
@jonmcmahon90292
@jonmcmahon90292 Жыл бұрын
@@ProductiveDude ditto
@TonyMosconi
@TonyMosconi 2 жыл бұрын
Keep doing the good work! Thanks!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
You bet! Thank you.
@erinhybartrealtor
@erinhybartrealtor 10 ай бұрын
I am just learning to tame the Notion beast. This was helpful
@ahmadurrani
@ahmadurrani 2 жыл бұрын
you have the best videos about Notion. you always go in detailed explanations and follow it with live tutorials. no other creator comes even close to how well you break it all down. thank you!!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Thank you Ahmad! :)
@ave_smirnova
@ave_smirnova Жыл бұрын
absolutely agree
@sussanroads42039
@sussanroads42039 2 жыл бұрын
The best videos on KZbin for Notion. The ingredients in stock/out of stock made roll ups make sense.
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Yay! Glad it made sense!
@sheisrosie
@sheisrosie 2 жыл бұрын
This was the BEST explanation of relations and rollups I have seen thus far! Thank you so much!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Awesome, I am glad it helped out!
@jay_seijo
@jay_seijo 11 ай бұрын
Thanks!
@mariarasquiño
@mariarasquiño Жыл бұрын
As recipe named “Chicken Dinner” shows that you cook a lot. 😅😅😅 Thank you for this useful tutorial ❤
@SuzanneDonofrio
@SuzanneDonofrio Жыл бұрын
You are a great communicator and educator. Easy to follow! Thank you very much!
@KeepinItReal632
@KeepinItReal632 Жыл бұрын
By far the best video I’ve seen explaining relations and rollups! Thank you for thorough examples. The ingredients and recipes example was extremely helpful! Thank you so much!!
@ProductiveDude
@ProductiveDude Жыл бұрын
Cheers’!
@JeffHale
@JeffHale Жыл бұрын
Nice job. Clear, to the point, and helpful.
@abinashmohanty
@abinashmohanty 2 жыл бұрын
One of the best videos on Notion series and especially I loved it how you explained the concept of roll ups and relations 👏👏
@toddlichtenwalter2041
@toddlichtenwalter2041 Жыл бұрын
You are a great teacher. I have watched other videos but finally someone who knows how to teach! Instead of flying through at warp speed, your pacing allows for side by side practice and clarity. Bravo! and THANK YOU!
@keithhaase4681
@keithhaase4681 Жыл бұрын
Kudos -- by starting an example of very simple and easy example you're making it easy to learn and eventually learn more complicated aspects of the subject. Again, good work.
@JeetalShah
@JeetalShah 11 ай бұрын
This was the use case I was looking for and just didn't know how to do it in Notion. Thank you so much for this tutorial, it was super helpful.
@lscanlon9908
@lscanlon9908 Жыл бұрын
THANK YOU. I have my projects and tasks databases linked, but I wanted tasks to automatically take the category of their associated project. I didn't realize that rollups were the ticket until I watched this. I'm definitely subscribing.
@ProductiveDude
@ProductiveDude Жыл бұрын
Glad this made that clear for you. It was something that I got hung up on as well. It’s confusing at first but I’m glad you figured it out.
@bamber4757
@bamber4757 2 жыл бұрын
Ahhhhh! I see. The roll up is just a piece of information from one database that you can pull from when your in another thanks to the relation between the two original datapoints. Establishing the relationship between the two databases gives you access to the other properties for both- like a merging of families. I got it. Be happy to explain the analogy for anyone. 🙂 Genius! I needed to see the picture example for it to register. I understand now.
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Ahh you explained it well! Thanks for the comment, glad this helped you.
@eusiahcruz9340
@eusiahcruz9340 Жыл бұрын
One of my favourite notion tutorials. Thank you
@vonlivebillionaire8674
@vonlivebillionaire8674 Жыл бұрын
Man this was such a simple explanation that tied it all together for me! thanks man!!
@robfuzz
@robfuzz Жыл бұрын
This was SO helpful and so clear. Thank you for making such an understandable tutorial. Better than the one Notion made.
@ProductiveDude
@ProductiveDude Жыл бұрын
You're very welcome!
@GigglesForYou
@GigglesForYou 2 жыл бұрын
Great tutorial. I had used Notion and am returning to it to create a productivity system for work and home. This was a great refresher and I learned some new concepts.
@vijeshnair1491
@vijeshnair1491 3 ай бұрын
Loved it Man! You explained this so simply and effectively. I usually never comment under videos, but the way you explained so effortlessly made me come down here and thankyou. Keep making such videos mate❤✨
@ProductiveDude
@ProductiveDude 3 ай бұрын
This is what keeps me going. Thank you.
@meiliu1020
@meiliu1020 2 жыл бұрын
The best explanation for database relation! Extremely articulate !Thank you !
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Glad it helped! Thanks for watching and commenting.
@moniquejackson483
@moniquejackson483 Жыл бұрын
Thank you so much for this video, I have been struggling with getting tables to show in a master calendar using various properties. Thanks for the step by step, super helpful!!
@louiseh7302
@louiseh7302 2 жыл бұрын
That was a better and more clearer way of explaining Carter. Thanks for that
@mareklustyk4042
@mareklustyk4042 Жыл бұрын
you are such a great teacher, thx for that!
@ProductiveDude
@ProductiveDude Жыл бұрын
🙏❤️
@MammadAliyev
@MammadAliyev Жыл бұрын
finally someone explained Notion relations in clear terms
@1mp3r1us
@1mp3r1us 10 ай бұрын
Your video solved all my doubts. You're a magician man 👏
@Kovu2016
@Kovu2016 Жыл бұрын
you are the notion god🙌🙌🙌🙌🙌
@lilyanli350
@lilyanli350 Жыл бұрын
This tutorial is awesome, exactly what I am looking for, thank you!
@ProductiveDude
@ProductiveDude Жыл бұрын
You're very welcome!
@antiquelady60
@antiquelady60 5 ай бұрын
Exactly what I was looking for. Thank you!
@marchershman1075
@marchershman1075 Жыл бұрын
🎯 Key Takeaways for quick navigation: 00:00 📝 Introduction to Notion Relations and Rollups 04:50 📋 Creating Databases in Notion 12:54 🧩 Connecting Databases with Relations and Rollups 16:07 🍽️ Another Example: Recipes and Ingredients Made with HARPA AI
@ivettematos
@ivettematos Жыл бұрын
Thank you this video helped me understand the database system much better.
@ProductiveDude
@ProductiveDude Жыл бұрын
Good! :)
@thenextrobertfry
@thenextrobertfry Жыл бұрын
Why create another whole database just for the book's notes that you then have to connect, when you could just take notes on each book in its own page? I mean, I can see the necessity of having a separate notes database for other types of notes, but seems to me that a book's notes should be taken right on a book's page. I'm wondering if there's a good reason for it that I'm not thinkin about, or just a preference for having ALL notes in the same place. Forgive me if the answer is here and I missed it or in another video in the playlist. I love your videos and examples. Clear and concise and of all the Notion systems I've tooled around with, yours looks and feels like the best fit for me overall.
@royhernandez4438
@royhernandez4438 Жыл бұрын
well done! greatly break-down regarding the relations/roll-up topics.
@ProductiveDude
@ProductiveDude Жыл бұрын
Thanks Edit: typo
@ptmy47
@ptmy47 9 ай бұрын
Thanks a lot for the comprehensive explanation and clear pronunciation
@ChritsianBucic
@ChritsianBucic Жыл бұрын
Very helpful and clear tutorial, thank you!
@master_kalbei
@master_kalbei 8 ай бұрын
this is a big help on my tasks today.. thanks for sharing...
@simplyroger2763
@simplyroger2763 2 жыл бұрын
Great examples and tutorial. TNX! Keep up the good work!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Glad this helped
@nicholasng1596
@nicholasng1596 Жыл бұрын
Thank you for sharing this. Notion should use this video as a reference on learning relations & rollups. I never write comments but the usefulness of this video would make me an ass not too 😂 you’ve earned my sub!
@ProductiveDude
@ProductiveDude Жыл бұрын
Appreciate that
@rjvidalt1
@rjvidalt1 2 жыл бұрын
Excellent video. Very clear and concise explanation. Thanks very much
@ProductiveDude
@ProductiveDude 2 жыл бұрын
You bet!
@thereal_phila
@thereal_phila Жыл бұрын
Bro it's my first day on Notion and I feel like I'm well versed with it, amazing work!!!🔥🔥
@ProductiveDude
@ProductiveDude Жыл бұрын
Thanks 🔥
@shyneray250
@shyneray250 2 жыл бұрын
Thank you very much for this clear tutorial esp with the example of recipes and ingredients!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
You bet, I hope it helped. :)
@budi_hartono
@budi_hartono Жыл бұрын
Oh man, you saved me and shorten my learning curve about Notion. From so many videos on KZbin talking about Notion, only your video explains Notion straightforward and is easy to understand. Thanks!
@ProductiveDude
@ProductiveDude Жыл бұрын
Glad I could help!
@letstrytobekind
@letstrytobekind 2 жыл бұрын
This was very useful! Thank you for making this additional, very focused video. I'm using Notion to track my Korean studies, and based on what you've shown here, I'm going to experiment with linking grammar points discussed in specific class sessions to my general grammar point database, and specific class deadlines and meeting times to a general calendar database. You only showed linking two databases in this video, but from what you showed it looked like I should be able to link (for example), grammar points from three different classes to my grammar point database, or deadlines from all my different separate class databases to my overall calendar database. I'm looking forward to experimenting with what you taught me here, so thank you again!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
I'm happy to hear that you found a good use case and that this is finally clicking for you.
@malcod3404
@malcod3404 Жыл бұрын
Hi! In 18:30, Is there a way how to filter only the Ingredients that are In Stock? I'm trying to figure it out and not being successful so far. Thank you for the video!
@AceCreud
@AceCreud 10 ай бұрын
19:32 How to percentage the Status column such as you have 1 out of 3 ingredients not In Stock so you have 66% ingredients availability?
@iluvsyphonfilter
@iluvsyphonfilter 2 жыл бұрын
Fantastic explanation!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Thank you for watching.
@Samanthaz233
@Samanthaz233 Жыл бұрын
This is a really good video. Thank you for explaining it so simply.
@ProductiveDude
@ProductiveDude Жыл бұрын
Glad to help
@elfinsim
@elfinsim 2 жыл бұрын
It’s such a pleasure learning from you, I wish you were my college professor 😭
@mahalifecollection
@mahalifecollection 2 жыл бұрын
Thanks! You are great teacher as well as Notion expert!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Thanks that means a lot
@kymizad
@kymizad 2 жыл бұрын
Very useful information! I just started using Notion a couple of days ago, and your explanations are very easy to understand. Subscribed & liked! ☺️
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Great, I’m glad these are helping. Welcome aboard.
@grazymendes7228
@grazymendes7228 Жыл бұрын
Bro, you helped me a lot, thank you
@ltpneto
@ltpneto Жыл бұрын
Dude, you're awesome. Thank you.
@MindfulDevLab
@MindfulDevLab 5 ай бұрын
Thanks bro the video was super helpful
@雷衍
@雷衍 4 ай бұрын
So much clear!
@777truepower777
@777truepower777 2 жыл бұрын
Excellent work!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Many thanks!
@bluebarrycheescake9905
@bluebarrycheescake9905 Жыл бұрын
This was so helpful!
@ProductiveDude
@ProductiveDude Жыл бұрын
Great!
@sebastianlaws5145
@sebastianlaws5145 Жыл бұрын
Great Vid. I finally got it! Cheers !
@ProductiveDude
@ProductiveDude Жыл бұрын
Cheers
@mussen1876
@mussen1876 8 ай бұрын
Thanks for sharing.
@rspeckham
@rspeckham 2 жыл бұрын
Thanks. Very clear explanation. I get it now!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Glad you understand!
@Morgarias
@Morgarias 2 жыл бұрын
this vid help me a lot ! thank you
@techiguy4188
@techiguy4188 Жыл бұрын
You are bessssst teacher ❤❤
@parimalvala8742
@parimalvala8742 8 ай бұрын
Great Explanation... Thanks :)
@EnriqueHerbella
@EnriqueHerbella Жыл бұрын
Amazing tutorial! Thank you!
@dalibor-rodic
@dalibor-rodic 2 жыл бұрын
Thanks so much, man! This video is actually clearer than their official one. Liked and subbed, looking forward to more 🚀
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Good stuff!
@narutokunn
@narutokunn 7 ай бұрын
Great tutorial. I have been using notion since over a year but still didn't know what relations and rollups were, until now. Thanks. Relations didn't solve the purpose I thought they would though. I have a expense tracker db in which I create a view every month (filter of expenses in that month). I was wondering if it was possible to get the total expense for every month (sum of a column) in a central DB so I can see monthly expenses in a consolidated view. Can you point me to a video of yours which can help me learn do this?
@sami0_0-0
@sami0_0-0 Жыл бұрын
Thank you. It was really helpful.
@bharatpanigrahi
@bharatpanigrahi 2 жыл бұрын
It's great tutorial ,I have cleared all of my worries about this topic Thank you ❤️
@timerwentoff
@timerwentoff Жыл бұрын
Very informative tutorials which has clarified 'Relations' and 'Rollups' for me. Couldn't understand it through Notion's Guidance, which doesn't want to use the Database terminology in its tutorials. However, when we start using /creating multiple databases, the concepts of keys, joins, views, and normalization come into play. In my opinion, these concepts should be explained. Otherwise, casual users will end up creating many inefficient databases.
@FredBastiat
@FredBastiat 7 ай бұрын
Less than 5 minutes into the video and already a very clear graphic--that nobody else has explained--which may be the source of my problems.
@dcamusicstudiocopyrightfre3939
@dcamusicstudiocopyrightfre3939 2 жыл бұрын
Many thanks for a clear and well explained video.
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Glad it was helpful!
@superchargecoach
@superchargecoach 2 жыл бұрын
Thank you for these tips! If I wanted to make a shopping list with the out of stock ingredients, would I create a database called shopping list, or how would I do that? Thanks!!
@samanthagarner2926
@samanthagarner2926 2 жыл бұрын
This finally makes sense! Thank you!
@me6100
@me6100 5 ай бұрын
Hi! Thanks for the video, it was super helpful. Is it possible to search the info using the keywords from another database? for example, if I want to have a list of all the characters mentioned in the book but I don't want to clutter my first databse with this information. Just in case I remember the name of the character but happen to forget where they were mentioned
@alanhill6852
@alanhill6852 Жыл бұрын
Thank you. Do you do private instruction classes?
@ProductiveDude
@ProductiveDude Жыл бұрын
Yes, if you'd like to you can book here: timesync.novocall.co/carter-surach/consult
@rafiashraf2769
@rafiashraf2769 Жыл бұрын
Hello, great vid. I was curious what software do you use to record your screen and front camera at the same time? Thanks
@jimmyni1983
@jimmyni1983 Жыл бұрын
Perfect video! 🤩
@ProductiveDude
@ProductiveDude Жыл бұрын
Cheers!!
@MilenaHirkala
@MilenaHirkala 9 ай бұрын
This was amazing, thank uuuu
@dreamfaller6372
@dreamfaller6372 3 ай бұрын
Very helpful, thank you!
@crobinson6022
@crobinson6022 2 жыл бұрын
Thank you this does help. I would love to know how you would then link the out of stock ingredients to a shopping list
@vikenio
@vikenio 11 ай бұрын
Thanks! My problem is that I want to see and be able to select in the Relation colmun another field that is not the column defined as "Title" in the related DB. How can I do this? Thanks
@ColleenSchake
@ColleenSchake 10 ай бұрын
It was semi-helpful. I'm trying to create a Dinner Party planner and I think I have the recipes and all thanks to this, but I want to create a guest list only using the Main person's name in the list with say Ja's family. Then I want to add his family. Do I need to add them all to a say "contacts" list and create a relation to the contacts? I'd like them to auto-fill If I put Jay & Family in the names list. Or should I just create tags? There are times I may just want say 3 of 5 selected from his family if it's an adult party. Or Say I invite certain families to say Easter dinner. I'd then add Jay & Family but need the total number of ppl attending. (not all will attend) I'd like to just select the guests via the tags in this case. But how do I get these to show auto? The same for recipes. I choose certain recipies for Easter meal, and want the main, sides, drinks and deserts to auto fill, with the recipies related to as well as the ingredients related to a shopping list or auto fill the shopping list.
@ilisam
@ilisam 2 жыл бұрын
Thank you so much!!😃
@ProductiveDude
@ProductiveDude 2 жыл бұрын
You are so welcome! :)
@analara1539
@analara1539 2 жыл бұрын
Great video!
@ProductiveDude
@ProductiveDude 2 жыл бұрын
Glad you enjoyed it
@nossahistorinha
@nossahistorinha Жыл бұрын
Best tutorial ever!
@ProductiveDude
@ProductiveDude Жыл бұрын
Thanks
@Mohammedbasim
@Mohammedbasim Жыл бұрын
Hi, is there any way to show a databases column sum as a property of another database. For example "vehicle" is a database with a page named cars in its first row. Inside this cars page there is another database which shows "types of cars" and it's price. Now in the "vehicle" database, i want to show the total price of all the cars from the " types of cars" database as a property. Please note: the next row in "vehicle" database would be truck which should show the total price of all the trucks from "the types of truck" database
@NonthapatSrikumnoi
@NonthapatSrikumnoi 10 ай бұрын
🎯 Key Takeaways for quick navigation: Understanding relations and roll-ups in Notion is essential for leveraging its database capabilities efficiently. Relations connect rows within or across different databases, allowing for efficient data organization. Rollups aggregate information from related databases, enhancing data visibility and analysis. Demonstrating the setup process, including creating databases, defining properties, and establishing relations, clarifies the practical application of these concepts. Examples, such as connecting books to notes or recipes to ingredients, illustrate real-world scenarios for utilizing relations and roll-ups effectively. Made with HARPA AI
@robertogejman5311
@robertogejman5311 11 ай бұрын
Many thanks Carter! I am trying to build a people or genealogy database. So I need a self referenced database, which is fine by Notion. However when I add a "Father" and a "Mother" relationship to the database, and start to populate it, Notion starts to show the children names automatically. Not only that. In the row for a given person, the father property shows the father AND the children of that person in the same cell. I have tried both relation styles to no avail. Can you advise how to solve this problem? many thanks.
@Tpc83
@Tpc83 Жыл бұрын
Very good! Help me create an alert in the Recepies that advise to "ingredient missing"?
@ProductiveDude
@ProductiveDude Жыл бұрын
What would the “ingredient missing” be based on?
@Tpc83
@Tpc83 Жыл бұрын
​@@ProductiveDudeFor example: when I don't do a task (sleep well, for example). The Failure to complete this task makes notion warn me that I should not move on to the next task or task X.
@ProductiveDude
@ProductiveDude Жыл бұрын
@@Tpc83 this is a pretty complex setup would require multiple formulas.
@rajibsahoo4279
@rajibsahoo4279 2 жыл бұрын
How to populate all roll-up properties from another database as main database properties at once ?
@soakun8729
@soakun8729 7 ай бұрын
You are legend ❤
@radar1437
@radar1437 Жыл бұрын
what was the software use use to explain with slides , i think it is not powerpoint you use .
@kataisom5115
@kataisom5115 Жыл бұрын
Thank you so much🎉🎉🎉🎉🎉
@jack2media
@jack2media Жыл бұрын
Ive created 4x "teamspaces" all of which have their own to do lists inside some pages. How do I create or view a master list with all of them as when it comes to building relation data bases you can only relate it back to 1 data base at a time, therefore you have to have create seperate tabs each time.
@avimehenwal
@avimehenwal 23 күн бұрын
Is it possible to rollup a realtion in page content instead of Properties ? I want to have a page for all weekly meetings. Which means 1 page with have 7 sections / week. How can I achieve such setup in notion ?
@trina2100
@trina2100 8 ай бұрын
Thanks this was very helpful. I like being able to see what's in stock but don't want each recipe to have that long list of ingredients in it. Is there a way to hide that column? I actually think I see a use case the other way around. Let's say you have some weird ingredient you purchased for a recipe and it's about to expire, it would be helpful to go to the ingredient list and see a list of any and all recipes that include that ingredient so you can use it up. IDK, maybe.
@anthonyphoebe
@anthonyphoebe 10 күн бұрын
thank you very much for this. It has broadened my understanding. but why did you remove the tags in the second tutorial. Would it affect anything if it is not deleted
@ProductiveDude
@ProductiveDude 10 күн бұрын
No it wouldn't affect anything, I just deleted it for simplicities sake, as it wasn't required for the example.
@ProductiveDude
@ProductiveDude 10 күн бұрын
Thank you for the kind words. I'm glad it helped.
49 Essential Tips for Notion in 2023!
49:25
Productive Dude
Рет қаралды 743 М.
Notion Databases: Full Guide for Beginners (2023 Notion Tutorial)
1:18:25
Productive Dude
Рет қаралды 213 М.
Air Sigma Girl #sigma
0:32
Jin and Hattie
Рет қаралды 45 МЛН
How I Merge Notion Databases: A Master Calendar Use-Case
13:28
Red Gregory
Рет қаралды 216 М.
Relations & Rollups in Notion for Beginners [Easy Guide]
18:45
Creative Cove
Рет қаралды 14 М.
My Second Brain in Notion - Full Setup
14:38
Elizabeth Filips
Рет қаралды 848 М.
How to use Related Databases in Notion for Tasks
23:57
Josh Redd - Notion Pro
Рет қаралды 10 М.
How to Use Notion Formulas 2.0 Like a Pro
22:23
Kat Waugh
Рет қаралды 15 М.
Notion App Tutorial: 10 Tips To Improve Your Notes in Notion for 2022!
25:21
Become a Notion pro in 20min! (Full Notion Guide)
20:39
Chris's Notion
Рет қаралды 937 М.
Notion Master Tag Database | The BEST Way To Organize Your Notes
12:50
Daniel Langewisch
Рет қаралды 43 М.
31 Notion Updates & Features Added in 2022! [Notion Tutorial]
32:38
Productive Dude
Рет қаралды 63 М.
Air Sigma Girl #sigma
0:32
Jin and Hattie
Рет қаралды 45 МЛН