OK, here's what I settled on for the jazz practice sheet. I'm going to use a flat structure, and I created two new fields, one for the practice description, and another for the time spent practicing. So each line should look like this:
date, practice description, minutes, (and of course the html pane for comments)
For the practice description, I made a new field instead of using the "Item" field so that I can use dropdown lists to choose between a handful of prenamed descriptions. I can post a screenshot of it later (it's at home).
The great thing about this method is that sometimes I will only practice one item a day, and other days I may practice multiple things, and this will be able to handle both easily because each line will have the date on it. So if I practice 4 things, there will be 4 lines for that date. No need for a hierarchy. And the dropdown lists will assure consistency in the names.
I love this program, I really do.
-superboyac
I'd recommend you start by creating a new grid, called JazzPractice, which will automatically create a folder (field) of the same name. All items you create there will be put in that folder and they'll conveniently be displayed in the grid (you may have done this, but just in case you didn't). You can later on apply a date filter using the DateFilter toolbar.
Your structure is both simple and powerful. With this structure, the pivot table/chart will be able to show you total time spent per day, week, month, per description, calculate the average practice duration, etc, as a summarizing table or chart. Export as a web page and link that page to a summary item HTML pane content.
I can see that you're really starting to grasp how to use SQLNotes to solve information management problems. It's great to see how you went from inquiring about it, to being totally confused, to seeing the possible use but not knowing how to go about it, to finally seeing the light and now flying on your own. Congratulations.
Perhaps you'll want to share it on / improve the SQLNotes wiki documentation (
http://sqlnotes.wikispaces.com/)
A few thing you can add to ease the data entry
1- Set AutoAssign rules for the JazzPractice field to A:Date=int(now). This will automatically fill the date for you
2- You can do the same for the description field if most of the time, the same description comes up
3- You could use forms (with default values) to facilitate data entry (but in this case, a simple grid should suffice)
Special thanks to you, this thread has made it as #2 in the Best Software of 2007, thanks to your initiative!
https://www.donation....com/2007/index1.php
Recent Posts
)
)
)
