👵🏻 Grandparent Entry
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. I want to show you how you can view grandparent relationships using the latter technique with rollup properties.
The Notion Database In Action
How To Setup The Database
Create one Child relation property connected both ways. Search for the database you are currently in. The second relation property that appears will be the Parent. Rename both properties accordingly.
Create one rollup property called Grandparents. Configure it to grab the parent and show that parent’s parent. A.k.a the grandparent of the current entry.
How To Create A Template To Navigate To Grandparents And Grandchildren
If you want the ability to navigate to the grandparent and grandchildren relations, something the above technique alone will not allow (rollups are only windows, not links), follow these instructions.
First, create another rollup property called Grandchildren and configure it to grab the current entry’s child’s child.
Next, create a template and insert TWO linked databases (trigger: /linked database) into the body of the page and search for the current database.
Create two columns labeled Grandparents and Grandchildren inside the template page and drag the two linked databases underneath. I switched the default table to list view.
Configure the filter of the Grandparents like this:
Grandchildren Rollup contains Name of Template
Configure the filter of the Grandchildren like this:
Grandparents Rollup contains Name of Template
This is a small segment of my work-in-progress family tree. Finding automatic connections between grandparents/children is essential for my setup.