DAILY SUCCESS: 07-24
TOTAL HOURS: 9h 0m
HOURS TODAY: 3h 0m
Devlog #4 (what I did today)
This is a bit late because yesterday sucked. And sucked. And sucked. But I still got it done so yay!
• Cleared out unnecessary formulas for the tables in the (Feedback Tables) page and renamed stuff to new standardized naming conventions.
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Feedback-Tables_suXmE#TBL-Feedback_tuy8V/r2
• Renamed all tables (currently unused) in the (Changelog) page
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Changelog_susBU#_luu0n
• Changed a top-level calculation naming to be more accurate and removed the other top calculation as it cannot be used right now.
• Renamed tables in the (Doc Users) page to new standardized naming conventions.
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Doc-Users_su5EG#_luuQv
• Renamed tables in the (Squads) page to new standardized naming conventions.
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Squads_suhbq#_luWFg
• Went through ALL tables in the (Tracker Tables) page. ALL tables had the following done to them: Renamed user-facing columns to be user-friendly (column starts with emoji), renamed tables to the new standardized naming conventions, renamed columns to make more sense, renamed tables to make more sense (purpose/description), deleted many columns that had superfluous formulas, redid a few formulas that were necessary but inefficient, moving some formulas into other page-level calculations or into other tables to increase speed of calculations (multiple formulas calculating the same thing is inefficient, just try and calculate values once p/ formula and reference that formula)
• For some of the tables: added proper row IDs, added a sort ID, extracted the momentum formula for later use, changed the path at which goals are linked to editing goals, added some necessary columns
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Tracker-Tables_suAga#_lu0nC
• I split the main (Tracker Tables) page into 3 total pages. This was done for (A) better organization and (B) to create a proper backup cycle. The 2 NEW pages are (DATA (Tracker Goals)) and (Rating Tables).
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/DATA-Tracker-Goals_suR_Q#TBL-Tracker-Goals_tuEhl
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Rating-Tables_sugIP#_lurBA
• The DATA page specifically separates the core goals table (1000+ rows) from everything else so that the (TBL Tracker Goals) table can be manually (via button) copied to a new "backup" page then have all rows older than 14 days deleted. This reduces the 1600 rows (of the main table) down to 400 rows which reduces the lag on site load from ~15s to ~5s/7s. This process will be done each week to keep the total row count low while still having ALL HISTORICAL ROWS in the backup page.
• While making the DATA page it was discovered that the EXACT cause of the lag on site load was GROUPING (main issue) combined with a HIGH ROW COUNT (the X multiplier). This knowledge will be used to design a new goals interface that doesn't have this combination of Bleach + Vinegar.
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/DATA-Tracker-Goals_suR_Q#_luEhl
• The (Rating Tables) page was created to separate out the tables relevant to the rating system as there was enough information/tables to justify it's own page for organizational reasons.
• Created a new 3-Point rating of (0, 1.5, and 3).
https://coda.io/d/Squad-Tracker_dZU1bEb_cQW/Rating-Tables_sugIP#_lurBA |
|
DAILY SUCCESS: 07-23
TOTAL HOURS: 6h 00m
HOURS TODAY: 2h 30m
Devlog #3 (what I did today)
This is a bit late because Stickk's servers were down when I was trying to post this.
I read through some very valuable research material. It was useful to learn how to use auto-sorting based on controls/tables. Also how to most efficiently store data (even more extreme than what I already learned) in essentially data tables. Also reading through use-cases of actual businesses trying to implement or implementing Coda. Learning the pure use-cases of Coda. What it can do *very well* and what it can do *so-so* and any design limitations. A mindset for accommodating for DB growth. Quote "if you apply grouping it’s gonna become 5x slower, if you filter it, 3x slower." How efficient-design for tables/formulas/etc. is absolutely critical. Using "grabs" instead of formulas.
https://community.coda.io/t/size-limits-doc-design-best-practices/15989/25
https://community.coda.io/t/why-would-you-not-try-to-manage-all-a-tech-start-ups-stuff-in-coda/13337/57
Since these posts are very long and very dense, it took most of the time to go through them. I found these posts from asking generalized questions that I had when designing the doc and writing formulas.
I also continued work on trying to make the doc load faster. I'm working on a temporary solution to make it more usable (load faster) after which I'll start designing the new interface that should load extremely fast and have better UI.
First I finished the semi-new display for editing default goals then I started trying to understand all the components that the massive 1000+ rows goals table was using to function. It has a lot of formulas that can be either optimized, depreciated, or moved elsewhere.
|
|
DAILY SUCCESS: 07-22
TOTAL HOURS: 3h 30m
HOURS TODAY: 3h 30m
Devlog #2 (what I did today)
• Updated table //TBL Ratings All Values// to be faster. (less formulas, less junk, less messy)
• Updated table //TBL Rating Types// to be faster. (less formulas, less junk, less messy)
• Added another rating type that is called "3 Point" and has numbers 1, 2, and 3. (i.e. 0%, 50%, 100%)
• Updated name of table //EDT Momentum Icons// to represent that it is an EDT table.
• Updated table //TBL Goals To Auto Create Each Week//.
- I made the column names much more user-friendly
- Changed some of the formulas to be faster
- Sorted through the columns and found ones to delete. They cannot be deleted right now, but hopefully I'll get to them this week.
-Renamed the table and columns to better represent their purpose.
• Updated table //TBL User Goal Editing//
- Sorted through the columns to understand what was happening
- Got mostly finished improving the layout of the "Edit Goals" pop-up. Not done yet, but it's more user-friendly, easier to understand, less cluttered, etc.
- Renamed the table, some columns, and the buttons to better represent their purpose and/or be more user-friendly. |
|
TOTAL HOURS: 1.25h
HOURS TODAY: 0h |
|
5218266521825252171295214890