The Properties

In this example there are habits (checkbox properties) for the Morning, Afternoon, and Evening. There is also a date property, and three formulas that return the total number of habits completed in each part of the day. There is also a weekday select.

The Formulas

The Syntax (Morning Habit)

if(unaryPlus(prop("Morning Habit 1")) + unaryPlus(prop("Morning Habit 2")) + unaryPlus(prop("Morning Habit 3")) + unaryPlus(prop("Morning Habit 4")) + unaryPlus(prop("Morning Habit 5")) == 5, "Morning Habits (5): " + "✅✅✅✅✅", "Morning Habits (5): " + slice("◉◉◉◉◉", 0, unaryPlus(prop("Morning Habit 1")) + unaryPlus(prop("Morning Habit 2")) + unaryPlus(prop("Morning Habit 3")) + unaryPlus(prop("Morning Habit 4")) + unaryPlus(prop("Morning Habit 5"))))

The Boardview And Filter

Here, I have one database view linked from the original in boardview. The intentions are to use this linked database view somewhere else in the workspace to provide a window into habits and be used as a progress bar of sorts.

This linked database is grouped by the weekday select property. Below, is how I filtered it to display the week I’m in.

Copy Template Here!