Template preview
2
Databases
13
Properties
3
Pages

Water Tracker

byVT
4
a year ago, v2.19

Water is essential for life. To maintain good health, energy, and longevity, it's important to monitor your daily water intake. This template was designed to help you track each water consumption and its quantity.

How it works?

To start water tracking, duplicate the template. To do so, click Use Template on the left sidebar, go to the template page, and select Duplicate at the top right.

Image alt

Templates were created for convenience, with presets of volumes (100 ml, 200 ml, 300 ml, 500 ml) added. If you are accustomed to drinking from containers other than those offered, you can customize them to your liking.

Views of the table and their purpose

Today, History, and Stats are two presentations you can interact with. They are used for displaying statistics.

Today

The basis for your tracking is this block. When creating a new entry, the date is automatically selected for today and all you have to do is select one of the convenient templates (picture above) by the amount of water consumed.

Image alt
Image alt

History

If you want to take a look at your progress, this view can be helpful. All of your recorded water intakes are grouped by month and year, alongside the amount of water you consumed in mL for that period.

Stats

For quick access to the statistics, you can use this section. The data is summarized and presented in a clear and concise format: today / week / month / year.

Image alt

Using this template, you will not only develop a habit of drinking water, but also be able to track your progress in the future for maximum results. It is best to use it as a widget on your home page or the page you view every day for an easy and convenient way to stay on track. Enjoy using it!

Stats

Property
Type
Description
TodayRollupA rollup from Hourly Log to show the amount of water you have drunk today
ThisWeekRollupA rollup from Hourly Log to show the amount of water you have drunk this week
ThisMonthRollupA rollup from Hourly Log to show the amount of water you have drunk this month
LoggedMlFormulaOutput formatting formula for Logged property
LoggedRollupA rollup from Hourly Log to display the amount of water you have drunk over time
Hourly LogRelationA relation to Hourly Log database

Hourly Log

Property
Type
Description
TodayFormulaif(formatDate(prop("DrankAt"), "YYYY/MM/DD") == formatDate(now(), "YYYY/MM/DD"), prop("ml"), 0)
Determines whether today
mlNumberAmount of water drunk
ThisMonthFormulaif(formatDate(dateSubtract(prop("DrankAt"), date(prop("DrankAt")) - 1, "days"), "MMMM DD, YYYY") == formatDate(dateSubtract(now(), date(now()) - 1, "days"), "MMMM DD, YYYY"), prop("ml"), 0)
Determines if a date is in the current month
ThisWeekFormulaif(formatDate(dateSubtract(prop("DrankAt"), day(prop("DrankAt")) - 1, "days"), "MMMM DD, YYYY") == formatDate(dateSubtract(now(), day(now()) - 1, "days"), "MMMM DD, YYYY"), prop("ml"), 0)
Determines if a date is in the current week
DrankMlFormulaOutput formatting formula for ml
StatsRelationA relation to the Stats database to calculate water consumption statistics
NameDateA page name from template include volume of water drunk