coda your time sheet

Coda your time sheet

3 simple steps to keep track of your time

I got an interesting question of my friend and neighbor to help him with some inspiration for a time tracker. I use one with clients that each day notifies them with the work done that day. That was not what he needed, it should be small and simple. It also should making mistakes hard.

We have set up in which each day, the new value of the day is the date of today: value for new row — Today(). We want the starting time of each time block, not the end time, only the start time. Last but not least we can add variations like work type, clients etc.

In a few steps you create your own set up. We start with getting all the time slots after this one, or in technical terms, the time slot living on thisRow.

Getting all time slots after

Second, we compare the next one with the one on this row

get the task duration

The code snippet you need, you find below.

thisTable
  .Filter(
    theDate.Contains(thisRow.theDate) and
      startTime > thisRow.startTime).startTime
  .First().IfBlank(thisRow.startTime) -
  thisRow.startTime

Third, we create a button that opens a new row permitting to add the new task. The button opens in full screen and contains a close button that deletes the task when the project name is empty or when the start time is empty.

open in full screen to enter the task

So here we are, in about 15 minutes you are done. There is not much to fill out. Of course you can add all sorts of fields. It depends on your overal goal. Anyway, try to keep it simple, everybody benefits. I added a template showing how it works.

Coda and a plea for simplicity

time registration

My name is Christiaan and blog about Coda. Since the summer of 2023 mainly about how to Coda with AI to support organisations dealing with texts and templates. The latest Coda AI update was on Dec 7, 2023.

Updates to Coda AI credits, analytics, and features

Why I focus on Coda AI you can read here: ⤵️

Why I focus on Coda AI?

I hope you enjoyed this article. If you have questions feel free to reach out. Though this article is for free, my work (including advice) won’t be, but there is always room for a chat to see what can be done. You find my (for free) contributions to the Coda Community and on Twitter.

Coda comes with a set of building blocks ー like pages for infinite depth, tables that talk to each other, and buttons that take action inside or outside your doc ーso anyone can make a doc as powerful as an app (source).

Not to forget: the Coda Community provides great insights for free once you add a sample doc.t