Aesthetic Notion Views That WORK. Notion Habit Tracker Build with Formulas!

Подписаться 145 тыс.

Просмотров 23 тыс.

50% 1

In this Notion Habit Tracker build I'll show you how to create aesthetic Notion views that actually work as powerful reports. 🔔 Prompted Notion Goals Template offer BELOW + Sign up to my Notion From Scratch email list & learn Notion fundamentals as you go! ➜ www.bettercreating.com/notion...
NOTION FORMULAS 2.0: Notion updated their formulas: I have added the new versions you need for this build in my pinned comment! Please note: you need to match to your referenced property names such as my property being called '✎✘ Log'.
This Notion training series will help you build A complete Notion setup through step-by-step build tutorials so you can master Notion fundamentals from - databases to formulas, and join the digital second brain revolution!
🔔 Get My Prompted Goal Setting & Yearly Review Template: The 1st 100 people get 50% off: Download on Gumroad HERE: tinyurl.com/42xv7528 (Just follow the tutorial & integrate it into this build! Thanks for supporting me to make these videos 😊)
🖥️ Download My Notion Templates: bettercreating.com/downloads
🎬 WATCH NEXT:
Notion From Scratch Video 3: The Ultimate Habit Tracker Build! • The Ultimate Notion Ta...
Should You Be Using Notion To Organise Your Life? Your Second Brain Q&A: • Should You Be Using No...
📖 Read Tiny Habits by B J Fogg: US: www.amazon.com/dp/B07LC9KDP5/... UK | www.amazon.com/dp/B07LC9KDP5/...
➜ FOLLOW ME / DOWNLOADS:
📨 Sign up to my occasional newsletter on productivity, Notion & lifestyle design: bettercreating.com
📸 Instagram - / bettercreating
🐦 Twitter - / bettercreating1
🌍 www.bettercreating.com
🎬 VIDEO CHAPTERS:
00:00 Habit Tracker in Notion From Scratch: The Big Build Along Part 2!
01:04 New Notion Course: My Notion From Scratch Training Series
01:39 Notion Habit Tracker Build Part 1 Recap
02:01 Habit Status Report: How To Use Concat Formulas In Notion
04:01 Using If Statements In Notion: Creating The Multi-Option Report View
05:31 Creating A Last Logged Habit Report View in Notion
07:31 Creating A Home Page Dashboard: Using Linked Database Views In Notion
08:45 How To Use Relations In Notion: Linking Goals & Habits Databases.
💻 MY FAVOURITE TOOLS:
Notion: affiliate.notion.so/bettercre...
Shortform: shortform.com/bettercreating
Orbitkey Desk Gear & EDC: (BETTER10 for 10%) www.orbitkey.com/?rfsn=684926...
BETTER CREATING
My name is Simon, and I'm finding ways to simplify productivity & creative life.
Exploring productivity, simple living and creative life, the Better Creating RU-vid Channel is my project to build a toolkit to help creative people (including me) create more meaningful work, create better content, and live more intentional stress-free lives in the process. Other than doing this, I work as a freelance creative in theatre and film, creating productions.
#Notion #HabitTracker #BetterCreating
--

Опубликовано:

30 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 96

@BetterCreating Год назад

Hi peeps: this week: the power of Notion formulas to make beautiful gallery views! PLUS: 📢The 1st 100 people to download can get my prompted Goal Setting & Yearly Review Template for 50% OFF! Just Download on Gumroad HERE: tinyurl.com/42xv7528 & you can integrate it into this build! 🚨Updated Notion Formulas 2.0: Notion updated their formula system since this video was released: here's what they have changed to for this build! Duration In Weeks Formula: dateBetween( End Date, Start Date, "weeks") Total Target Formula: Target Per Week * Duration In Weeks Progress Column Formula: floor((✎✘ Log / Total Target) * 100) / 100 Concat Report Formula: ("✎✘ " + format(✎✘ Log) + " of " + format(Total Target) + " completed") Status Formula: if(✎✘ Log > 0, Concat Report, "⏱ Nothing Logged Yet") Last Logged Formula: ("⏱ Last Logged: " + formatDate( Last Updated, "DD MMMM"))

@MichaelKovalev-hs5zm 9 месяцев назад

4:00 my new version is concat([prop("Log") + " of " + prop("Total Target") + " completed"])

@brandstrength 9 месяцев назад

Thank you! This was about to do me in!

@BetterCreating 9 месяцев назад

Thanks for sharing! Yes indeed - these new updates require a video on how the formulas in the series have changed with formulas 2.0!! I just need to learn them too!

@karolinapartyka6013 8 месяцев назад

Also the formula for Habit Status column is if(prop("Log") >= 0, "Nothing Logged Yet", prop("Concat report")) I enlisted the help of chatgpt for that one, was driving me up the wall!

@djthompson1971 8 месяцев назад

Ga!! Thank you !!! I was feeling defeated but this worked!!

@mogta7d 4 месяца назад

Thanks mike Iam so glade for you

@haskhan 9 месяцев назад

The concat function does not combine text anymore, according to the formula guide on Notion. I used this to get the desired result. format(prop("✏Log"))+" of "+prop("Total Target")+ " completed "

@BetterCreating 9 месяцев назад

Very Good! Yes - we can now just insert + "TEXT" in place of concat functions it seems - kind of easier and simpler - but not if you are following the old method! haha - thanks for sharing :)

@haskhan 9 месяцев назад

and "Last Logged " + formatDate(prop("Last Updated"),"DD MMMM") for Last Logged

@watchlearn1167 9 месяцев назад

Excellent comment, thx

@brendanbos4235 8 месяцев назад

this was helpful. Thanks!

@tomtrlz7784 7 месяцев назад

And u don’t need to use format or prop, u just need to select the Log and press space and add the + and make the same process, it’s really easier than before

@DigbyLewis1 5 месяцев назад

Spent ages trying to work out what I was doing wrong, then checked the comments. Doh! Thanks everyone who posted the current method. 👍

@jessicaa7766 Год назад

I used your first Habit Tracker all of last year, I'm so happy updating to this one for 2023. Thanks for all of the content you put out it is soo appreciated :)

@BetterCreating Год назад

Ah thanks so much! Great stuff!

@agentdisast3r 11 месяцев назад

Hi Simon, just stumbled upon this video and now I have watched the entire playlist. Just a question though. Do you manually log every time a habit is done through their individual pages? Is there a way to have a checkbox to have it automatically increase the log number? Asking because it would be cumbersome to manually change the number in the Log column for habits scheduled daily. Thank you and I appreciate your content.

@BrendanPatrickGrace Год назад

The concat formula is updated a little now because of this weird thing were Notion uses Icons for property headers (instead of emojis), just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ") . I had to do some monkeying around for it to work.

@serena5595 Год назад

Cant thank you enough for this comment!!

@BetterCreating Год назад

Thanks! Great update comment! Good spot.

@jesusvives2149 Год назад

This was getting headache to me haha thanks a lot!

@kavineesh12 Год назад

Can't thank you enough

@mikecorbean9985 Год назад

Brenda rules!!

@kogarashiii3973 Год назад

Wow, this is incredible. I saw this display method by Marie Poulin in her weekly agenda, but did not understand how it could be implemented and then accidentally stumbled upon your video. Thank you so much for this kind of knowledge.

@tishbouvier 11 месяцев назад

You are one of the best Notion teacher on RU-vid. You make each step, including the formulas easy to implement. Thank YOU!!!

@rebeccafoxstoddard Год назад

Thank you for your in-depth tutorials. Just completed the set up. Very well done tutorial- nicely paced, detailed steps that are displayed effectively, and the layout is aesthetically pleasing, simple, and intuitive. Now on to your next build video. :)

@BetterCreating Год назад

Great to hear - thanks for watching and great to have you. Please spread the word ! :)

@eatingplantmagic2471 Год назад

Finally, got "create habit tracker" checked off my list! Thank you so much for these 2 wonderful videos. Going to explore some more! (I subscribed! 😁)

@BetterCreating Год назад

Wonderful! Welcome to the channel - spread the word!

@calvinpough994 Год назад

I made the tracker, but I am a bit confused on how to log the daily actions. Also, is there a way to know what I have completed over the course of the week?

@AlexandruGheorghiuP 5 месяцев назад

Thanks for the work in providing this step-by-step. I’m sharing my modifications - maybe it will be of help for somebody. I’ve created a new “Habit Tracker” table with three properties: Name, Habit (which is a Relation to “My Habits”) and Date of Action (Created Time). In “My Habits” the Relation from “Habit Tracker” created a new Tracker property; and the Log property I've modified to be a Rollup in relation to Tracker that counts all name Properties. Lastly, I’ve added a button in the “New Habit TEMPLATE” that ads a new page to the “Habit Tracker”. The result is that the Log is incremented automatically by each button-press and I also have a record of each time any particular habit was done. Continued success

@KylerStocks Год назад

Building out my dream planner becuase of you! Thank you!

@BetterCreating Год назад

Great stuff! Welcome to the club! Make sure you are on the mailing list for occasional updates on build videos too :)

@24dshell Год назад

Thank you so much for this course. I have been trying to get everything in my life organized and just came across notion. Seemed like the perfect app. Until l tried to create my own system. Downloaded template after template in hopes something would click and I would be able to make their system work for me. I am so glad I came across your page on RU-vid. I can not thank you enough for taking the time to break things down into an easy to follow guide that I have been able to adjust to my needs and make work!! Thank you again, I can not wait until the next video comes out. 😊😊

@BetterCreating Год назад

Love this! Thanks so much for the feedback: makes it all worth it! Goal Setting build is coming out in a few weeks too :)

@christoviljoen1 3 месяца назад

You are a brilliant teacher!

@jesusvives2149 Год назад

I know this will help me a lot, I needed it! Thanks a lot!

@BetterCreating Год назад

Glad to hear that! Welcome to the channel!

@thechristhetics Год назад

Love you man! Really helped me a lot! You're the best!

@BetterCreating Год назад

Glad I could help!

@joaquinginer6020 Год назад

I love your videos. I'm starting using Notion as a teacher. There are not many tutorial out there and I'd like to suggest you to make a serie of notion tutorials for us, mainly how to track attendance of students per day in a group, or formulas to use to check assignments. Thanks

@BetterCreating Год назад

I’m thinking of getting into some student and study stuff in 2023 - thanks for the suggestion :)

@joaquinginer6020 Год назад

@@BetterCreating great

@nyem6866 Год назад

woooow you take it to a new level

@BetterCreating Год назад

Thanks my friend - It's been a fun journey!

@leiselclayton5772 Год назад

I didn’t know about the feature that allows you to limit the relation to 1 page, and I was so excited when you talked about it, thinking I could get rid of the ugly, space-eating “+ Add Page” link that appears on my iPad under every relation I make… but it doesn’t. Instead, when you click to link another page, it just replaces the page you have already. I really hate that “+ Add Page” button. It took my nice looking properties list where I could see most of what I needed to at a glance, and pushes every line down one, so that I have to scroll to see the information and have a bunch of those buttons visible on the screen (and totally unnecessarily, as most of my relations would only have one line each (for instance, I link yesterday and tomorrow on each page in my daily journal, for easy navigating… there’s only one of those for each day, so the “+ Add Page” button that pops up when I fill in the relation is never going to be used).

@sqs2561zz 4 месяца назад

Hi Simon, many thanks for making this video series! I just wanted to ask, how do you create buttons to automatically log habits in this system? Thanks again!

@BetterCreating 4 месяца назад

Hey there, thank you! Pretty sure I do: but honestly - it was a long time ago so could have been before that feature. Either way: it’s very easy. Link a button to the daily log database and pre-set/edit the relation to the habit you want to log to be added. Make sure you then filter by the current day entry: ideally calling the new daily log @Today. Forgive me if this is wrong: going on memory from the train: but watch my latest habit tracker tour video for the system I’ve made most recently that demos it. Pretty easy!

@saskianieuwland5965 Год назад

I struggle with first i am building everything but then how do i actually use it. Is there a video for when your done building and then how to use it. From things to do to day, habit, how to start organising your life when the build is done?

@saskianieuwland5965 Год назад

Another question. Like meal prepping and planning. Should that be a task or a habit since i want to do it always at the same day in the week?

@mojabaabed5189 Год назад

hey simon, it's all good but there's something i didn't understand, how to add logs to the habits is there a check box dashboard or just edit the log value manually

@BetterCreating Год назад

Yes, currently you just add the number manually - my full template does it by making the log a rollup from adding habits in a daily log related database. I will include this part of the build later in my downloadable sections of the NFS series 👍

@mphomuila9460 8 месяцев назад

Hey Simon I have been following along and ive run into a problem the new formula language does not allow me to use some fuctions like adding text to the concat formulas i really would love to build this thing but i cant because of this please help

@HDSportsterdubai Год назад

Hey Simon, thanks for this. Needed some help, at 3 minutes on the video in the concat formula you click somewhere off camera to get the emojis into the concat formula. Can you let me know where you click to get those emoji's? I use a windows laptop so not sure if its a key on the keyboard you hit to bring up the emoji's or whether it was somewhere on the screen that the camera doesnt show. This is really cool stuff you keep sharing so thank you for that.

@BetterCreating Год назад

No worries. Thanks for watching. Yeah - I go to the edit menu and then click emojis and symbols on the Mac. I think control period might do it on windows. Or just search for where you can bring up emoji and symbols on the Notion app on your computer. :)

@BrendanPatrickGrace Год назад

The formula is updated a little now because of this weird thing were Notion uses Icons specifically for the formulas, just follow this - concat(format(prop("Log")), " of ", format(prop("Total Target")), " completed ")

@TheCosmicSeer 7 месяцев назад

Sorry if I missed something but is there a way to use buttons to add +1 to our Log or do we have to go to the habits dashboard and manually enter the numbers there? Hope that makes sense. Thank you !

@oliviawebber2206 5 месяцев назад

If you use the modifications provided above by @AlexandruGheorghiuP you can then add buttons to your dashboard for each habit that will add a page to the "Habit Tracker" which by relation will update your numbers with just one click!

@SaleemHodge 9 месяцев назад

Wonderful conent but I am having trouble following along with the formulas. It looks like these don't work anymore after the redisgn of their code system. I'm pretty lost and frustrated. Hope to get a little clarity. Keep up the great work #BuildinPublic

@vcalodabe 8 месяцев назад

The progress formula isn’t working anymore because of the new update formula. There’s decimal numbers on the percentage. Can someone help me fix that? 😭 I have one of your templates Simon, but I wanted to to my own template in an simplest way

@safiyyahajayi8985 Месяц назад

it seems they are continuing to make changes to the coding, it was a bit of a headache but from this date, these are the formulas accepted. Hope this helps others: (make sure the properties are in grey) Duration in Weeks Formula: round(dateBetween("End Date", "Start Date", "weeks")) Total target Formula: Remains the same. Progress Formula: Remains the same Contact report Formula: " ✓ " + ("✓ Log") + " of " + ("Total Target") + " " + ("Completed") Last Logged Formula: "Last Logged: " + formatDate("Last Updated"), "DD MMMM")

@viralarmytv7932 Год назад

Hi, when i try to do concat report in the formula say "Type mismatch "✎✔︎ " is not a Number." The formula i think is correct, concat( "✎✔︎ " format(prop("✎ Log")), " of", format(prop("Total Target")), " completed ")

@kellysharpe2122 Год назад

Maybe add a comma after the second quote mark (before the first "format").

@SSS-tf2mz Год назад

How to manage time as School student running a business and getting good grades

@JasonMvrtinez Год назад

what do you push while writing formula to insert emoji?

@BetterCreating Год назад

It used to be the function button on Mac - I’m not sure if it still works - alternatively go to the edit menu and find emoji and symbols menu from there. :)

@nataliedavison5592 2 месяца назад

Any Help on the Last Logged formula. It's not working for me.

@nataliedavison5592 2 месяца назад

Sorry, I just saw this in your description box with your new formulas. (" Last Logged: " + formatDate( Last Updated, "DD MMMM"))

@anthonysanmiguel 9 месяцев назад

Can anyone help with the concat formula with the 2.0 update? Nothing seems to work for me

@BetterCreating 9 месяцев назад

I think now formulas 2.0 are out. ‘Concat’ is not as relevant - just try writing + “the thing you want to write” into the formula at the point it should show - it might be that simple. Doing more research on this at somepoint to make a new tutorial. :)

@Mshmoylova Год назад

"... or download a free copy (of a Goals Template) via the video description", but there are just a subscription call and paid templates... Am I just blind?)

@wordpictureink 9 месяцев назад

New updates to Notion's formula language are making following along with this a little hellish. Managed to figure out the formulas in the last video after a bit of trial and error. This one is still not working, despite testing all the formulas in the previous comments. Here's what I've got for formula: concat([prop("✏ 𝗫 Log"), " of "], [prop("Total Target"), " completed"]) Which yields this text: 2, of ,105, completed Can't get rid of the commas in the final or the formula doesn't function. Any help much appreciated!

@BetterCreating 9 месяцев назад

Haha - oh my - yes - I think the changes will have rather messed this up! I’m catching up too! I’ll plan a video for the series on formulas 2.0!!! Cheers. S

@wordpictureink 9 месяцев назад

Subscribed! Can't wait to watch that one - your videos are a fabulous help and great pace to work along with. Thank you!@@BetterCreating