Track Your Habits Online 2021 | How to Make a Habit Tracker
HTML-код
- Опубликовано: 7 сен 2024
- I've been tracking my habits for over a year using a simple yet effective habit tracker I developed using my Google Suite tools. I will show you today how to use Google Forms and Google Sheets in order to make a super effective, professional habit tracker for free. This is part one in the series, and I will be focusing on how to build the front end of the application today.
Tracking your habits is important because we want to develop a reward system for your healthy habits, and we also want to be able to use your habit tracker in order to analyze your trends. I want to teach you how to develop a really clean habit tracker in this episode and then get into the chart developments next episode. Enjoy!
🔹 Do you want to create short form content for a living? Join my course : bit.ly/3MN3nrE
💰 I am on a mission to help you become financially independent! Subscribe for more.
⚠️Please use the links below to follow and engage with me!
Scammers have created fake accounts, impersonating me on all social media platforms. These links are my ONLY accounts, and are the official accounts that you can follow:
🔹 Official Links : viclaranja.com...
🔴SUBSCRIBE: bit.ly/VicLara...
DISCLAIMER: Any information that I give within my content is purely based on my own experience or research, and is to be viewed as entertainment or educational content only. I am NOT a financial advisor and therefore will never provide you with financial advice on my RUclips channel or other platforms. Furthermore, my results and the results of my clients are not guaranteed, they are strictly to be used as examples and for entertainment. There is no guarantee as there are many variables that will impact your success. Everything stated should be taken as an opinion.
#FinancialIndependance #HabitTracker #AtomicHabits
What are the habits you're trying to master??
Practicing my stretches everyday until I get my splits down!
There are many habits I want to track - especially daily tasks I tend to avoid that should really be apart of my routine. 👍
More importantly, I had stomach surgery 7 months ago and I struggle with nutritional deficiencies so I really need to monitor my daily intake of supplements as I’m trying to correct chronic problems like being anemic and always low on Vit D.
I thought about using google forms and I knew the data could convert to spreadsheet but I have NO CLUE how to create those queries!
I literally searched for “How to build digital habit tracker with google forms to spreadsheet” and was THRILLED to see your video not only offers just that - but it was made very recently so I know it is not outdated either!
♥️👍🥰 THANK YOU SOOOO MUCH!!!!!
I made sure to like, save to playlist & subscribe!
Have a Great Week! 🤗😉
UNREAL!! I'm so happy that this truly helped you out. I knew putting it together that it was so unique, that someone would need specifically this. Very dope. That just made my day.
Creating better AM and PM routines. Thanks for making this video! Organization and data really help me get out of my head and into being actionable. I'm definitely going to be telling all my friends.
Thanks for watching!
At 8:57, why not just do A3:A? That would include everything from A3 to infinity. By arbitrarily setting the limit to A500 you're just creating a problem that you'll have to solve in 16 months (and 13 days).
Whooo that's something. Nice thought though
This is fantastic. Going to teach it to my middle school students who have access to the entire Google suite.
Frictionless and fully customisable - love it!
This is a lifehack that everyone needs!
Thanks brother
I just moved to a g suite productivity system because notion was overwhelming to me. It’s amazing to see how practical and easy to execute are these spreads. Currently I’m using Google calendar, tasks and keep for organizing my time and Google docs and sheets to study, but I’m going to try this method of habit tracking. Thanks for the amazing video, keep up!
Thanks man. If you’re into that definitely check out Airtable, it’s kind of like Sheets but so much more complex
When you are doing all of the sums, if you type =SUM(A3:A) it will use all cells in the A column to do the calculation including A3 to infinity instead of stopping at 500 without including the label! :)
Thanks for the shortcut!!!
The one person who downvoted your vid is just jealous of your beard! 😉
I really like the idea about a personal habit tracking template. Not a single app out there has fitted me enough to stick with it. But I have a quetion: how would you track integer habits (for example, a habit called "drink water")?
If the variables I went over don't exactly fit your habit structure I would suggest exploring the different functions of Google forms and see what would work better!
Well made and neat! Keep up the good work!
Hey Vic, thank you. Great video. I am not a spreadsheet guy but what I have always wanted was a way to set a score for different habits. Say I had ten habits and I ranked them 1-10. Then I inverted the score: 10 points for doing the first, 1 point for doing the last. My total potential score would be 55. My actual might be 45. 82%. That’s my score for the day.
Do you have any suggestions on how to accomplish this?
Wow Nice :)
Creative! I like the idea
Thanks Vic!
That’s helpful, thanks👌
Thanks for watching!!
this is genius, could this be used to track the habits of multiple people?
Yes it’s fully customizable. Me and my friends are all tracking our habits through Airtable this year using the exact same principles.
@@VicLaranja I'm not sure I was clear enough there. Here's my scenario: I'm a health and fitness coach. Consistency of clients healthy habits is a big reason that they come to me, so in addition to the existing coaching that I do I'm looking to add ONE tracker that they can all use to get individual 'progress' visuals/reports/graphs, yet allow me to run reports against them as a whole or individually, to identify a) clear trigger/action/result patterns for them and b) let me see the areas of my coaching which could be improved/leveraged to better help them all.
I realize I'm asking a lot of google forms, but I've been unable to find a solution elsewhere that can provide all this in one place.
Any guidance massively appreciated.
Hey Mark, feel free to book a call with me though socialgravity.ca and I can consult you on the best method to do this for your clients.
I ❤️ nerds
❤️❤️ truth
where's the template?
You won’t need a template if you follow the instructions. It’s all dependant on what your personal habits are.