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).
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.
flickr photo shared by cogdogblog under a Creative Commons ( BY ) license Because I still read the posts from the good people over at HCPS I came across Doug’s post on a script that Michael Price wrote. The script sets up a form that lets anyone upload a file to a Google Folder.There’s also the potential to use it like a Google Driven Piratebox. It intrigued me so when one of our professors was asking about allowing students to upload raw video for other students to use, I figured I’d check this out as a solution. You can/should get the basics from the video that’s in the post above. I made a few alterations based on our particular needs. One, I wanted the folder to be viewable by anyone so they could get the files easily. I could have set the sharing permissions after the creation of the file by hand but . . . I didn’t want to.Computers should enable me to be lazier in the long run. I also wanted to tighten up the connection between submission and being able to see all the results. It turns out you can’t currently iframe any of this without drama so I included a link to the folder after the submission and demo’d using the Google Folder WordPress plugin I […]
So the folks over at Google Blogoscoped had a great idea. Use Google trends as a writing prompt. For instance, if the top queries are … 1. subaru impreza 2. priyanka chopra 3. build a bear … and so on … … then your narrative may go like this, to quote from Simon’s try: I went out and bought a brand new Subaru Impreza last week, which was very scary as I have only just passed my test. I took Priyanka Chopra, the Indian film star, with me to keep an eye on me and exert a calming influence as I was pretty nervous because the Impreza is wild beast of car. “Let’s go build a bear”, I shrieked as we weaved through traffic, “an actual live bear that will do our bidding”. “Good idea,” agreed Priyanka, “This bear could drive us around too, anything would (and so on) … Morphs pretty well into a fun writing prompt that uses subjects that are, by definition, things people are interested in. Ways to take it to the next level- write the zeitgeist as a character or historical figure use the words to take the pass the sentence game to the next level see who can make the longest sensible sentence with the fewest additional words (not listed in the trends list) […]