How to Create Your First Relational Database in Notion

How to Create Your First Relational Database in Notion

Hey guys and welcome back to another video today’s video as mentioned we’re talking a lot about relational databases We’re going to be working on a problem that I’m suffering from and hopefully fix it with relational database site Hi, I’d like sort of touched on it in one of the previous videos I did But I didn’t really go into detail and this week. I might actually have been sitting down and Learning about more about how I could adopt it So hopefully this video can be applicable to you and shows a few of the features that the database is uses So go it’s just full we dive in I’ve got a list in front of me of the five winners of the 50 cake giveaway The fifth cake giveaway was with lots of prizes and it was just a appreciation of you guys for reaching 50k subscribers on this YouTube channel, so thank you very much and here are the winners So the first winner will be gadget gal Second winner is Dmitry chimera this I’m gonna butcher people’s names here next third winner is Kay mark, NYX Orman and also Sebastian telo and Also Christian Maggie Loman. I’m really sorry if I ruined anyone’s names there you guys are winners So I will messaging separately for winning that big bundle of prizes for 50k we’ll do another giveaway at probably 100k so maybe Sometime later next year also be doing giveaways blended with other videos, so do not worry So as I mentioned guys today’s video we’re diving into Notion relationship databases. I am fixing a specific problem with my workouts Experience I want to be able to tally workouts but have them in a more responsive manner in my health dashboard So hopefully this video gives you full outline. So let’s jump over to the Mac So guys in the last notion video, what we did is we looked into my workout routine and health dashboard Slowly at the end of the video talking a little bit about relational databases. Now, what I want to do in this video is explain how to create a relational database and how it can be useful in an everyday routine or a Project that you may be working on So in this demonstration, I’ll be taking my health dashboard Which is available here talk briefly about it before what I was doing with it So previously what with it is a and a new tally for the day all I didn’t sleep time Meditation whether I did it or not Also a doubt what I workout I did and also how much time that is a food rating And also how much time I spent on audible now, I do this pretty infrequently. So Maybe every two days roughly and I’ve started this start of November Although deleted some past dates now the real idea of this is to make it almost a tally of how I can improve like giving a me a sleep medium time so that I can really try and improve on the hours of sleep I get and also the meditation being able to track how many times done meditation but primarily I want it to be a place where I can tally my workouts and my food so previously what I did with my workouts is I created a Relational database a property type here so I can just go to this one and click relational basically This is connected up with a database that I had previously called workout log and workout log if we go back to the home and you can find it over and bottom right was essentially me plotting out on a Database calendar all of the dates and times that I did my workout So for example last week last Tuesday, for example, I did a boxing and core workout that took me 30 minutes and I usually just plot them here and then use I recently started to use the relational calendar or sorry the relational database Property type inside of here to link them up and then do a look look up here or a rollup Sorry to be able to count how much time spent So what I want to do in this video is actually change the way I do that I want to create a new database that tallies the workouts that I do The types of workouts so that I don’t have to associate these two dates so for example whenever I was finding one of these I would go in and I’d have to search for the date that I did it on say for example, in this case. It was a 23rd I’d have to look. Okay, where’s the 23rd of November? I think I did on 23rd of November should be around here in this case it oh, there it is Workout a and I press plus and it adds it to it and then it imports the 30-minute timer So what I want to do is I want to create a relational database from scratch show you how to import it So what we’re going to do is delete these properties here and we’re going to create them from scratch So let’s dive over to the the workouts area. So I’m going to click workout routine So this is the area where I store my workout routines at the moment And the goal is to basically now have a list of workout routines that I can go and implement These are something that I was playing around last night. So I’m gonna get rid of a few of these I’m going to drag them onto here because these are not benchmarks, but they’re like Challenges that I want to do so I can do that separately in the future so I can say here workout menu a Workout menu. Here we go So I’ve got the pool strength workout, which is this one here so I can if I’ve got this one inside of here So if I open it up and check that it’s in there Then I can get rid of this down here and I’ll do the same for these two up here so these are two other simple workouts that I’ve got here version work out a and Workout B and they’re really simple like blend of cardio and core So you’re probably wondering here Why do you need these in some sort of workout menu and will their recently added? workouts that I’ve started use use inside of notion and the reason why I use them so much is that I press pretty much press open when I’m in the gym and Follow the step by step. So for example do a deadlift do a bent over row and I can follow that Very to the point and it’s quite a good way and maybe able to keep track of everything So in this case, I’m just gonna give this one a quick icon Let’s just put the bike because I guess is some spin bike in there and I’m gonna put the time taken is normally around around 2025 minutes let’s say and it’s also like more focused on Core than it is. Let’s say upper. So I’m going to go and do this one for what heartbeat. Ooh Okay, so there we go I’ve pretty much got the workouts and laid out and maybe I can get rid of that and just call it pull strength But you can see here. I’ve basically got the name of the workout I’ve got the time taken for each workout the type of body area it covers and essentially that’s going to be my workout menu now The goal behind this is that I can have almost a menu that I could go into follow as I’m at the gym And be able to tally which ones I did so previously as I mentioned I pretty much just handed them in here I’m not going to be doing that now, so I don’t really need this one anymore What I’m going to be doing is adding this as a relational database inside of the health dashboard So there’s mentioned that was a table inside of the workouts area. So what I’m going to do is Impala m– and I’m gonna call it workouts and I’m gonna drag it over to here because that’s where I originally Had it just in between meditation and food. Now, I’m gonna go down here and change the property type to relation It’s going to ask me what database I should bring in So I’m going to type in menu, which is was titled app and create relation. So now basically it’s linked up So essentially if I’m like, okay, I need to tally that I did core. I believe I did core in that day I can go down here and see all of different Workouts that I’ve got up my options and the wizard time taken in tanks as well So I’m gonna say I did a little bit of boxing. I think I did No I actually did work out a that day and if I press ENTER You can see that workout eight appears here. Now. The real magic is where I want to start tallying up the amount of workout time that I have So let’s say here a property type I go to roll up and I’ll make this a little bit smaller Because there’s only just a quick number I’m going to relate it to the workout area because at the moment, that’s the only existing relationship here I’m going to choose the time taken tag And what I’m going to do here is I’m gonna use some which I’m going to come back to in a bit later on in this video, for example, if I did two types of workouts in if I did a boxing one two what I could do is I just add that one to there and as you can see boxing and workout here and the sum of all both of those workouts appear together So I’ve got both boxing and workout a tally to sixty minutes of time now What I might want to do is well is be able to add a separate column of just a very simple How much walking time I had during the day I’ve got a separate field here called walk time now Basically, what I want to do is not adding the amount of time I spend walking so that could be 12 minutes that day And let’s just set to twelve minutes a day just so that if I go on a walk I can be able to tell you that – Now this is where the formula magic comes in. I’m gonna type in and total Fitness time and I’m gonna give that one a property type of Formula so formula, this will be able to hopefully tally up all of the most important information here So what I’m gonna do is gonna press ENTER and this appears at the top right now What something I want to state is I don’t actually I’m not a master in formulas and I’m actually learning them I was learning them a bit over the weekend But only to the point where I’m going to demonstrate this I will be doing more videos on this so do stay tuned for it so what I’m gonna do here is I’m going to choose the workout time because that’s where the roll up appears and then I’m going to go and hit plus and then add walk time what I’m gonna click then is done and you can see here that a simple formula has been able to Work whatever I do and change inside of here. So let’s say I didn’t do boxing it can Automatically change the time at the fitness time that I’ve done so far So it’s quite a neat way of being able to bring everything together. So maybe I need to change that into total fitness time TFT and drag that down so I can see a nice indication of Let me just neaten these up. I Can see a nice indication really clearly of how much time I’ve done during the day so I can start from today and actually Click that on there and I can be like, okay, I slept it’s in essence eight hours Which is pretty good didn’t meditate this morning? and when I do a workout could start to begin to tally all of that when I do a walk I can do all of That and that’s a nice way to be able to use the formula now Hopefully that made sense as you can imagine it takes them at a time one thing I want to do in the future is play around a little bit more with formulas because once I learn How does it ruin false staff and more detailed stuff? I could potentially have a good go of it And when notion lisa’s api, I think that’s when it’s going to get proper exciting And we guys hopefully I give you a nice introduction to the relational databases science stuff It’s really easy relational database can connect with any of the databases whether it’s a table with its calendar Inside of your notion account and it’s really easy to get going once you get going. So just have a play around with it That’s my recommendation see where it can really connect with your daily routine What I would say is use it like a menu initially like here I’ll be able to see all of the different Types of stuff I’ve done so far And I can pick out and add it to it versus necessarily you know like whether you’re sort of Versus versus necessarily having unique setups like I did have befall is unique values in there something there That would be a recommendation from me and every guy is a big Thank you for stopping by and today hopefully in a few weeks you’ll be to see this fully populated. But without further ado guys Thank you very much for stopping by today a little short message to finalize everything

Danny Hutson

24 thoughts on “How to Create Your First Relational Database in Notion

  1. Thank you for explaining this! You could also include tables inside of your workouts to track the individual reps you did for each exercise rather than just listing them as bullet points. That way you can continue to push yourself by increasing the rep count from your previous workout.

  2. Peace to you! Thanks again for another great Notion video. Doing what I can to make the most of the platform, but I've been having a problem with my credit…! Has anyone else been inviting people, officially had them sign up & still not receiving the $5 credit? I've reached out to them but I haven't heard back just yet. Makes me slightly nervous about just paying for it…

  3. Here’s how i use it. In my notion crm when i click the relational database bit it forms a “to bill” under the finances table.

  4. I wonder if we'll ever be able to import Apple Health data into something like this (to get a more accurate sleep score, for example)…

  5. Is there a way to automatically create a table with all the days pre-filled? For example, to make it easy to create a "Health Logbook" for each month without having to manually click into the date field and selecting a day.

  6. I appreciate your effort and sharing, however I think instead of going step by step it think it would be more useful to explain the concept than going step by step, I found very confusing to folllow

Leave a Reply

Your email address will not be published. Required fields are marked *