Instituto de la Felicidad

↙️

Hi, Hello! My name is Sarah - the writer behind redgregory.com.

⚡

Subscribe to the newsletter if you haven't already

📙

Connecting data in Notion can be achieved through 4 different methods. The first being Common Properties. The second being a Relation. The third being a Parent-Child Relation. And the fourth being a Nested Database. Here is how they work.

1. Common Properties

When propert(ies) match between two entries.

You can pivot this data into a
📊
Boardview to visualize all data associated with similar tags

You can pivot this data into a Calendarview to visualize all data in a similar month.

As well, you can view data with multiple conditions like similar dates AND tags using a filter.

Example

Free Notion Template: A Gift Budgeting Tool - Red Gregory

With the holiday season in full swing, I built a gift budget tool to keep track of spending for each person in your life. This template divides gifts and spending cost per person, and includes a property for an "overall budget," and a "chip in" property to exclude money chipped in from others.

https://www.redgregory.com/notion/2020/12/2/free-notion-template-a-gift-budgeting-tool?rq=boardview

2. Database Relation

When database A connects to database B using a
🧬
Relation property

Every connection made to another database will automate a relation going back to the original database. For example, the above contact list includes a relation to Company Cards. Inside each company card will be a relation going back to its corresponding contact.

Example

Free Notion Template: Employee Directory - Red Gregory

Start here if you're new to Notion, using the program to build a team workspace, and organizing employee directories. This template has properties for basic information, contact information, onboarding statuses, and birthday tracking. The following dashboard uses two databases; one for Employees and

https://www.redgregory.com/notion/2021/3/25/free-notion-template-employee-directory

3. Parent-Child Relation

When one database entry connects to another using a
🧬
Relation property

This is a relation that is not connecting to another database, but rather, one database entry is connected to another inside the same table. For example, above is a list of people with a
🧬
Relation property labeled "Children."

After selecting to use a relation, a search box will appear. You can search for the database you're in and choose to sync both ways. A "Parent" relation will automatically appear to link back.

Example

How To View Grandparent Relations In Notion - Red Gregory

The relation is a Notion property that can do one of two things. The first is connect one database to another. The second is to relate one database entry to another within the same database. This is called a parent-child relation.

https://www.redgregory.com/notion/2021/3/30/how-to-view-great-grandparent-relations-in-notion

4. Nested Database

When you want to connect database A to database B, and would also like to manipulate database B while inside database A

After connecting database A to database B, you can nest database B inside database A using the "linked database" feature. Everything added to the linked database will appear in the original.