Spreadsheets, Forms and Forks
summary
A WordPress prototype turns a Google Spreadsheet into a live city budget site, then the JavaScript is extracted into sheets.js that uses Tabletop.js, Leaflet and Mustache to make maps and searchable tables. Google Sheets acts as the editable backend (rough limit ~400,000 cells), Github Pages or Glitch provide forkable hosting, and Glitch adds a Glitch backup JSON API so the spreadsheet can be restored if someone removes it.
AI-written summary · about
chapters (25)
- 0:00Start
- 0:22Repositories with the most open source contributors
- 2:50Magic WordPress Theme
- 5:03Spectrum of websites
- 5:33Despite the tricks, there are hurdles
- 6:34Spreadsheets!
- 7:10No deploys, just edit sheet
- 8:01Sheetsee.js
- 8:41Visualizing
- 8:52Spreadsheet data
- 9:15Public Spreadsheet
- 9:27Sheetsee Modules
- 10:15Sheetsee CLI
- 10:46Tables+
- 11:45Sheetsee Charts?
- 11:56Use Tabletop.js
- 12:16Create a placeholder
- 12:41Sheetsee Maps
- 13:27Sheetsee Tables
- 14:21Sheetsee Core
- 14:35Beyond Basics
- 14:55Math(s)!
- 15:12IFTTT
- 15:44Google Forms
- 16:19GitHub Pages
related talks
24mThomas Wilburn - SeattleJS Conference 2017
21mLightweight community mapping sites, powered by spreadsheets
24mJavaScript, spreadsheets and API
09mLightning talk from Sean Grove
40mHTML Re-imagined for the era of web apps
44mDeveloping a good editor experience with Microsoft 365 / Google Workspace
16mInterfaces: Interacting Knowledge with WordPress
32mBuild a Google Docs clone with CKEditor 5 & Vue.js Solution LIVE