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

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.

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

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.

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.

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