Google Calendar Events via Google Form
This script allows you to setup a Google Form that adds events to a calendar. It’s useful.
You’d make your form first and calendar. Then you’d adjust it to reflect your particular column order and calendar ID. Finally, you’d add the script to your Google sheet (where the form submissions end up).[Edit]
You’ll also want to set your script trigger to run on the submission of the form.
While in script editor, you’ll see a little clock icon. Click it and add the trigger so that the function runs on form submission.
That’s about it.
This is another SPLOT-ish tool that takes videos uploaded through a Google Form and then displays them.This one actually works consistently, unlike my recent attempt at silent form submissions– which I’ll return to at some point or another. This particular proof of concept was built in about ten minutes as a result of a conversation with our World Language faculty who are going to be doing student-to-student video work with people from other countries. We’re likely to use Zoom as the platform. It makes recording the video easy and the compression of the video is pretty impressive. Initially I was concerned about file size but between that and seeing that Google allows up to 10GB file uploads via their vanilla forms. The caveat there is that the “file upload option is only available for G Suite customers with a Google Form shared within their organization.” Good enough for our purposes but a bit limited if you wanted to use it more broadly. Form Stuff I opted to auto-log the VCU email address since the file upload required that anyway and only used two other elements- a file upload piece and a single categorical element. You could get much more complex if you had the desire. Just make sure you’ve created a results spreadsheet and published it to the web. The […]
flickr photo shared by NASA on The Commons with no copyright restriction (Flickr Commons) It’s that time of year when you try to prove to your institution that the work you do matters . . . and I am prepared to make it rain datums.That’s just for Jon Becker. I’m not sure how valuable this will be to others but who knows and it helps me to write it down. Currently, my former team of 5 is now just me. So this stuff is sole mioThat’s for Jim Groom. Viva Italia.We still have some people but we are significantly reduced. I think maybe 7 people down. and compasses everything from manual password resets to full on custom development work with faculty. Can you tell when the semester started? That’s an increase of abut 2,400 sites in about 3 weeks. I’ve got our weekly Twitter/Google Sheet spitting this out and writing it to a spreadsheet so this data was handy. I’ve been playing with logging data for a variety of reasons. For instance I now tag my rampages support emails in GMail and that logs them to a spreadsheet each night. I’m at least mostly consistent doing that because it’s a very light weight action on my part. I can then get an idea how stuff is really playing out rather […]
It seems like the widget that allowed you to embed Google Earth tours (with audio and motion) online isn’t working. We had at least one person in the county who wanted to be able to do this because they’d seen this Jimmy Buffet tour. Compared to teacher assessment and other bottomless problems this seemed pretty attractive, especially using the Buffet page as an example. I hacked off most of the extraneous parts and this seems to serve the purpose although there are a few more pits that ought to be carved off. You should be able to download the source HTML at this page. Once you do that it’s just changing two URL strings from what they are now (http://etechplace.org/debordenave/wp-content/uploads/2013/02/Bon-Jovi-Tour_KCJ.kmz) to the URL for wherever your KMZ source file lives. The example is below in an iFrame and it will likely play automatically. My apologies for that.