[lolive]

To anyone using Google Sheets as its data layer: be sure never to create a primaryKey column, always use the title column. Also be sure to use one single spreadsheet with many tabs, and coreference cells by their sheet/line/column. That’s such a superb mental model of what your data represents. Of course denormalize your data without caring. Tabular model is not good at managing cardinalities, but [truth to be told] neither is our brain. Also use AppScript for formulas and business logic. Your future dev will love reverse engineer it. Then when things become hairy, hire an IT consultant and pay him well. Be sure to complain that his added value is limited wrt this Gsheet chef d’œuvre.