Design, Planning, Database

A Colorful Daily Journal Template In Notion

notion-template-colorful-daily-journal-cover.png

✏️ Journaling Calendar

This is a colorful journaling database for your Notion workspace. Included are custom cover images for the corresponding weekday, different database views to visualize this week, this month, last month, and next month using the gallery view, five habit checkboxes, unique date formulas, and color-themed pages.

The Dashboard Homepage

There are two linked databases from the master table to view the journal in weekly and monthly formats. To the left are all entries that lie within this week (mon-sun), and all entries that lie within this month (ie. October) to the right.

You can delete all example entries before getting started.

How To Add Colorful Cover Images

There is a list of template options upon creating a new page labeled Monday, Tuesday, Wednesday, etc. Each template will generate the corresponding cover images found above.

Database Views In The Journal

Screen Shot 2021-09-28 at 3.26.38 PM.png

There are six database views to choose from inside the master database.

All Entries

In this view you can see all entries sorted in ascending order without filters. This is organized in a gallery view.

notion-database-view-gallery-journal.png

This Month, Last Month, Next Month

View all entries in a given month through these three database views. The filter for these views require one formula. This formula will return if the entry’s date lies within This Month, Last Month, or Next Month.

this-month-formula-notion-journal-view.png

This Month Formula

if(month(prop("Date")) == month(now()), "This Month", if(month(now()) + 1 == month(prop("Date")), "Next Month", if(month(now()) - 1 == month(prop("Date")), "Last Month", "")))

This Week

View all entries that lie between Monday and Sunday in this database view. Similarly to the Monthly database view, a formula is required.

weekly-view-notion-database-view.png

This Week Formula

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Daily Habits

There are five daily habit checkboxes included in the template. Check off habits in this database view. You’ll also notice another formula indicating the start of a new week. This formula indicates one of two conditions.

  1. Does the date land on a Monday?

  2. Does the date land on the first of the Month?

If so, find the date’s week number in the month. For example, Oct 1st is in the 1st week of the month.

notion-habit-tracker-week-formula.png

Start Week Formula

if(not empty(prop("Date")) and or(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days") == prop("Date"), day(prop("Date")) == 1), formatDate(prop("Date"), "⤵ MMM") + " W" + format(ceil((date(prop("Date")) + day(dateSubtract(prop("Date"), date(prop("Date")) - 1, "days")) - 1) / 7)), "")

 

Further Reading