Custom Database Views

1. Understanding Database Views

Before we dive in, it's essential to grasp what a "view" is. A view is simply a different way of looking at the same data in a database. Creating a new view doesn't create a new database or copy your information. It just applies a different layout, filter, or sort to the original data.

Think of your music library: you can view the same collection of songs sorted by artist, by album, or by genre. The songs don't change, but the presentation does. Notion views work exactly the same way.

The video below offers a great explanation of this concept.

Now, let's start creating our own views. The default view is a Table, which you already have. We will add three new types: Board, Calendar, and Gallery.

2. The Board View: Your Content Pipeline

A Board view is a Kanban-style layout that groups your database items into columns based on a Select or Status property. This is perfect for visualizing a workflow and tracking progress. We'll use the Status property you created in the last lesson to build a content pipeline.

Your Turn: Build Your Pipeline

Now, apply this to your "Content & Product Ideas" database.

Assignment (10 minutes):

1. Next to your "Table" view tab, click the + button to add a new view.
2. Select Board from the layout options and name the view "Content Pipeline".
3. Click the ... menu in the top-right corner of the database and select Group.
4. Change the Group by option from whatever is selected to your Status property.
5. You should now see columns for "To-do", "In progress", and "Done". Try dragging one of your idea cards from one column to another. Notice how the Status property on that item updates automatically.
6. Optional Customization: Click on the Status property header in your original Table view, select Edit property, and change the options to be more specific to content creation, such as:
   • Idea (To-do)
   • Drafting (In progress)
   • Designing Assets (In progress)
   • Scheduled (Done)
   • Published (Done)

3. The Calendar View: Your Publishing Schedule

The Calendar view displays your database items on a calendar based on a Date property. This is ideal for planning and visualizing your content schedule using the Publish Date property.

Your Turn: Create Your Schedule

Let's add a calendar to your "Content & Product Ideas" database.

Assignment (10 minutes):

1. Click the + button to add another new view.
2. Select Calendar from the layout options and name this view "Publishing Calendar".
3. By default, Notion will find and use your Publish Date property. If it doesn't, go to the ... menu, select Layout, and ensure Show calendar by is set to Publish Date.
4. Go back to your Table view and add some dates to the Publish Date property for a few of your ideas.
5. Switch back to your "Publishing Calendar" view. You will now see your items appear on the calendar. You can even drag and drop them to reschedule.

4. The Gallery View: A Visual Idea Board

The Gallery view displays your database items as visual cards. This view is excellent for visually-driven products like wallpapers, icon sets, and other design assets. It can pull images from a page's cover, or from the content within the page itself.

Your Turn: Visualize Your Ideas

Finally, let's create a gallery for your creative ideas.

Assignment (10 minutes):

1. Click the + button one last time and add a new view.
2. Select Gallery from the layout options and name it "Idea Board".
3. Open one of the idea pages in your database and click Add cover. Choose an image that represents that idea.
4. Go back to your "Idea Board" gallery. Click the ... menu and select Layout.
5. Change the Card preview setting to Page cover. Your card for that item will now display the cover image you selected.
6. You can also use the Properties menu to show or hide properties (like Status or Priority) on the gallery cards for more context at a glance.

Conclusion

Excellent work. You've now transformed a simple table of data into a multifaceted project management system with distinct, purpose-driven interfaces. You no longer have just a list of ideas; you have a visual pipeline, a content calendar, and an inspiration board.

Key Takeaways:

• One Database, Many Views: The same set of data can be viewed as a Table, Board, Calendar, or Gallery, each offering a unique way to interact with your information.
• Board View for Workflows: Grouping a Board view by a Status property creates a powerful Kanban system for tracking progress.
• Calendar View for Scheduling: The Calendar view is the most intuitive way to visualize any time-sensitive information linked to a Date property.
• Gallery View for Visuals: The Gallery view is ideal for showcasing image-heavy content and creating mood boards for your product ideas.

Preview of the Next Lesson

Your system is becoming quite powerful, but we can make it even smarter. In the previous lesson, you linked your "Content & Product Ideas" database to your "Products" database. In the next lesson, we will build on that foundation. The learning outcome is to create relationships between databases to link and sync information across a Notion workspace. You'll learn how to use Rollup properties to pull data from one database into another automatically—for example, to see how many content pieces are planned for each product, directly on your "Products" page.