Coda.io and Previous Rows

Daily Measurements

  • I wanted to see how this day related to the previous day
  • I needed a column that helped me to define my long term targets. Thus how many kilos in how many days or months to get some realistic numbers.

Previous day

step 01 :thisTable.[Targets in Kg].Nth(Find(thisRow,thisTable )-1)
step 02: thisRow.[Targets in Kg] - thisTable.[Targets in Kg].Nth(Find(thisRow,thisTable )-1)
PreviousRow Logic Applied
appling an If statement to start with an empty cell in case it is the first one
Find(thisRow,thisTable)
The importance of working with lists
DeltaSum Explained

The DeltaSum

thisTable.Delta.slice(1,thisRow.RowIndex).Sum()

In short

Huizer Automation on how to apply a PreviousRow logic in Coda.io

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store