Are you looking for low stakes ways to store and display data? Welp, here’s Google Sheets. Do you want to automate all of the boring parts of your job and sip a drink on a beach somewhere? Looks like you owe Google Sheets a beer. Have you ever wanted to build a lightweight full stack application without spinning up an orchestrated Docker container cluster running on AWS using Typescript that has 90% unit test coverage. Well, hold on to your hats, cause Google Sheets is about to hit 88 MPH while keeping your molecular structure intact.
At VCU’s ALT Lab, we’ve used Google Sheets to build educational experiences that range from novel, to complex, to entirely absurd. Brace yourself for temporal displacement and a little but of JavaScript.
Tag: Google Sheets
👓 Creating a CRUD Web App with Google Sheets | Jeffrey Everhart
In this post, I talk about how to build a fully-functioning web app with Google Sheets and publish it on Google servers using Vue.js and Google Apps Script.
🔖 Creating a CRUD Web App with Google Sheets | Jeff Everhart
In this post, I talk about how to build a fully-functioning web app with Google Sheets and publish it on Google servers using Vue.js and Google Apps Script.
Here’s @J_Everhart383‘s post for a simple voting app using Google Sheets for as a CRUD database https://t.co/FYOjl9q5Tt #Domains19
— Martin Hawksey (@mhawksey) June 11, 2019
👓 Hypothes.is Collector | John Stewart
In order to make it easier to track activity in Hypothes.is, I created a program called Hypothes.is Collector. The idea is that you can type in user name, a URL, a tag, or a group ID and click the button to see all of the related annotations. The program will create a new sheet with an archive of up to 200 annotations based on the search terms. It will then create a third sheet that will count how many of these annotations were made on each URL in the set by each user.
👓 Google Sheets Blogging CMS, part 1 | John A. Stewart
For example:
- How easy/hard will it be for students to own/export their data after the class?
- How might they interact if they’re already within the DoOO cohort or already self-hosting their own space?
- What are the implications for students of maintaining multiple spaces with a variety of technologies and therefor overhead?
- I’ve never had a lot of luck with Disqus, which I find to be heavy and often has problems with auto-marking all of my content as spam. I’ve definitely found it to be an issue with using for POSSE workflows. Worse, with the introduction of specifications like Webmention to the DoOO space, students could be writing their responses to classmates and teachers on their own sites and thereby owning all of that content too, but with Disqus, this just isn’t possible.
I’ll reserve judgement for once I’ve seen some of the code and further ideas in parts II and III as I suspect he’s likely taken some of these issues into account.
We’ve played with this concept of front-end blogging for a while now. Alan Levine has built an open sourced tool called TRU Writer that even provides this type of front end interface on a WordPress site. ❧
I’m curious if John, Alan Levine, or others have yet come across the concept of Micropub? It generalizes the idea of a posting client and interface so that it could work with almost any CMS-related back end. I could see people building custom micropub clients for the education space, or even using some of the pre-existing ones like Quill, InkStone, or Micropublish.net. Many of them also use JSON or form encoded data that they could also be using with platforms like the one John describes here. The other nice part about them is that they’re flexible and relatively open in more ways than one, so they don’t necessarily need to be rebuilt from scratch for each new CMS out there.