Notion Databases: Custom Properties & Relations

1. From Pages to Databases: The Core Concept

At its simplest, a Notion database is a collection of pages that share the same set of properties. Think of it not as a static table, but as a dynamic container for structured information. This structure is what allows you to view, sort, and filter your data in powerful ways, making it far more flexible than a standard spreadsheet.

To get a clear understanding of these fundamentals, let's start with a foundational video.

The core takeaway is that each row in a Notion database is its own page, capable of holding any content you want, while properties act as structured metadata for that page.

Now, let's create your first database. You can create a database "inline" on an existing page or as its own dedicated "full page". For building a central part of your business system, a full-page database is usually the best approach.

Your Turn: Create Your Content Hub

It's time to apply this. In the "homebase" project management tool you chose earlier in the course, create a new full-page database.

1. Create a new page and select the Table option from the database choices.
2. Title this database "Content & Product Ideas". This will serve as your central hub for brainstorming and planning.

2. Structuring Your Data with Custom Properties

An empty database isn't very useful. Its power comes from the custom properties you add to structure your data. Every new database starts with a Name property (a Text/Title type) and a Tags property. We'll customize these and add more.

The video below demonstrates how to add some basic, yet essential, property types.

Notion offers a wide variety of property types, each serving a specific purpose. This official guide from Notion is an excellent reference to have on hand.

Your Turn: Build Out Your Database

Now, let's add some structure to your "Content & Product Ideas" database.

Assignment (10-15 minutes):

1. Delete the default 'Tags' property. You can do this by clicking its header, then Edit property, and Delete property.
2. Add the following new properties to your database:
   • Status (Type: Status): This is a special type of Select property. By default, it will give you "To-do," "In progress," and "Done." You can customize these later (e.g., "Idea," "Drafting," "Ready for Assets," "Published").
   • Publish Date (Type: Date): This will be for scheduling when a piece of content goes live.
   • Format (Type: Multi-select): This allows you to tag an idea with multiple formats. Create a few options like Wallpaper, Icon Set, Notion Template, and Social Post.
   • Priority (Type: Select): Create three options: High, Medium, Low. This will help you decide what to work on next.

Your database should now have columns for Name, Status, Publish Date, Format, and Priority, looking something like this:

3. Connecting Information with Relations

This is where Notion's true power as a system-building tool emerges. A Relation property allows you to link a page in one database to a page in another (or even the same) database. This creates a network of interconnected information, which is essential for building a "second brain" or a business operating system.

For your goal, you'll want to connect your content ideas to the specific products they are meant to support.

First, create a second database:

1. Create another new full-page database.
2. Title this one "Products".
3. Add a few example entries in the Name column, like "Minimalist Wallpaper Pack Vol. 1" or "Productivity Icon Set."

Now, let's see how to link these two databases together.

Creating a two-way link is critical. It means that when you're looking at a product in your "Products" database, you'll be able to see all the content ideas related to it.

Your Turn: Link Your Databases

Assignment (10 minutes):

1. Go back to your "Content & Product Ideas" database.
2. Add a new property. Name it "Related Product".
3. For the type, choose Relation.
4. In the configuration menu, select your "Products" database.
5. Make sure the "Show on Products" toggle is turned on. Notion will automatically name the corresponding property, but you can rename it to "Related Content" if you wish.
6. Click Add relation.

Now, when you click in the "Related Product" cell for one of your content ideas, you'll be able to search for and link to an entry from your "Products" database.

Conclusion

Congratulations, you have successfully built the foundational structure for your business's content and product management system. You've moved beyond simple pages and lists into the realm of structured, relational data—a skill that is central to organizing any complex project.

Key Takeaways:

• Databases are collections of pages: Each entry in a Notion database is a full page, ready to be filled with detailed content.
• Properties provide structure: Custom properties like Text, Select, Date, and Status allow you to add structured metadata to your pages, which is essential for organization.
• Relations create a network: The Relation property is the glue that connects different databases, allowing you to build a cohesive system where information is linked logically (e.g., content ideas are linked to the products they promote).

Preview of the Next Lesson

Your databases now have the right structure, but they're still just displayed as a simple table. The next step is to make this information more visual and actionable. In our next lesson, you will learn how to configure custom views (Board, Calendar, Gallery) for a single database to display information in different ways. This will allow you to create a Kanban board to track your content pipeline, a calendar to see your publishing schedule, and more—all from the single database you built today.