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 🙏🏻🙏🏻
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!!
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!
🎯 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
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!!
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.
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.
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.
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❤✨
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.
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!!
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!
Oh man, you saved me and shorten my learning curve about Notion. From so many videos on TH-cam talking about Notion, only your video explains Notion straightforward and is easy to understand. Thanks!
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!
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!
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.
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.
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!!
@@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.
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?
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
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
Question: I am just getting started with Notion and think I’ll love it. Biggest issue is I am trying to use PARA from Second Brain. Is there a way to create different databases within PARA and connect them all to one main database that can keep all the info as well as something like a “file cabinet”?
Yes you could create a database called “folders” or “categories”. Then create pages within it that are your categories. (Each page is one category) Then relate those pages in the categories database to whatever pages you want. From there you can sort based on category.
Get my Advanced Notion Workspace:
hi.switchy.io/productive-brain
Finally! A tutorial that is not at lightning speed! Thank you for taking time with beginners!!
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 🙏🏻🙏🏻
Cheers!!
@@ProductiveDude ditto
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!!
Thank you Ahmad! :)
absolutely agree
I am just learning to tame the Notion beast. This was helpful
The best videos on TH-cam for Notion. The ingredients in stock/out of stock made roll ups make sense.
Yay! Glad it made sense!
Keep doing the good work! Thanks!
You bet! Thank you.
This was the BEST explanation of relations and rollups I have seen thus far! Thank you so much!
Awesome, I am glad it helped out!
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!
You are a great communicator and educator. Easy to follow! Thank you very much!
🎯 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
One of the best videos on Notion series and especially I loved it how you explained the concept of roll ups and relations 👏👏
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!!
Cheers’!
I left a like for the first time that somebody on TH-cam asked to me to. That’s how useful and helpful this was
Yay! Glad it helped!
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.
Nice job. Clear, to the point, and helpful.
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.
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.
One of my favourite notion tutorials. Thank you
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.
Ahh you explained it well!
Thanks for the comment, glad this helped you.
Man this was such a simple explanation that tied it all together for me! thanks man!!
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❤✨
This is what keeps me going. Thank you.
That was a better and more clearer way of explaining Carter. Thanks for that
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.
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.
This was SO helpful and so clear. Thank you for making such an understandable tutorial. Better than the one Notion made.
You're very welcome!
Thanks!
The best explanation for database relation! Extremely articulate !Thank you !
Glad it helped! Thanks for watching and commenting.
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!!
Your video solved all my doubts. You're a magician man 👏
Thanks a lot for the comprehensive explanation and clear pronunciation
finally someone explained Notion relations in clear terms
Exactly what I was looking for. Thank you!
Thank you this video helped me understand the database system much better.
Good! :)
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!
I'm happy to hear that you found a good use case and that this is finally clicking for you.
this is a big help on my tasks today.. thanks for sharing...
Very helpful and clear tutorial, thank you!
This tutorial is awesome, exactly what I am looking for, thank you!
You're very welcome!
you are such a great teacher, thx for that!
🙏❤️
As recipe named “Chicken Dinner” shows that you cook a lot. 😅😅😅 Thank you for this useful tutorial ❤
Thank you very much for this clear tutorial esp with the example of recipes and ingredients!
You bet, I hope it helped. :)
Oh man, you saved me and shorten my learning curve about Notion. From so many videos on TH-cam talking about Notion, only your video explains Notion straightforward and is easy to understand. Thanks!
Glad I could help!
well done! greatly break-down regarding the relations/roll-up topics.
Thanks
Edit: typo
Excellent video. Very clear and concise explanation. Thanks very much
You bet!
It’s such a pleasure learning from you, I wish you were my college professor 😭
Bro it's my first day on Notion and I feel like I'm well versed with it, amazing work!!!🔥🔥
Thanks 🔥
Great examples and tutorial. TNX! Keep up the good work!
Glad this helped
This is a really good video. Thank you for explaining it so simply.
Glad to help
Thanks! You are great teacher as well as Notion expert!
Thanks that means a lot
you are the notion god🙌🙌🙌🙌🙌
Very useful information! I just started using Notion a couple of days ago, and your explanations are very easy to understand. Subscribed & liked! ☺️
Great, I’m glad these are helping. Welcome aboard.
It's great tutorial ,I have cleared all of my worries about this topic
Thank you ❤️
Bro, you helped me a lot, thank you
Fantastic explanation!
Thank you for watching.
Many thanks for a clear and well explained video.
Glad it was helpful!
Dude, you're awesome. Thank you.
Thanks. Very clear explanation. I get it now!
Glad you understand!
Thanks bro the video was super helpful
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!
Appreciate that
Thank you. It was really helpful.
So much clear!
Thank you this does help. I would love to know how you would then link the out of stock ingredients to a shopping list
Thanks for sharing.
Amazing tutorial! Thank you!
This finally makes sense! Thank you!
Excellent work!
Many thanks!
Thanks so much, man! This video is actually clearer than their official one. Liked and subbed, looking forward to more 🚀
Good stuff!
This was so helpful!
Great!
Great Vid. I finally got it!
Cheers !
Cheers
You are bessssst teacher ❤❤
this vid help me a lot ! thank you
Very helpful, thank you!
Great Explanation... Thanks :)
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!
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.
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.
Perfect video! 🤩
Cheers!!
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!!
Thank you. Do you do private instruction classes?
Yes, if you'd like to you can book here:
timesync.novocall.co/carter-surach/consult
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.
Thank you so much!!😃
You are so welcome! :)
This was amazing, thank uuuu
Best tutorial ever!
Thanks
Hello, great vid. I was curious what software do you use to record your screen and front camera at the same time? Thanks
Great video!
Glad you enjoyed it
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?
Very good! Help me create an alert in the Recepies that advise to "ingredient missing"?
What would the “ingredient missing” be based on?
@@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.
@@Tpc83 this is a pretty complex setup would require multiple formulas.
You are legend ❤
Thank you so much🎉🎉🎉🎉🎉
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?
Thank you!
thankYou so much so useful
Thanks bro!
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
thank you so much
Fire. Thank you !
Appreciate that
THANK YOU
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
Question: I am just getting started with Notion and think I’ll love it. Biggest issue is I am trying to use PARA from Second Brain. Is there a way to create different databases within PARA and connect them all to one main database that can keep all the info as well as something like a “file cabinet”?
Yes you could create a database called “folders” or “categories”.
Then create pages within it that are your categories. (Each page is one category)
Then relate those pages in the categories database to whatever pages you want. From there you can sort based on category.
@@ProductiveDude Thank you!
Thank you
Relations connects 2 rows. Rollup brings up other properties from DB2 to DB1.
You can't have a Rollup with out a Relation.
Thank you!