Notion Answers

Help between Notion users


Register & Ask

It's free & easy

Get answers

Answers, votes & comments

Vote and select answers

Receive points, vote and give the solution

Question

2votes

Months and years Notion calendar database

I am trying to have a Notion calendar database for dates that have months and year, then in other databases select the month in that year. For example expenses or tasks.

The problem comes after some time when new years begin. If I have an expense in January, it has to be from this year and not from the last 3 years and of course I don't want to end with a Notion database that have 200 months repeating over and over.

How can I accomplish this?

That way if I have a new expense, when selecting the month, "ONLY" this year months will show up in the related database rollup and not all months from all years.

This will also help in showing for example all expenses by months and years in Notion.

I want to avoid "Tasks 2020", "Tasks 2021", "Tasks 2022", "Expenses 2020", "Expenses 2021", "Expenses 2022", "January 2020", "January 2021", "January 2022", and so on with 50 databases. I need just one calendar to integrate everything and do the trick.

Any ideas how to do it without having to create complete new Notion databases for every year and need to have multiple rollups for every year in the expenses database?

1 Answer

1vote

avidnotionuser Points1430

The year in the database should be a select property where you have 2020, 2021, 2022, 2023 and so on as your options, so every page in the database should have a year selected this is to help you to filter the data by year.

*I don't want to end with a Notion database that have 200 months repeating over and over.

I am not sure what you mean by this because one database will have several months and it sounds to me that you don't want to create a new database for each new year. Its best to stick to a Master Calendar. What I do is have three separate databases initially one for the month/year, one for each day, one for the week and they are all relational to one another. From their I relate my finances such as my budget to my day database and title it What's Due! for any bills that are due.

I want to avoid "Tasks 2020", "Tasks 2021", "Tasks 2022", "Expenses 2020", "Expenses 2021", "Expenses 2022", "January 2020", "January 2021", "January 2022", and so on with 50 databases. I need just one calendar to integrate everything and do the trick.

This all depends on how you use the data. So ultimately you will have a master database (1), but from their you may want to create what is called a linked database to look at the data differently because there are multiple properties contained in a database.

0vote

nosy commented

Thank you, I will explain it in a simple way with 2 databases.

1- Months
2- Expenses

The months database includes:
January 2020
February 2020
March 2020
April 2020
May 2020
June 2020
July 2020
August 2020
September 2020
October 2020
November 2020
December 2020

Then the same for 2021, 2022, 2023 and 2024.

When I create a new expense, I click on the related months property to select the month for that expense.

Notion shows 60 items so select a month from and that is really bad, I just want to see this year months, not 60 months.

How to see just this year?

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect