Photo by Unseen Studio on Unsplash

Row based Coda

A remedie to inefficient spreadsheet logics

In this blog you read how to create a table prefilled with dates, related properties and other variables. I created this in response to a question in the community you find here.

As you can read in this blog, I became a moderate enthousiast about showing tables to doc users. Most people get an uncomfortable feeling, maybe even a panic attack when they see formulas based on functions they don’t understand. There is more than one good reason to keep tables out of sight in many scenarios. However it happens you want to show parts of a table in a specific manner and this approach is a possible way out.

It is all about the row based logic dominating

Coda

tables. You do not create 365 columns with dates, you create one and this one has 365 (or 366 in 2024).

Step 01 — creating dates

We start with the creation of dates and related properties in a table. You may want to have such a table for all sorts of reasons. I remember that in certain planning tools we needed this. We work in a few steps.

• We create a canvas button
• We apply the function AddRow()
• We create a list of dates using Sequence()
• We do something with each date using ForEach()