Create a Custom TV Series Tracker in Notion Using Databases and Relations

Published: 12 February 2023
on channel: Notion Expert
1,768
35

With the help of linked databases, rollups, and calculated properties we’re creating a powerful TV Series tracker in #Notion. We focus on an efficient database structure and how to build it in Notion.

Week 6, day 40 of our 100 days of #notion video series. #100dayschallenge

00:00 - Start
01:02 - Warning! Limitations ahead!
01:37 - 3 connected databases
02:30 - Adding air dates
03:26 - Adding relations between the databases
06:04 - Bad naming causes linking issues!
07:40 - Paste your dates!
08:03 - Roll up the air dates to seasons
08:26 - Strange rollup formatting of dates
09:56 - Fix Rollup dates using Formulas
13:01 - It's probably wrong, but...
14:53 - Rollups to aggregate dates to each TV Series
18:05 - Timeline view!
18:55 - My data is gone!
20:10 - My timeline became a little dot!
20:44 - Fixing the timeline view!
22:00 - Dates CANNOT be set in the timeline!
22:57 - Why can't we add parent/child tasks to the timeline?
23:39 - Next time: The Notion way!

Become a Notion expert in 100 days through hands-on video tutorials!
Fast-track your journey with some premium templates!

Learn from me, the Notion Expert.

A developer for over 20 years leading a product department for the last 10.
Helped by Notion every step of every day. Let's level up YOUR skills!

In-depth guides: [http://notionexpert.substack.com](http://notionexpert.substack.com/)
Twitter: [  / pro_notion  ](  / pro_notion  )
Download Notion: [https://notion.so](https://notion.so/)

Music: "Fluidscape" Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 4.0 License
http://creativecommons.org/licenses/b...


Watch video Create a Custom TV Series Tracker in Notion Using Databases and Relations online without registration, duration hours minute second in high quality. This video was added by user Notion Expert 12 February 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,76 once and liked it 3 people.