I am trying to create a useful habit tracker once and for all:)
I am struggling to create a „streak“ feature - a column counting the number of consecutive days.
(Similar to this thread: Number of consecutive days - streak)
The difference is that I have different schedules (daily, weekly and monthly habits) and frequencies (once a day, three times a week etc) for each habit.
There are three approaches in all of which I am stuck:
- Create a separate table to track only the streaks:
Here I would need to press a button in a specific row („Achieved add row“) , based on a change in the table (Column Achieved? = „Achieved“).
I haven’t seen a way to do that?
Count the streak instantly based on the habit master table.
Here I absolutely dont know how to filter and count each habit and its streaks.
Create different „master tables“ based on the frequency. Here again, I would need to be able to add rows to different tables via the same button with an if statement.
I would highly appreciate your input, because I am stuck for some weeks already.
This is my habit tracker template. Feel free to modify it as needed.