flâneur

My favourite tech stack is Google Sheets | by Justin Xu | Medium

medium.com · 1,217 words · saved by 1 readers

To the surprise of others, I whip it up in Google Sheets using a combination of formulas, macros, and fancy formatting. The result looks surprisingly complete — not enough to be a public web app, but enough to satisfy the original need: an internal tool. Broadly, I create two kinds of tools in Google Sheets, which I think of as How I do all of this is worth its own entire unwritten series of posts — or you can visit Ben Collins’ site, where he offers excellent tutorials. But why Google Sheets in the first place? Google Sheets provides everything you need to implement whole applications. It also comes with I find developing in Google Sheets to be extremely quick. Part of it comes with practice, but it’s also due to the WYSIWYG nature of the tool — no jumping back and forth between code. You can test a formula in the same cell you’re writing it in. Filling a formula down (or using ARRAYFORMULA) instantly applies it to all of the data. Changing colours or size is just that — you can do it

My favourite tech stack is Google Sheets Justin Xu 5 min read · Dec 7, 2021 -- Listen Share About once a year, I’m called upon to build an app for “internal” use: a personal calendar system for myself a notetaking app for daily scrum a gaming statistics dashboard for my friends a tournament bracket for a table tennis club a tool to investigate data inconsistencies at work To the surprise of others, I whip it up in Google Sheets using a combination of formulas, macros, and fancy formatting. The result looks surprisingly complete — not enough to be a public web app, but enough to satisfy the ori

saved by

related reading