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

How to Use Relations and Rollups in Notion!
📝Get your FREE Notion templates here:
cartersurach.gumroad.com/
Hey there productive people! In today's Notion tutorial I show you how to use relations and rollups in Notion for beginners. This Notion tutorial has been highly requested so I thought I would make a video about it!
One example I show is relating a book database in Notion to a notes database. This relates a certain book to a specific set of notes for that book. I then use a rollup to show the tags of that specific note relating to the book... a bit coinfusing, right? Well, once you watch this Notion tutorial on relations and rollups, you will understand how to use them for your own Notion databases.
⌚Timestamps:
0:00 - Introduction
0:45 - Explaining Rollups and Relations for Notion
4:46 - Creating the Book Database
7:04 - Creating the Notes Database
8:33 - How to Use Relations in Notion
10:43 - How to Use Rollups in Notion
12:48 - Still Struggling?
13:48 - Example 2: How to Use Relations and Rollups in Notion
19:45 - Please Like and Subscribe :)
#RelationsandRollups #Notion

Пікірлер: 238

  • @ProductiveDude
    @ProductiveDude Жыл бұрын

    Get my Advanced Notion Workspace: hi.switchy.io/productive-brain

  • @jessicahagan
    @jessicahagan6 ай бұрын

    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

  • @erinhybartrealtor
    @erinhybartrealtor4 ай бұрын

    I am just learning to tame the Notion beast. This was helpful

  • @abinashmohanty
    @abinashmohanty Жыл бұрын

    One of the best videos on Notion series and especially I loved it how you explained the concept of roll ups and relations 👏👏

  • @GigglesForYou
    @GigglesForYou2 жыл бұрын

    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.

  • @user-us5rr9fy3o
    @user-us5rr9fy3o11 ай бұрын

    You are a great communicator and educator. Easy to follow! Thank you very much!

  • @JeffHale
    @JeffHale9 ай бұрын

    Nice job. Clear, to the point, and helpful.

  • @toddlichtenwalter2041
    @toddlichtenwalter20418 ай бұрын

    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!

  • @eusiahcruz9340
    @eusiahcruz9340 Жыл бұрын

    One of my favourite notion tutorials. Thank you

  • @moniquejackson483
    @moniquejackson4839 ай бұрын

    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!!

  • @keithhaase4681
    @keithhaase46816 ай бұрын

    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.

  • @devtechjunkie
    @devtechjunkie10 ай бұрын

    Very helpful. I recently left Evernote after more then a decade. And although I have a notion account, I was not committed to it at all. This tutorial truly helped me connect the dots with relationships and roll-ups, and pressed me toward using Notion for fully.

  • @louiseh7302
    @louiseh73022 жыл бұрын

    That was a better and more clearer way of explaining Carter. Thanks for that

  • @sussanroads42039
    @sussanroads42039 Жыл бұрын

    The best videos on KZread for Notion. The ingredients in stock/out of stock made roll ups make sense.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Yay! Glad it made sense!

  • @bharatpanigrahi
    @bharatpanigrahi Жыл бұрын

    It's great tutorial ,I have cleared all of my worries about this topic Thank you ❤️

  • @vonlivebillionaire8674
    @vonlivebillionaire86748 ай бұрын

    Man this was such a simple explanation that tied it all together for me! thanks man!!

  • @1mp3r1us
    @1mp3r1us3 ай бұрын

    Your video solved all my doubts. You're a magician man 👏

  • @user-ii8mx1er3i
    @user-ii8mx1er3i5 ай бұрын

    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.

  • @ChritsianBucic
    @ChritsianBucic9 ай бұрын

    Very helpful and clear tutorial, thank you!

  • @skmy-
    @skmy-6 ай бұрын

    Thank you for making this great, simple video!

  • @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’!

  • @budi_hartono
    @budi_hartono Жыл бұрын

    Oh man, you saved me and shorten my learning curve about Notion. From so many videos on KZread talking about Notion, only your video explains Notion straightforward and is easy to understand. Thanks!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad I could help!

  • @chotchanidp.2257
    @chotchanidp.2257 Жыл бұрын

    this vid help me a lot ! thank you

  • @user-cs5dq8tb8m
    @user-cs5dq8tb8m5 ай бұрын

    Thank you. It was really helpful.

  • @samanthagarner2926
    @samanthagarner29262 жыл бұрын

    This finally makes sense! Thank you!

  • @kymizad
    @kymizad Жыл бұрын

    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

    Жыл бұрын

    Great, I’m glad these are helping. Welcome aboard.

  • @royhernandez4438
    @royhernandez4438 Жыл бұрын

    well done! greatly break-down regarding the relations/roll-up topics.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Thanks Edit: typo

  • @dalibor-rodic
    @dalibor-rodic Жыл бұрын

    Thanks so much, man! This video is actually clearer than their official one. Liked and subbed, looking forward to more 🚀

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Good stuff!

  • @sheisrosie
    @sheisrosie Жыл бұрын

    This was the BEST explanation of relations and rollups I have seen thus far! Thank you so much!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Awesome, I am glad it helped out!

  • @meiliu1020
    @meiliu1020 Жыл бұрын

    The best explanation for database relation! Extremely articulate !Thank you !

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad it helped! Thanks for watching and commenting.

  • @eulourivalpinheiro
    @eulourivalpinheiro Жыл бұрын

    Dude, you're awesome. Thank you.

  • @EnriqueHerbella
    @EnriqueHerbella Жыл бұрын

    Amazing tutorial! Thank you!

  • @ahmadurrani
    @ahmadurrani Жыл бұрын

    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

    Жыл бұрын

    Thank you Ahmad! :)

  • @ave_smirnova

    @ave_smirnova

    Жыл бұрын

    absolutely agree

  • @kimberlyappelcline
    @kimberlyappelcline2 жыл бұрын

    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.

  • @simplyroger2763
    @simplyroger2763 Жыл бұрын

    Great examples and tutorial. TNX! Keep up the good work!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad this helped

  • @sebastianlaws5145
    @sebastianlaws514511 ай бұрын

    Great Vid. I finally got it! Cheers !

  • @ProductiveDude

    @ProductiveDude

    11 ай бұрын

    Cheers

  • @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!

  • @lilyanli350
    @lilyanli35010 ай бұрын

    This tutorial is awesome, exactly what I am looking for, thank you!

  • @ProductiveDude

    @ProductiveDude

    10 ай бұрын

    You're very welcome!

  • @MilenaHirkala
    @MilenaHirkala2 ай бұрын

    This was amazing, thank uuuu

  • @grazymendes7228
    @grazymendes7228 Жыл бұрын

    Bro, you helped me a lot, thank you

  • @parimalvala8742
    @parimalvala87422 ай бұрын

    Great Explanation... Thanks :)

  • @master_kalbei
    @master_kalbei2 ай бұрын

    this is a big help on my tasks today.. thanks for sharing...

  • @shyneray250
    @shyneray250 Жыл бұрын

    Thank you very much for this clear tutorial esp with the example of recipes and ingredients!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    You bet, I hope it helped. :)

  • @rjvidalt1
    @rjvidalt1 Жыл бұрын

    Excellent video. Very clear and concise explanation. Thanks very much

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    You bet!

  • @777truepower777
    @777truepower777 Жыл бұрын

    Excellent work!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Many thanks!

  • @Kovu2016
    @Kovu2016 Жыл бұрын

    you are the notion god🙌🙌🙌🙌🙌

  • @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.

  • @iluvsyphonfilter
    @iluvsyphonfilter Жыл бұрын

    Fantastic explanation!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Thank you for watching.

  • @mareklustyk4042
    @mareklustyk4042 Жыл бұрын

    you are such a great teacher, thx for that!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    🙏❤️

  • @ivettematos
    @ivettematos Жыл бұрын

    Thank you this video helped me understand the database system much better.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Good! :)

  • @Samanthaz233
    @Samanthaz233 Жыл бұрын

    This is a really good video. Thank you for explaining it so simply.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad to help

  • @mussen1876
    @mussen18762 ай бұрын

    Thanks for sharing.

  • @bluebarrycheescake9905
    @bluebarrycheescake9905 Жыл бұрын

    This was so helpful!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Great!

  • @TonyMosconi
    @TonyMosconi2 жыл бұрын

    Keep doing the good work! Thanks!

  • @ProductiveDude

    @ProductiveDude

    2 жыл бұрын

    You bet! Thank you.

  • @jimmy3862
    @jimmy3862 Жыл бұрын

    Perfect video! 🤩

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Cheers!!

  • @mahalifecollection
    @mahalifecollection Жыл бұрын

    Thanks! You are great teacher as well as Notion expert!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Thanks that means a lot

  • @rspeckham
    @rspeckham Жыл бұрын

    Thanks. Very clear explanation. I get it now!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad you understand!

  • @PaulTaiMusicRoom
    @PaulTaiMusicRoom2 ай бұрын

    Thanks a lot for the comprehensive explanation and clear pronunciation

  • @analara1539
    @analara1539 Жыл бұрын

    Great video!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad you enjoyed it

  • @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 🔥

  • @PurposeDrivenLiven
    @PurposeDrivenLiven Жыл бұрын

    Fire. Thank you !

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Appreciate that

  • @techiguy4188
    @techiguy41889 ай бұрын

    You are bessssst teacher ❤❤

  • @DrLazerbeam
    @DrLazerbeam Жыл бұрын

    I left a like for the first time that somebody on KZread asked to me to. That’s how useful and helpful this was

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Yay! Glad it helped!

  • @linawu1219
    @linawu1219 Жыл бұрын

    thankYou so much so useful

  • @kopihitam12333
    @kopihitam1233311 ай бұрын

    Thanks bro!

  • @christophergabble286
    @christophergabble2863 ай бұрын

    Thank you!

  • @nossahistorinha
    @nossahistorinha Жыл бұрын

    Best tutorial ever!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Thanks

  • @dcamusicstudiocopyrightfre3939
    @dcamusicstudiocopyrightfre3939 Жыл бұрын

    Many thanks for a clear and well explained video.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad it was helpful!

  • @bamber4757
    @bamber4757 Жыл бұрын

    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

    Жыл бұрын

    Ahh you explained it well! Thanks for the comment, glad this helped you.

  • @jay_seijo
    @jay_seijo5 ай бұрын

    Thanks!

  • @soakun8729
    @soakun8729Ай бұрын

    You are legend ❤

  • @Yuukii101
    @Yuukii101 Жыл бұрын

    THANK YOU

  • @TyTyHrA
    @TyTyHrA Жыл бұрын

    thank you so much

  • @ilisam
    @ilisam Жыл бұрын

    Thank you so much!!😃

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    You are so welcome! :)

  • @kataisom5115
    @kataisom51156 ай бұрын

    Thank you so much🎉🎉🎉🎉🎉

  • @udo9999
    @udo99999 ай бұрын

    thanks!

  • @tarekgalal654
    @tarekgalal654 Жыл бұрын

    Thanks alot for the wonderul explanation, took me time to figure it out until i saw ur video. So for Power Query guys, this is more like the Merge 2 queries step, followed by Expand columns step.

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Thanks for watching. I’m happy it helped.

  • @EMChannel_
    @EMChannel_9 ай бұрын

    now i understand!

  • @ayaeldakhly4067
    @ayaeldakhly4067Ай бұрын

    Thank you

  • @gulmoharsontakke3621
    @gulmoharsontakke36212 ай бұрын

    helpful video

  • @elfinsim
    @elfinsim Жыл бұрын

    It’s such a pleasure learning from you, I wish you were my college professor 😭

  • @crobinson6022
    @crobinson6022 Жыл бұрын

    Thank you this does help. I would love to know how you would then link the out of stock ingredients to a shopping list

  • @VantomChannel
    @VantomChannel Жыл бұрын

    101% Thank you a lot, sir!

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Great!!

  • @MammadAliyev
    @MammadAliyev10 ай бұрын

    finally someone explained Notion relations in clear terms

  • @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

  • @muriithimathenge2616
    @muriithimathenge2616 Жыл бұрын

    Thanks

  • @superchargecoach
    @superchargecoach Жыл бұрын

    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!!

  • @jonmcmahon90292
    @jonmcmahon90292 Жыл бұрын

    thank you please make more

  • @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.

  • @rafiashraf2769
    @rafiashraf27697 ай бұрын

    Hello, great vid. I was curious what software do you use to record your screen and front camera at the same time? Thanks

  • @juradodevoz
    @juradodevoz6 ай бұрын

    As recipe named “Chicken Dinner” shows that you cook a lot. 😅😅😅 Thank you for this useful tutorial ❤

  • @dfxdfx5368
    @dfxdfx5368 Жыл бұрын

    Hi Carter. I understood pretty well the concept well, thanks. I still have a problem, though. I set up two databases one for the authors and one for the books. I connected them throuugh relations and rolll ups and it worked, the problem is that in a column where i added 15 books only 10 are shown. If I want to see the others I have to click inside the cell. Is there a way to see them all?

  • @Inzagi-im8ol
    @Inzagi-im8ol2 ай бұрын

    Полезный урок. Спасибо

  • @narutokunn
    @narutokunnАй бұрын

    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?

  • @FredBastiat
    @FredBastiat24 күн бұрын

    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.

  • @1forme697
    @1forme697 Жыл бұрын

    Hi, Thanks for sharing all the info. I made a table and at the bottom I can show the sum of my numbers by selecting the SUM option. Or the average by selecting the AVARAGE option. I would like to import the value of this field, this sum or average in a new table. Is that possible? And of so, how can I do that? TXS Greetings.

  • @studiobae
    @studiobae2 жыл бұрын

    Thank u

  • @ProductiveDude

    @ProductiveDude

    2 жыл бұрын

    My pleasure

  • @BlazingStarEnergycom
    @BlazingStarEnergycom Жыл бұрын

    Awesome

  • @ProductiveDude

    @ProductiveDude

    Жыл бұрын

    Glad you enjoyed. Thanks for all the kind comments. I hope you’re learning all about Notion!

  • @sevenup19945678
    @sevenup19945678 Жыл бұрын

    Thanks! Quick question -- how do you sort items in the Roll-up? For example, i want the items in Alphabetical order or maybe a customized order. Is this possible?