I’m starting to build more of our internal project management off of Coda - really really enjoying it thus far. A thought that I had this morning was to attempt a burndown chart of outstanding tasks in a simple to do list, but I’m stuck trying to figure out how to record a date entry when a checkbox is ticked "i.e. marked complete).
Does anyone have any advice? I need to dig waaay more into the script functions available in Coda, but my precursory browsing hasn’t quite dug up what I need.
Hmm, that would work, although wouldn’t be very fool proof, as modified would be ticked by any type of change. It’d be really easy to accidentally screw with the data set.
Btw, you should be able to use buttons to do this now. Instead of a checkbox, create a button to mark something as complete and have it both log the time and change the state.
@shishir’s suggestion of using a button to mark a task complete and record the time that it was clicked is a great way to go. I prefer this method because it gives an actual timestamp that isn’t easily accidentally changed later. From a schema perspective, it’s a deliberate action that marks the time.
Here’s an example so you can see how to set it up…