How to Create Your First Relational Database in Notion
Heard about relational databases in Notion?! Did it leave you has confused as before? Me too.
Relational databases are a way to connect up the databases you use inside of your Notion. Databases allow you to add tables, calendars, gallery, list and board view for managing projects and activities and connecting them up can be useful when importing information to your account.
Today’s article, we’ll explore how you can use the Notion relational databases to create a workout menu and then implement that into your daily log. This is what I currently use databases for, but hopefully it inspires how you can use it. Inspired by the Facebook group, I wanted to share my use case for this in a little more detail.
► Feeling Lazy?! You can watch the full explanation to relational databases on YouTube.
Health (page) - The dashboard helps me to plot out my sleep, meditation, food and workouts all on one table, so that I can keep an eye on my general progress.
Workouts (page) - Used in the gym, I open this to make sure I’m on track with the task at hand. Working out!
► We applaud you to watch the full view on YouTube to save you time. Remember total newbies to Notion can get a FREE PDF for beginners (no sign-up) needed!
1. Create a Menu/Database
Go ahead and craft your own database. This could be a list of items you sell, or a list of the habits you do every morning. One mistake I made at first is to make all of the items unique. Limit the items and assign any other elements to them in the table. For our example, we tallied the workout information, type and the time taken. These are useful workouts I’ll be using and importing into the Health page we’ll show near the end of this demo.
2. Add a Relation Column in Your Dashboard/Selected Page
To where ever you’d like the information to land, create that page. In this example, we chose to add the relational database information to a pre-existing Health page, tallying all the useful insights of my day. So all I had to do was create a column with a “relation” property type, and choose the database “workout menu” to connect the two together.
3. Import Data from Relation Window
Once you’ve connected the column to your existing database. You can now choose a field on the other database to your current Notion database in view. Like a menu. Once added, you can add more than one entry, and it’ll populate that row.
4. Connect Rollups for More Information
Rollups columns can import even more information into the database. For example, I want to be able to see my workout time for each workout I’ve connected up. You go to column > rollup > select a relation (in this case, workout) > select a property (time taken) and use SUM to tally all of the fields (for if you add more than one field).
There you have it… Your first relational database inside of Notion. You can now freely add new pieces of information from other existing tables and databases. It’s hard and maybe this didn’t even help to connect up everything. We recommend watching the video as things are super hard to explain in written format when speaking about Notion databases.
► Looking to understand all the types of databases on Notion? Try this video!