Unfortunately, I’ve run into the performance limitation and it makes my app unusable. It’s a shame because it’s pretty much ready to go otherwise.
Here’s an example…
The yellow boxes cover up names to “protect the innocent” but basically what we’re seeing is a table of hours that each engineer is expecting to work on each of their projects in a particular week. The number in the cell is number of hours for that particular project but the colour of the cell is determined by the number of hours that engineer is working across all their projects in that week. If he or she is expecting to work fewer than 20h in total across all projects then the cell is orange. If they’re working between 20 and 40 hours it’s green, and if they’re working more than 40h it turns red to show that he or she is overloaded.
So, when I’m scheduling this particular engineer on project 18110F during week-ending May 5th, I’m only asking for one day (8h) but the cell has gone red so I know that they’re working too many hours on other projects for a different project manager (the whole table is filtered by project manager).
The table is data-enterable, so as I update the hours I want to see the cell change colour as a visual indication that the schedule is feasible.
And it works perfectly! It just takes a whole minute for the colour change to take place. That’s not usable.
You can then go and look at the engineer to see what else they’re doing:
This table is also data-enterable so you can approach the scheduling problem from multiple angles. As soon as the total number of hours in that week falls below 40 the whole column goes green.
The largest table is <2000 rows so it shouldn’t really take a whole minute to add up 7 numbers and change some colours.
Let me end by saying that it’s literally taken me just a couple of days to build all this from scratch which I think is a massive tick for Coda - it’s been really easy to set up and a lot of fun! I just need the performance to improve.
P.S. I also have code to calculate revenue per project as well as plan vs. actual on a quarter and yearly basis. It’s so easy!