Level 6: Make all the habit checkboxes get checked automatically. This is basically what I did… - my “workout” habit is a formula that is set to True when there is a page linked in the fitness tracker. - my “Visualize day” habit checked via a button that lets me return to my home page at the end of my morning routine, which ends with visualization - My “read” habit is checked as soon as my book notes database is updated. The idea is that I can “track” my habits (including streaks and just the visual pleasure of viewing those checked boxes) without actually having to manually check the boxes. Having to remember to check you habit tracker shouldn’t have to be an extra habit.
I recently saw people using NFC stickers in their gym lockers to track every time they go, that way they can't cheat! I guess you would need to be able to keep the locker long-term, but still, I wonder if theres a way to make it work with this!
Um. How?!?!?!? 😲 I'm basically at the "follow along with Thomas and do what he does" stage of Notion setup. Are you saying you link to other trackers in Notion? If so, are you manually updating them or have you set up some sort of connection where this is updated when you have a new entry in your source tool (e.g. a "Goodreads" or "Fitbit")? Inquiring minds want to know! 🤣
Sometimes when you watch a video here, clicking the thumbs up just isn't good enough. This video would qualify for a 6 out of 5 stars, if there was such a property. This is just what I was attempting to achieve, now I have a better idea of how to go about it. Many thanks.
round of applause for the way that you explained that very complex formula step-by-step in a way that completely made sense. Also, props for even figuring out how to use all of those functions to get what you wanted. Felt like something I would have had to do for a final project in my high school comp sci class lol
And the template is even free!! I can't thank you enough this has really helped me as a beginner. You've earned a new subscriber through this video alone and I've also bookmarked your site, it was very neatly done and extremely useful, thank you!
Very useful divided habit trackers by levels and the last one with building formula for stats additionally was interesting, because this gives some ideas on how to build something 🔥 Thank You! 🙏 Now let's upgrade my habit tracker 💪
I've read the associated article and in the end, there is a bonus Habit tracker which actually is what I would want to build 🤔 Thank You for the template 🙏🔥 Let's explore this one 🧐
Thank you so much for this! Made organising my Notion so simple. I love how you explained everything, especially the use of formulas, because that had my brain melting before I watched your video haha
You're truly the best!! Providing free content like this is a gem. Thank you so much for that, you couldn't explain it better! You have a talent for teaching :) wishing you the best
THANK YOU!! I've been building this out for myself and you just fast tracked it for me. (also, I'm glad to know I'm not the only one who snickers on the inside when I type "butt" for a new button....)
Absolutely amazing! Just what I needed! I watched a lot of other tutorials but couldn't really understand what was really going on. Every second I spent watching your video was totally worth it! You explained it all really well. THANK YOU SOOOO MUCHHH!
you're actually amazing, i didnt think that programming mindsetcan be used in softwares thatll help you organize! I made myself the lvl 4 habit tracker but for lvl 5 i took the free template thank you so much! genuinely! im surprised that there arent more views for this? its great!! its completely free unlike apps thatll only let you track 4 habits and it isnt even as advanced as what you gave us!!!!
Really hoping one of these days Notion allows a fully dark/AMOLED theme and font size changes on mobile. I use it a lot for library-ish stuff but I can’t use it for daily things like this because it’s not super friendly to legally blind people on mobile. (IOS)
This is a great tutorial! I'm curious if you have any suggestions on how to manage habits that you don't want to track daily but instead track them on a weekly basis? For example, I don't want to do weights every day but I'd like to hit 3 days a week and have that factor into my streak.
Have you found some solution? I am in the same place - I try to track some habits only 1/2/3 times a week, or on specific week days, would like that to still count as "streak" :)
Thomas, youare my hero :) thank you thank you THANK YOU for this video!!! it's EXACTLY what i was looking for in a habit tracker, the level 5 formula took me a couple of tries, but now everything works, i've been using my tracker for almost a week and i love it :)
Hey I love all your videos, you've already helped me enormously with setting up my own Habit Tracker and are helping me with creating my uni course planner. I will say though for some of your other videos you have 10 billion pages and templates and are showing things going through them so quickly it's a bit overwhelming sometimes. You're still way better than any other notion tutorial youtubers I've found so far so thank you! Would love to see a video how you plan your pages as when I try start my own pages from scratch I never have any idea where to start, what pages to link to which, what properties I should have and so on. I'm not sure how you do it, for me it helped setting up a few callouts just to get an idea of what I actually need and want in each page to help me create the ultimately finished page. Anyways, thanks for explaining notion to me u've definitely made it way easier to learn!
I have a problem, which I cannot fix. So everyday a new page gets created, but without a specific date. I have to select it manually. If I dont select it it gets pushed down to the bottom, because it doesnt have that property selected automatically
For automatically repeating templates you can set the date property to "Today" (only available for database templates, not already created pages). This will automatically add today's date to the template when it's created. I just published a video with a tutorial for a habit tracker with repeat templates where I explain this.
This is great, thanks for sharing. Is it possible to link the level 5 to another table that can act as the habit repository, and based on the user selection/config, the habits to get tracked get picked when creating an entry for a new day?
You could do this, but it'd be a different design pattern altogether. Levels 3-5 here use actual properties to track each habit; I believe what you're asking about would use a specific entry in a Log database for tracking each habit on each day. This is actually how most habit tracking apps are built, but there are some big drawbacks to using this pattern in Notion. I detailed them here: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
Really great habit tracker! It ran for the first time today and for whatever reason, the template (Level 5) didn't set the date to today... is that something that needs to be added? Thanks!
This is actually so powerful and amazing! ... But I was looking to find a way to make my habit tracking easier. I just can't commit the time to learn and do all this, as much as I would like.
Level 5a: Create and relate a Habit Stages database so one could build a habit incrementally till it becomes fully online/active (once you've completed all the stages). Like building a habit ramp (lord knows I need ramps for this raging ADHD...). Each stage has a defined target of days/weeks till you move on to the next stage. Progress bar in Habits database fills up as you complete the stages. This way we can get used to the mini habits and contexts involved in doing the habit, and reduce the task initiation paralysis/wall of awful. E.g: Habit: Exercise. Stages: 5 (1. Prepping exercise outfit. 2. Putting on exercise clothes. 3. Just go to the gym. 5. Exercise 10 mins in the Gym) Just an idea, i'm still thinking it through. But I really want a system like this and im working on it.
Thanks for the post. A lot of work went into this. Sorry if this has been covered, but does your tracker allow for habits that aren't dailies? For example, if I only want to hit the gym 3x/week, I don't want to make it look like I missed it 4 days/week, when I really hit my target. Thanks.
@@wEBMedPL A youtuber called "Red Gregory" has a video on "How To Make A Habit Tracker In Notion (w/ Skip Habit Option)", I tweaked their solution to do what you're describing
Thank you for that brother! Can you or anybode else tell me how to do these journaling prompts? I like it that way as you have them! Thank you, keep doing what you re doing.
I really enjoyed building this into my Notion Application. Thank you so much. Like doing a puzzle with a great tool as an outcome! The ONLY thing I couldn't quite catch in the video was how to add the emoji in the formula?
Tip: You can add any emoji in-line on a Notion page by typing : followed by the name of the emoji, like :apple for 🍎 or :clapping for 👏 You can also bring up your computer's emoji picker with the shortcut ctrl + cmd + space on Mac and windows key + .or windows key + ; on Windows.
It's pretty hard to do this kind of tracking in Notion, as you need a record for each habit, on each day. I cover how you could set it up here: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker IMO, Notion needs a few more features and improvements before this kind of database setup is viable.
I am trying to add this to notion calendar but as we did not mention at what time the task needs to be done, it creates a problem, how to add time slot for each task??
Is there a way to automate the Date field with the correct date? This was such a great tutorial! I combed through this video several times looking for it but it's possible I missed it.
As long as the date is "today" (e.g. the current date when created), then yes! I may have forgotten to film it, but you can do the same trick I show around 06:05 with the Date property. When you're editing your database template, you can set its value to "Today (Date when duplicated)". Hope that helps!
Great tutorial, but I have a question about the date property. I've been using the Habit Tracker for a week, and I realized it doesn't just show today and yesterday, but all days, even though I had the filter rule set. After I examined the date property, I realized that there were no dates created when the new day begins. How can I fix this, or do I have to manually select the right date?
Thanks for this super helpful tutorial. I have just one question. Wont the streakcounter reach a max limit because of the days you added to the table? like, if each day it esets, does it actually remember the checkboxes you checked on the day that gets erased with each day passed?
Thanks Frank for the thorough tutorial. When setting up the streak property I noticed the split function doesn't work on consecutive missed days. For example, say I currently have a 4 day streak but I have had a 6 day streak which ended 3 days before I started my most recent streak (1,1,1,1,0,0,0,1,1,1,1,1,1) with the stats formula I followed I get: 4, 0, 0, 6 rather than 4, 6. Is there a fix for this?
Great tutorial! I set up the level 5 tracker and since I want to use it mostly on my mobile, I'm trying to find a way to view a simplified version of the tables so that it doesn't show all the filters and such on the mobile. Do you know if that's possible? Thanks for all the hard work!
@@ThomasFrankExplainsyes! I’m thinking of more of a “view only” mode to just see and check off on the phone. I think that’d be ideal. Thanks for the reply.
Is there a way to have totals for categories like Spiritual, Physical, Relational? Or would you need to make multiple data bases for each category and then link them together for the results.
There likely is a way, though it might be a bit hard to explain in a single comment. I'd recommend checking out my video on Notion Formulas 2.0, as well as my video on databases. One way that you could do this would be to create a separate database for categories and then relate habits to category pages. From there you could create a formula property in your categories database which would calculate the total for each category.
@@ThomasFrankExplains Almost got it to work but wondering if there is a way to put this if(prop("Total in number")==1,"1","0") into prop("Spiritual").sort(current.prop("Date")).reverse().slice(1).map(current.prop("Total in number")) which is what I am labling as streak. Because right now it is giving me 0.25, 0.5, 0.75 or 1 so I have to do the top part as a separate formula first to get the 0.
This was insanely helpful. Do you know how we could add a frequency logic to the streaks? As in as long as we are doing 4 times of something every week, the streak does not reset?
To do that, you'd need a different architecture. It's technically possible in Notion, but quite clunky: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
There is, but it makes the system clunky. Here's more detail on that: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
Thank you for walking us through this whole process!! Now i have added things in my habit tracker which basically gives a percentage or ratio of the habit achieved that day - maybe like a task manager + habit tracker - like 2/3 Litres of water, 4/5 supplements, 10000/12000 steps so some things are not just a check box Is there a way to incorporate this into the stats?
Hey, I promise i've tried finding out whats going on on my own but for the life of me I can't. When you work in the formula editor i'm seeing that output preview bar starting with an '='. I don't seem to see that in mine. Anyone run into this?
Hi, thanks for the video!! Especially for the progressbar formula . Your is the easiest! One question, can we add other random task in the same calendar that already have automated daily habits trackers? If yes, how?
Can I ask in your Personal Dashboard, how did you make your quick links horizontally ? I used table of contents but its always diagonally. Please help me. Thankyou
really appreciate the tutorial. However i have a query/suggestion/complaint regarding the current streak. it doesnt count @today while counting current streak, this is beneficial if we are yet to doo that in the day. However, it doesnt update when any activity is checked. and will only update until the next day. is there a way we can work around, adding condition to the split function to not count the streak if the check box is unticked, but count it if it is ticked?
You could update the formula to conditionally add 1 to each streak if the current day's habit is checked. One way would be to add another variable to the formula - e.g. a variable called "plusOne" with this value, if( prop("Habits").sort(current.prop("Date")).first().prop("Drink Water") == true, 1, 0 ) Then, anywhere you're display a streak count, you could add that variable to it. Example: currentStreak + plusOne That'll add one for the current day if it's checked, or add 0 if it isn't (without breaking the streak).
@@ThomasFrankExplains this isnt working, tried some workarounds using add formula, and changing the syntax of current streak, but it is adding one irrespective of the condition added
I've been trying to make a habit tracker work in Notion for years. Formulas 2.0 is what finally enabled streak tracking. Hard to say how long it actually took - the actual streak tracking formula didn't take too long to design, but I spent a lot of time learning formulas in general before that.
I just published a tutorial video for a Notion habit tracker that allows to set daily & non-daily habits easily. Just fyi, as I built this because I needed the same.
I built my new habit (level 4) and social media posts trackers out of this awesome tutorial. Not yet as polished as your final product, I'll be working on it. Definitely preferable to my 7 years old (no longer supported) Android habit tracker app. I also gained some new Notion skills. Can't thank you enough. 🙏
This is great! What if we wanted to compare this week/this month to last week/last month? Is that possible without creating relational week and month databases?
I believe so, yes. You'd create a couple of linked views: - One with a filter that only shows entries from this week - One with a filter that only shows entries from last week I think you could also create comparisons between the aggregated Day Scores in the Stats database with some additional formulas. You could use the filter() function to get only the related pages within your desired date range, then extract the Day Score values from each with map() and run an average calculation on them!
What do you think about click up? I just end my all-in one environment in notion but now i see there is another one in the menu named Click up, with more functions and something else
I personally am not a huge fan of ClickUp; we tried moving our team from Asana to it several years ago, but no one in my team enjoyed using it. That was actually one of the reasons we eventually stumbled across Notion. For me, ClickUp just doesn't feel as nice to use. That said, ClickUp does have more dedicated task and project management features. ClickUp is more like a bunch of traditional productivity tools rolled into one, where Notion is much more like a set of building blocks that let users create their own tools.
Great job ! And, as always, very clear and simple to implement. I’m not sure I agree about the slice(1) because I want to see a streak for a specific habit, not the whole day of habits and I don't want to wait for the next day to see how I'm doing with my habit streaks. I understand that as long as I don’t check the box, my current streak is still 0 without slice(1) but with slice(1), my current and longest streaks don't change when I check a box, which isn't very motivating...
bro im dreaming with creating my own habit tracker starting today! Great video. I would like to add points to each daily task and points required to level up style solo leveling. Thank you great video.
does anyone know how to change the script, so that the day/moment you check your habits the streak continues? With my script it only counts the streak from yesterday and not today
In that case, you'd need to build what I'll call a "true habit tracker". It's the actual set of database tables you'd use in a real habit tracking app, if you were coding one from scratch. Notion is missing some features to make this work really well, which is why I didn't cover it in the video - but if you're curious, I wrote up an explanation of it in the article: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
I am stuck at the ifs coding, no matter what it turns out red. I even removed the "red" color property and the number was still output red for some reason. I'm pretty new at this so any help would be huge.
Why is it not working? I have it working on a formula but i switched to pull from a different relation with the same things I.e the date, the checkbox, etc. And for whatever reason it's combining instead of separating. No matter what I do it works just fine. If I pulled it from a different database why is that
Why my streak bar doesnt work?I did all exact same things and the formula property is blank. It didnt tell me errors and i followed each steps. Is it a Bug?
I'd love to see how long since the last time I did something was. For example, I like to track how often I get into my pottery studio which isn't every day, but if I can see that it's been a couple weeks since i've been in there, that would spur me to get in there more often. Instead of max streak, I wonder if it could be the opposite, like max days since I've done it?
Level 6: Make all the habit checkboxes get checked automatically.
This is basically what I did…
- my “workout” habit is a formula that is set to True when there is a page linked in the fitness tracker.
- my “Visualize day” habit checked via a button that lets me return to my home page at the end of my morning routine, which ends with visualization
- My “read” habit is checked as soon as my book notes database is updated.
The idea is that I can “track” my habits (including streaks and just the visual pleasure of viewing those checked boxes) without actually having to manually check the boxes. Having to remember to check you habit tracker shouldn’t have to be an extra habit.
I recently saw people using NFC stickers in their gym lockers to track every time they go, that way they can't cheat! I guess you would need to be able to keep the locker long-term, but still, I wonder if theres a way to make it work with this!
Huge. Can you please give me this template. I am a pleb!
Um. How?!?!?!? 😲 I'm basically at the "follow along with Thomas and do what he does" stage of Notion setup. Are you saying you link to other trackers in Notion? If so, are you manually updating them or have you set up some sort of connection where this is updated when you have a new entry in your source tool (e.g. a "Goodreads" or "Fitbit")? Inquiring minds want to know! 🤣
Can you share your template??? pleasee??
Sometimes when you watch a video here, clicking the thumbs up just isn't good enough. This video would qualify for a 6 out of 5 stars, if there was such a property. This is just what I was attempting to achieve, now I have a better idea of how to go about it. Many thanks.
Man I was literally struggling from maintaining streak with my habits, it will really help me to erase my bad habits and build new habits
it won't
@@privet671poka why do you think so?
The level 5 is truly brilliant, that is some advanced formula magic 🤯
Agree... but consider you'd have to make so many manual refreshing in the formulas if adding new activities.
round of applause for the way that you explained that very complex formula step-by-step in a way that completely made sense. Also, props for even figuring out how to use all of those functions to get what you wanted. Felt like something I would have had to do for a final project in my high school comp sci class lol
Mind-blown 🤯 loved the 5 levels to we can try whichever or build on it. Thank you.
And the template is even free!! I can't thank you enough this has really helped me as a beginner. You've earned a new subscriber through this video alone and I've also bookmarked your site, it was very neatly done and extremely useful, thank you!
This is awesome. Spent a couple hours yesterday following along and building this into my new system!
I add [ "habitName: ".style("b") + (Current: "... ] just for visual effect, especially on dark background☺
Just when i needed one!
🤩 Thank you so much for this video. Really helpful. Love your teaching 👍Wish you all best 🙂
Very useful divided habit trackers by levels and the last one with building formula for stats additionally was interesting, because this gives some ideas on how to build something 🔥 Thank You! 🙏 Now let's upgrade my habit tracker 💪
I've read the associated article and in the end, there is a bonus Habit tracker which actually is what I would want to build 🤔 Thank You for the template 🙏🔥 Let's explore this one 🧐
Thank you so much for this! Made organising my Notion so simple. I love how you explained everything, especially the use of formulas, because that had my brain melting before I watched your video haha
You're truly the best!! Providing free content like this is a gem. Thank you so much for that, you couldn't explain it better! You have a talent for teaching :) wishing you the best
Thanks a lot man I integrated both dynamic graph & Streak tracker into my Habit tracker all thanks to you !
I just created all of these!!! I am feeling so accomplished :) thank you!
Thomas knew what the people needed
THANK YOU!! I've been building this out for myself and you just fast tracked it for me. (also, I'm glad to know I'm not the only one who snickers on the inside when I type "butt" for a new button....)
Absolutely amazing! Just what I needed! I watched a lot of other tutorials but couldn't really understand what was really going on. Every second I spent watching your video was totally worth it! You explained it all really well. THANK YOU SOOOO MUCHHH!
you're actually amazing, i didnt think that programming mindsetcan be used in softwares thatll help you organize! I made myself the lvl 4 habit tracker but for lvl 5 i took the free template
thank you so much! genuinely! im surprised that there arent more views for this? its great!! its completely free unlike apps thatll only let you track 4 habits and it isnt even as advanced as what you gave us!!!!
Needed that a lot.
Thanks!
Really hoping one of these days Notion allows a fully dark/AMOLED theme and font size changes on mobile. I use it a lot for library-ish stuff but I can’t use it for daily things like this because it’s not super friendly to legally blind people on mobile. (IOS)
This is a great tutorial! I'm curious if you have any suggestions on how to manage habits that you don't want to track daily but instead track them on a weekly basis? For example, I don't want to do weights every day but I'd like to hit 3 days a week and have that factor into my streak.
Have you found some solution? I am in the same place - I try to track some habits only 1/2/3 times a week, or on specific week days, would like that to still count as "streak" :)
@@wEBMedPL Nothing yet unfortunately.
Thomas, youare my hero :) thank you thank you THANK YOU for this video!!! it's EXACTLY what i was looking for in a habit tracker, the level 5 formula took me a couple of tries, but now everything works, i've been using my tracker for almost a week and i love it :)
I am obsessed with this tracker now, the best ever!
Super awesome again. Thank you, Thomas! You're the boss when it comes to Notion
Hey I love all your videos, you've already helped me enormously with setting up my own Habit Tracker and are helping me with creating my uni course planner. I will say though for some of your other videos you have 10 billion pages and templates and are showing things going through them so quickly it's a bit overwhelming sometimes. You're still way better than any other notion tutorial youtubers I've found so far so thank you! Would love to see a video how you plan your pages as when I try start my own pages from scratch I never have any idea where to start, what pages to link to which, what properties I should have and so on. I'm not sure how you do it, for me it helped setting up a few callouts just to get an idea of what I actually need and want in each page to help me create the ultimately finished page. Anyways, thanks for explaining notion to me u've definitely made it way easier to learn!
that's amazing...i am a student,and this video help me a lot
I have a problem, which I cannot fix. So everyday a new page gets created, but without a specific date. I have to select it manually. If I dont select it it gets pushed down to the bottom, because it doesnt have that property selected automatically
For automatically repeating templates you can set the date property to "Today" (only available for database templates, not already created pages). This will automatically add today's date to the template when it's created. I just published a video with a tutorial for a habit tracker with repeat templates where I explain this.
This video could not have come at a better time for me.....THANK YOU!
Hello Thomas Frank, I really enjoy your v ides, by any chance is this template available for download?
This is great, thanks for sharing.
Is it possible to link the level 5 to another table that can act as the habit repository, and based on the user selection/config, the habits to get tracked get picked when creating an entry for a new day?
I was thinking about the same and also have the option to set reminders for habits
You could do this, but it'd be a different design pattern altogether. Levels 3-5 here use actual properties to track each habit; I believe what you're asking about would use a specific entry in a Log database for tracking each habit on each day.
This is actually how most habit tracking apps are built, but there are some big drawbacks to using this pattern in Notion. I detailed them here: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
@@ThomasFrankExplainsthanks for that bonus explanation! That would make a lot more sense, but alas, notion can’t do it all! …yet lol
Absolute. Genius.
Yes, he is.
Waw, that’s really next level! Nice work!
Really great habit tracker! It ran for the first time today and for whatever reason, the template (Level 5) didn't set the date to today... is that something that needs to be added? Thanks!
Ah, if I didn't add "Today - Date when Duplicated" to the Date property in the template, then yes, you'd want to add that!
great tutorial, helped a lot
This is the video i was waiting for you to demonstrate, Live longer sir. thank you so much
This is actually so powerful and amazing! ... But I was looking to find a way to make my habit tracking easier. I just can't commit the time to learn and do all this, as much as I would like.
This unexpectedly turns into a coding lesson
😂😂😂😂😂😂😂😂😂
In the level 4 database, would I be able to change the formula to have different average percentages for each row in the table?
Level 5a: Create and relate a Habit Stages database so one could build a habit incrementally till it becomes fully online/active (once you've completed all the stages). Like building a habit ramp (lord knows I need ramps for this raging ADHD...). Each stage has a defined target of days/weeks till you move on to the next stage. Progress bar in Habits database fills up as you complete the stages. This way we can get used to the mini habits and contexts involved in doing the habit, and reduce the task initiation paralysis/wall of awful.
E.g: Habit: Exercise. Stages: 5 (1. Prepping exercise outfit. 2. Putting on exercise clothes. 3. Just go to the gym. 5. Exercise 10 mins in the Gym)
Just an idea, i'm still thinking it through. But I really want a system like this and im working on it.
I just wanna say you're awesome and very helpful!!! Subscribed!
where can i see the Havit tracker at UB? Thanks!
how do you create those journal proms that you added on 6:46?
Thanks for the post. A lot of work went into this. Sorry if this has been covered, but does your tracker allow for habits that aren't dailies? For example, if I only want to hit the gym 3x/week, I don't want to make it look like I missed it 4 days/week, when I really hit my target. Thanks.
Have you found some solution?
@@wEBMedPL did you find a solution
@@nqwarrior nope, despite trying my best and visiting Community Support.
@@wEBMedPL A youtuber called "Red Gregory" has a video on "How To Make A Habit Tracker In Notion (w/ Skip Habit Option)", I tweaked their solution to do what you're describing
Thank you for that brother! Can you or anybode else tell me how to do these journaling prompts? I like it that way as you have them!
Thank you, keep doing what you re doing.
I really enjoyed building this into my Notion Application. Thank you so much.
Like doing a puzzle with a great tool as an outcome!
The ONLY thing I couldn't quite catch in the video was how to add the emoji in the formula?
Tip: You can add any emoji in-line on a Notion page by typing : followed by the name of the emoji, like :apple for 🍎 or :clapping for 👏
You can also bring up your computer's emoji picker with the shortcut ctrl + cmd + space on Mac and windows key + .or windows key + ; on Windows.
LOL exact same question. Glad you already asked. Thanks :)
@@wEBMedPL Big thanks for your response
I appreciate you being so thorough because I have tried at least four tutorials to do the formulas and all of them did not work properly on my end
Bruh.. Good guide.. Looks awsome.. But could you have not just pasted the code in the video desc!?
i have some habits that are daily, some that are weekly and some that are monthly. how would you go about tracking these?
It's pretty hard to do this kind of tracking in Notion, as you need a record for each habit, on each day. I cover how you could set it up here: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
IMO, Notion needs a few more features and improvements before this kind of database setup is viable.
I just published a tutorial video and template for a habit tracker that makes that possible by using repeat templates. It is possible! 😁👍
I am trying to add this to notion calendar but as we did not mention at what time the task needs to be done, it creates a problem, how to add time slot for each task??
LV4 is what I am looking for. Thanksss❤
quase me matei com aquelas fórmulas, mas deu bom no final. obrigada thomas pela maravilhosidade que é o notion
Is there a way to automate the Date field with the correct date? This was such a great tutorial! I combed through this video several times looking for it but it's possible I missed it.
As long as the date is "today" (e.g. the current date when created), then yes! I may have forgotten to film it, but you can do the same trick I show around 06:05 with the Date property. When you're editing your database template, you can set its value to "Today (Date when duplicated)".
Hope that helps!
Can you provide the code block so that we can just copy and paste??
I’ve been trying for days now, I just can’t get the formula.
amazing job. Thank you so much!
hey, loved your video can you maybe show how we can get an monthly overview?
Thank you is not enough, your videos are so helpful!
Great tutorial, but I have a question about the date property. I've been using the Habit Tracker for a week, and I realized it doesn't just show today and yesterday, but all days, even though I had the filter rule set. After I examined the date property, I realized that there were no dates created when the new day begins. How can I fix this, or do I have to manually select the right date?
Hi :) when you create template click on date property and select Today - date when duplicated :)
Thank you for yoor answer, but I couldn't find it. Do you mean there where he added the date in 23:18?
@@airinn777 the date cannot be set to automatically assign in the template! Still confused how to do that
Thanks for this super helpful tutorial. I have just one question. Wont the streakcounter reach a max limit because of the days you added to the table? like, if each day it esets, does it actually remember the checkboxes you checked on the day that gets erased with each day passed?
Thanks Frank for the thorough tutorial. When setting up the streak property I noticed the split function doesn't work on consecutive missed days. For example, say I currently have a 4 day streak but I have had a 6 day streak which ended 3 days before I started my most recent streak (1,1,1,1,0,0,0,1,1,1,1,1,1) with the stats formula I followed I get: 4, 0, 0, 6 rather than 4, 6.
Is there a fix for this?
Very helpful, thank you!
level 5 is another level fr
Great tutorial! I set up the level 5 tracker and since I want to use it mostly on my mobile, I'm trying to find a way to view a simplified version of the tables so that it doesn't show all the filters and such on the mobile. Do you know if that's possible? Thanks for all the hard work!
Do you just mean the filter button? If so, I wish! Notion's mobile apps currently don't give us a way of hiding those buttons.
@@ThomasFrankExplainsyes! I’m thinking of more of a “view only” mode to just see and check off on the phone. I think that’d be ideal. Thanks for the reply.
Is there a way to have totals for categories like Spiritual, Physical, Relational? Or would you need to make multiple data bases for each category and then link them together for the results.
There likely is a way, though it might be a bit hard to explain in a single comment. I'd recommend checking out my video on Notion Formulas 2.0, as well as my video on databases.
One way that you could do this would be to create a separate database for categories and then relate habits to category pages. From there you could create a formula property in your categories database which would calculate the total for each category.
@@ThomasFrankExplains Almost got it to work but wondering if there is a way to put this if(prop("Total in number")==1,"1","0") into prop("Spiritual").sort(current.prop("Date")).reverse().slice(1).map(current.prop("Total in number")) which is what I am labling as streak. Because right now it is giving me 0.25, 0.5, 0.75 or 1 so I have to do the top part as a separate formula first to get the 0.
@@ThomasFrankExplains Got it fixed using floor instead of round.
@Thomas i tried the level 5 tracker but there's some issue with the current day counting how do I correct that
yeah, im having the same issue. Did you find a solution?
@@FaariaFarooq no found no solution yet
amazing work , thank you
This was insanely helpful. Do you know how we could add a frequency logic to the streaks? As in as long as we are doing 4 times of something every week, the streak does not reset?
To do that, you'd need a different architecture. It's technically possible in Notion, but quite clunky: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
Is there a way to integrate weekly habits?
There is, but it makes the system clunky. Here's more detail on that: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
It is possible, I just published a tutorial video and template for a habit tracker that makes that possible by using repeat templates. 😊👍
In 10:50-10:52, how did you add commands? (the /2c)
Really fantastic explanation!!!! Thanks
Thank you for walking us through this whole process!! Now i have added things in my habit tracker which basically gives a percentage or ratio of the habit achieved that day - maybe like a task manager + habit tracker - like 2/3 Litres of water, 4/5 supplements, 10000/12000 steps so some things are not just a check box
Is there a way to incorporate this into the stats?
Hey, I promise i've tried finding out whats going on on my own but for the life of me I can't. When you work in the formula editor i'm seeing that output preview bar starting with an '='. I don't seem to see that in mine. Anyone run into this?
Hmm; that might be a bug! I always see that little equals sign in my workspace.
Yes. I don't see it either.
Hi, thanks for the video!! Especially for the progressbar formula . Your is the easiest! One question, can we add other random task in the same calendar that already have automated daily habits trackers? If yes, how?
Can I ask in your Personal Dashboard, how did you make your quick links horizontally ? I used table of contents but its always diagonally. Please help me. Thankyou
i love you thanks a lot for the free tamplete
Best Video!!!!!! Next level would have been an additional graph
really appreciate the tutorial. However i have a query/suggestion/complaint regarding the current streak.
it doesnt count @today while counting current streak, this is beneficial if we are yet to doo that in the day. However, it doesnt update when any activity is checked. and will only update until the next day.
is there a way we can work around, adding condition to the split function to not count the streak if the check box is unticked, but count it if it is ticked?
You could update the formula to conditionally add 1 to each streak if the current day's habit is checked.
One way would be to add another variable to the formula - e.g. a variable called "plusOne" with this value,
if( prop("Habits").sort(current.prop("Date")).first().prop("Drink Water") == true, 1, 0 )
Then, anywhere you're display a streak count, you could add that variable to it.
Example:
currentStreak + plusOne
That'll add one for the current day if it's checked, or add 0 if it isn't (without breaking the streak).
@@ThomasFrankExplains this isnt working, tried some workarounds using add formula, and changing the syntax of current streak, but it is adding one irrespective of the condition added
@@ThomasFrankExplains lets(
streaks,
prop("Habits").sort(current.prop("Date"))
.reverse().map(current.prop("Drink water"))
.map(current.toNumber())
.slice(1)
.join("")
.split("0")
.map(current.length()),
currentStreak,
streaks.first(),
longestStreak,
streaks.max(),
plusOnecs,
if(
prop("Habits").sort(current.prop("Date")).reverse().first().prop("Drink water") == true, add(currentStreak, 1), currentStreak),
lsfix,
if(
currentStreak >= longestStreak, plusOnecs, longestStreak),
csFormat,
ifs(
currentStreak < 1,
["red"," days"],
currentStreak == 1,
["blue", " day"],
currentStreak > 1,
["green", " days"]
),
lsFormat,
ifs(
longestStreak < 1,
["red"," days"],
longestStreak == 1,
["blue", " day"],
longestStreak > 1,
["green", " days"]
),
"💧 Water: " + (
"Current Streak: " + plusOnecs + csFormat.at(1)).style(csFormat.at(0), csFormat.at(0) + "_background", "c", "b"
) + " " + (
"Longest Streak: " + lsfix + lsFormat.at(1)).style(lsFormat.at(0), lsFormat.at(0) + "_background", "c", "b"
)
)
this fix is working for both CS and LS
lets(
streaks,
prop("Habits").sort(current.prop("Date"))
.reverse().map(current.prop("Drink water"))
.map(current.toNumber())
.slice(1)
.join("")
.split("0")
.map(current.length()),
currentStreak,
streaks.first(),
longestStreak,
streaks.max(),
plusOnecs,
if(
prop("Habits").sort(current.prop("Date")).reverse().first().prop("Drink water") == true, add(currentStreak, 1), currentStreak),
lsfix,
if(
currentStreak >= longestStreak, plusOnecs, longestStreak),
csFormat,
ifs(
plusOnecs < 1,
["red"," days"],
plusOnecs == 1,
["blue", " day"],
plusOnecs > 1,
["green", " days"]
),
lsFormat,
ifs(
longestStreak < 1,
["red"," days"],
longestStreak == 1,
["blue", " day"],
longestStreak > 1,
["green", " days"]
),
"💧 Water: " + (
"Current Streak: " + plusOnecs + csFormat.at(1)).style(csFormat.at(0), csFormat.at(0) + "_background", "c", "b"
) + " " + (
"Longest Streak: " + lsfix + lsFormat.at(1)).style(lsFormat.at(0), lsFormat.at(0) + "_background", "c", "b"
)
)
this formula is working for CS, LS and correct colour in CS
lets(
streaks,
prop("Habits").sort(current.prop("Date"))
.reverse().map(current.prop("Drink water"))
.map(current.toNumber())
.slice(1)
.join("")
.split("0")
.map(current.length()),
currentStreak,
streaks.first(),
longestStreak,
streaks.max(),
plusOnecs,
if(
prop("Habits").sort(current.prop("Date")).reverse().first().prop("Drink water") == true, add(currentStreak, 1), currentStreak),
lsfix,
if(
currentStreak >= longestStreak, plusOnecs, longestStreak),
csFormat,
ifs(
plusOnecs < 1,
["red"," days"],
plusOnecs == 1,
["blue", " day"],
plusOnecs > 1,
["green", " days"]
),
lsFormat,
ifs(
longestStreak < 1,
["red"," days"],
longestStreak == 1,
["blue", " day"],
longestStreak > 1,
["green", " days"]
),
"💧 Water: " + (
"Current Streak: " + plusOnecs + csFormat.at(1)).style(csFormat.at(0), csFormat.at(0) + "_background", "c", "b"
) + " " + (
"Longest Streak: " + lsfix + lsFormat.at(1)).style(lsFormat.at(0), lsFormat.at(0) + "_background", "c", "b"
)
)
this fix is working for CS, LS, and correct colour for CS
Loved the video. Can you also make a video that can tell us how to get the aggregate progress in a year
Thank you so much 💞
Can you please create an updated tasks management system with all-new features of calendar, buttons and automations.
Thomas, how long did it take you to come up with this solution? This is actually so brilliant.
I've been trying to make a habit tracker work in Notion for years. Formulas 2.0 is what finally enabled streak tracking. Hard to say how long it actually took - the actual streak tracking formula didn't take too long to design, but I spent a lot of time learning formulas in general before that.
Is there a way to make the streak not break for a specific box if that box isnt checked off on the weekends?
I just published a tutorial video for a Notion habit tracker that allows to set daily & non-daily habits easily. Just fyi, as I built this because I needed the same.
this is such a good tutorial!
Thank you for the video
I built my new habit (level 4) and social media posts trackers out of this awesome tutorial.
Not yet as polished as your final product, I'll be working on it. Definitely preferable to my 7 years old (no longer supported) Android habit tracker app.
I also gained some new Notion skills.
Can't thank you enough. 🙏
This is great! What if we wanted to compare this week/this month to last week/last month? Is that possible without creating relational week and month databases?
I believe so, yes. You'd create a couple of linked views:
- One with a filter that only shows entries from this week
- One with a filter that only shows entries from last week
I think you could also create comparisons between the aggregated Day Scores in the Stats database with some additional formulas. You could use the filter() function to get only the related pages within your desired date range, then extract the Day Score values from each with map() and run an average calculation on them!
What do you think about click up? I just end my all-in one environment in notion but now i see there is another one in the menu named Click up, with more functions and something else
I personally am not a huge fan of ClickUp; we tried moving our team from Asana to it several years ago, but no one in my team enjoyed using it. That was actually one of the reasons we eventually stumbled across Notion. For me, ClickUp just doesn't feel as nice to use.
That said, ClickUp does have more dedicated task and project management features. ClickUp is more like a bunch of traditional productivity tools rolled into one, where Notion is much more like a set of building blocks that let users create their own tools.
Maybe this is a more simple question to the others, but can anyone tell me how to add the journaling prompt box? Is it a box? Hmm
Try "/callout" without the quotes :)
Great job ! And, as always, very clear and simple to implement. I’m not sure I agree about the slice(1) because I want to see a streak for a specific habit, not the whole day of habits and I don't want to wait for the next day to see how I'm doing with my habit streaks.
I understand that as long as I don’t check the box, my current streak is still 0 without slice(1) but with slice(1), my current and longest streaks don't change when I check a box, which isn't very motivating...
hi i have a problem, when i edit habit name it doesnt show in streak how can i fix that
bro im dreaming with creating my own habit tracker starting today! Great video. I would like to add points to each daily task and points required to level up style solo leveling. Thank you great video.
does anyone know how to change the script, so that the day/moment you check your habits the streak continues? With my script it only counts the streak from yesterday and not today
How would you account for a goal streak if the goal is to go for a run 4 times a week (or anything other than doing it every day)?
In that case, you'd need to build what I'll call a "true habit tracker". It's the actual set of database tables you'd use in a real habit tracking app, if you were coding one from scratch.
Notion is missing some features to make this work really well, which is why I didn't cover it in the video - but if you're curious, I wrote up an explanation of it in the article: thomasjfrank.com/5-ways-to-build-a-habit-tracker-in-notion-free-template-included/#true-habit-tracker
I am stuck at the ifs coding, no matter what it turns out red. I even removed the "red" color property and the number was still output red for some reason. I'm pretty new at this so any help would be huge.
Why is it not working?
I have it working on a formula but i switched to pull from a different relation with the same things I.e the date, the checkbox, etc. And for whatever reason it's combining instead of separating. No matter what I do it works just fine. If I pulled it from a different database why is that
Why my streak bar doesnt work?I did all exact same things and the formula property is blank. It didnt tell me errors and i followed each steps.
Is it a Bug?
I'd love to see how long since the last time I did something was. For example, I like to track how often I get into my pottery studio which isn't every day, but if I can see that it's been a couple weeks since i've been in there, that would spur me to get in there more often. Instead of max streak, I wonder if it could be the opposite, like max days since I've done it?
When i check the check box on top it is not showing me on database how to connect them
THANKS!