A pack that allows you to create all sorts of tables from formulas
Welcome to the Formula Tables guide!
This guide is work in progress
If you’re a smart cookie, you can totally use the pack already!
Just follow the requirements below.
But all the demos and formula examples are coming a little bit later.
Heads up!
You can pass any list of lists as the table’s Data parameter. Cells can be simple text values and numbers, as well as references, canvases, formatted values (currencies, date/times etc) and lists themselves.
However, to pass those data and let the pack process and display it correctly, you need to do it like this:
Don’t
List(
List(...)
List(...)
)
Don’t just provide the list of lists — Coda will not preserve it correctly when passing it to the pack.
Do
List(
List(...)
List(...)
).WithName(M,
Object("data", M.Splice(0,0,""))
)
Wrap your list of lists into an Object() and include one item that’s not a list into your outer list.