I realized that I could build this using a Google Form for entering data, a Google Sheet for storing and analyzing the data and an Apps Script for sending a daily reminder to fill the form. This info is converted into charts to help you track your mood over time and to identify correlations between certain types of events and your mood. There is usually some way for you to enter how you're feeling along with additional information about that day or the previous night. When I was researching the mood tracking apps that were available on the various app stores, I realized that that they're just glorified forms with bells and whistles. The next step is to design the solution such that the above requirements are met.
#MOOD TRACKER WORKSHEET CODE#
A good problem definition must go beyond what the code should do. In general, it is important to get customer input when defining the problem. I also want this data stored such that I can analyze trends or generate reports. I want an easy way to log my mood everyday along with whether I ran that morning and how much sleep I got the previous night. In this case the problem definition is easy since I am going to be the only user of this product. Once I've defined the problem, I like to jot down the key product requirements that the solution must satisfy in order to solve the problem well. If I get the problem definition right, the odds of building a good solution also become higher. In the beginning, when thinking about a new product to build, I like to start with defining the problem I'm trying to solve. Product requirementsĪs a product manager and an entrepreneur, I LOVE the process of designing and building products. In the rest of this article, I'll describe how I built the app so you can build one for yourself. I realized that I could easily build a simple app using Google Sheets and Apps Script that would address most of my requirements.
The various off-the-shelf apps were either too simple and lacked customization options or were too complex with many knobs and dials. For apps like this, I prefer starting simple and then making changes over time. For example, I currently believe that sleep and exercise have a huge impact on my mood during the day but perhaps there are other factors that matter more (such as my diet). In addition to privacy concerns, I was also not convinced that a one-size fits all app would work for me.
#MOOD TRACKER WORKSHEET INSTALL#
I wanted to give a few mood tracking apps a try but I really did not want to install an app for this simple use case. I had never considered tracking my mood, although, I sort of knew that I usually felt bad if I hadn't slept enough the previous night or if I hadn't exercised that morning. I recently came across this discussion on Hacker News that introduced me to the idea of tracking my mood.
#MOOD TRACKER WORKSHEET HOW TO#
In this article, I will teach you how to build a simple Mood Tracking app using Google Sheets and Apps Script.
0 kommentar(er)
