Electric Tables V0.2
From the web to spreadsheets and back again
Hey, so Electric Tables V0.1 is a working prototype experimenting with a kind of personal database. Taking the idea of web foraging seriously. Giving URLs some weight - not just treating them as strings of characters but as objects and actions.
But, because of my piss poor coding skills ET V0.1 was single player only. It stores everything in local storage so there’s no login and you can’t share tables with other people…
This was unsatisfying because collaborating and publishing is a key part of the web. Building a full nodeJS backend with login and collaborationg is beyond my coding skills, but I still wanted to build a prototype to play around with that interaction.
So, enter ⚡ Electric Tables V0.2.
From the Web to Google Docs
The insight is to use a Google Spreadsheet as the data storage layer. Then, you can share and collaborate on your tables just like any other Google Doc….
It looks something like this:
And the pop-up is almost the same (though a little less polished)1:
Here’s a full demo video explaining how it works:
From Google Docs to the Web
The interesting thing is because every Google Doc can be used as a JSON endpoint you can publish your data from Electric Tables V0.2 as well!
This opens up a bunch of interesting possibilities I think around collaborative publishing, lightweight list making and so on.. Once you have the data as JSON you can do whatever you want with it…
Under the hood I’m using a Google Script - you can publish it to the web as a macro with a unique URL. Posting to the URL triggers a little cloud function that then crawls the URL, extracts the info and adds it to your spreadhseet.
Because it’s using the Google Script as an endpoint you can use this on mobile too with a simple mobile-optimized page with a form. Just enter the URL and hit submit and it posts the URL to the script. Much easier on mobile than a bookmarklet…
I’ve tested this with friends and it works as a multiplayer bookmarklet where we can each add to the same spreadsheet and collaborate! But unfortunately I don’t quite feel comfortable turning it into a bookmarklet that you can just grab and go because I’m not sure what the limitations are for opening up my Google Script endpoint free for all… (and because it uses eval() to execute the custom extractors….)
Honestly I like the speed and simplicity of Electric Tables V0.1 - it’s snappy and “just works”. But being able to collaborate and publish your tables via a Google Spreadsheet is a key feature…
Maybe if I can figure out how to code nodeJS there will be a V0.3 that combines the ideas…
February 16, 2024
February 9, 2024
January 31, 2024
This post was written by Tom Critchlow - blogger and independent consultant. Subscribe to join my occassional newsletter: