Today's Rows (Data Entry Filter)

Just sharing a data entry hack I use a lot. The formula below is applied as a filter, and uses the cool properties of thisRow plus Coda’s natural date processing to make it very easy to limit rows to recent items (either created or modified). You can easily tweak the formula to use minutes(), hours(), or any other time formula Coda supports.

days(now() - thisRow.Created()) <= 1

If you’d like to just see rows that changed within the last day, change thisRow.Created() to thisRow.Modified().

7 Likes