Have you ever wished for a centralized place on your Notion dashboard to keep track of all your tasks, deadlines, and important information? Consider creating a notification board in Notion!
A notification board, or notification center, is a gallery view that brings together information from different databases and summarizes it.
Let's explore how to make one.
Getting Started
In our example, we will use a task management scenario.
A. Preparation
First, we need a few things:
- A Task database
- A Notification Board database
(This should be in gallery view and set the card preview to “no preview”. Create an entry called “Notification Board”.)
Next, you'll need to relate the two databases.
Before you start adding tasks to the Task database, set a filter to the relation property that contains “Notification Board”. This means that when you add a task, it will automatically relate to the “Notification Board”, allowing you to have an instant summary.
⚠️ Note this: if you have other database views of the Task Database in your template, you'll need to apply the same filter too.
B. Section Title
If you have multiple sections on your notification board, it’ll look more organized if you assign a title to each section.
You can use the text property or the formula style() to set your title: style(”text”, “style”)
Style:
- b = bold
- u = underline
- i = italic
- "color": all text colors available in Notion can be used
Example: style("Task Overview", "b", "u", "yellow")
C. Gathering Information from Your Task Database
Now, we want to collect some information from your task database.
1. Total number of tasks
- Use a database property and the formula
.length().
- Formula explained:
PROPERTY.length() = Returns how many items are in the list.
- Example:
"You have " + prop("Tasks").length() + " tasks.”
2. Number of tasks of certain status
For example, overdue tasks.
- Database Property: Formula
- Steps:
Identify unfinished tasks
→ Define overdue tasks (establish today's date and find unfinished tasks from previous days)
→ Calculate the quantity
→ Determine the text for the notification board
(1) Identify unfinished tasks:
Explanation: This filters out tasks within the related “Task” database whose status is not “Done”.
(2) Define overdue:
Explanation: This filters out undone tasks whose “Due” is before (smaller) than today.
-
Define today:
- 1️⃣ Use now() to get the current date and time.
- 2️⃣ Since we don't want the time, we use formatDate(now(), "YYYY-MM-DD") to include only the date. This helps us find tasks before today, the whole day.
- 3️⃣ Since formatDate() returns text, we use parseDate() to get a timestamp, so Notion recognizes it as a date instead of text.
- Now we get
Today = parseDate(formatDate(now(), "YYYY-MM-DD")))
-
Define overdue:
- Due date < today. So the formula would be:
.filter(current.prop("Due") < parseDate(formatDate(now(), "YYYY-MM-DD")))
-
Count the number of overdue tasks
- Add a .length() to return the number of tasks that meet the conditions specified above.
(3) Decide the text you want to display on the notification board
Use let() to simplify the formula.
If "a" is the number of overdue tasks, you might want to see : "You have a overdue tasks."
You can use:
let(a, number of Overdue tasks, “You have ” + a + “ overdue tasks.”)
You could also add conditions to your text with ifs().
For example:
- if a (number of overdue tasks) = 0, show: "Yay! You have no overdue task."
- if a = 1, show "You have " + a + " overdue task."
- if a > 1, show: "You have " + a + " overdue tasks."
You can do the same with tasks you need to complete today, or tasks completed today.
The final result:
“
You can take a closer look at the setting of my example or duplicate it
HERE.
Examples of notification board in my template
In my CRM Elite template, I've created a notification board for quarterly reports. Similarly, I use this concept to summarize payment statuses.
Wrapping Up
A notification board can be an incredibly useful tool to keep your information organized.
I hope I provide a simple enough explanation for you to understand.
Give it a try and see how it can improve your productivity!