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