Water Tracker
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.
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.
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.
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 |
|---|---|---|
| Today | Rollup | A rollup from Hourly Log to show the amount of water you have drunk today |
| ThisWeek | Rollup | A rollup from Hourly Log to show the amount of water you have drunk this week |
| ThisMonth | Rollup | A rollup from Hourly Log to show the amount of water you have drunk this month |
| LoggedMl | Formula | Output formatting formula for Logged property |
| Logged | Rollup | A rollup from Hourly Log to display the amount of water you have drunk over time |
| Hourly Log | Relation | A relation to Hourly Log database |
Hourly Log
Property |
Type |
Description |
|---|---|---|
| Today | Formula | if(formatDate(prop("DrankAt"), "YYYY/MM/DD") == formatDate(now(), "YYYY/MM/DD"), prop("ml"), 0) Determines whether today |
| ml | Number | Amount of water drunk |
| ThisMonth | Formula | if(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 |
| ThisWeek | Formula | if(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 |
| DrankMl | Formula | Output formatting formula for ml |
| Stats | Relation | A relation to the Stats database to calculate water consumption statistics |
| Name | Date | A page name from template include volume of water drunk |