Here’s a mega trick how you can implement a gorgeous dashboard in Coda:
Create a table with a single row. Pull in all the data you need into columns. Each dashboard element (a chart, a table etc) — a separate column. By pull I mean either import the whole table or some filtered subset:
Make a Details view out of that table. Go to Customize Layout, and select Quick Style 3:
Quick style 3 has one big advantage: you can have two equally wide columns that flow independently. If you don’t use Style 3 but simply put elements one besides another, the shorter one will resize to fit the height of the taller one, and you may not want that:
Style 3 will draw a vertical line between columns, but I guess you can live with that.
- PSA: for all those nested elements, you can actually use charts, nested detail views, calendars, cards etc, not just tables! You can virtually do anything that you’d do on the canvas. There’s no filter dialog, but that’s what the
.Filter()in the lookup formula for.
Mad props to @Francesco_Pistillo for surfacing this functionality to me. Too bad his post from half a year ago that went totally unnoticed. I’m just helping to resurface it here.
One more reason to name when persuading your teammates to migrate from spreadsheets to Coda
Demo (best view in separate tab)
And don’t forget that this exists too
Please subscribe to codatricks.com if you haven’t already — I’ll gather all the tips and tricks I’ve discovered under one nice blog… when I’m done with all the freelancing assignments and have time to finally author it