Home > Google > Google Calendar Events via Google Form

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.

screen-shot-2016-09-08-at-8-37-40-pm
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.

screen-shot-2016-09-08-at-8-38-03-pm

That’s about it.

Related posts

Google Script Drop Box/Display Package

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 […]

Google Zeitgeist as a Writing Prompt

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) […]

Embed Collector Tool

Some people don’t have websites handy or their blogs won’t allow iframe embeds. They should still be able to have their students do stuff and get it all in one place. This is the Internet! And this tool is meant to deal with that. You can see a working example with three submissions (via a Google Form) here. It’ll take any iframe or HTML as a submission. The search box will also filter based on all the additional material associated with the element in the form. For instance in our example you can type “Sarah” and you’ll end up with one item. So the way this should work is you click here and accept the copy. You now have the spreadsheet and form. The directions are on the sheet labeled directions. I have a dramatic green arrow pointing at it in the image below. You can edit the form associated with the sheet under Form>Edit form. The only thing you have to leave/have in the form is the one called “The embed code.” Everything else can be deleted and/or changed. Stuff I Learned This pretty much a mashup of two recent projects – the personalized fridge poetry and the Angular/Google Sheets JSON stuff. This one runs entirely in javascript so to use the $_GET option, which javascript doesn’t have, I […]

Comments on this post

  1. Jeff Everhart said on November 3, 2015 at 3:09 pm

    Any reason you don’t just tap into the form submit event array? https://developers.google.com/apps-script/guides/triggers/events

    It could pretty much entirely cut out the getLatest parts of that function. Since the form submit event returns an array, zero indexing would apply. Here is an ex from a post I’ve been working on. Looking to make a tutorial vid in the next few days:

    http://www.jeffreyeverhart.com/2015/11/03/how-to-create-a-google-calendar-event-with-google-forms/

    You’re doing some cool stuff with Google apps 🙂 I’ll be back! Cheers!

    • Tom Woodward said on November 3, 2015 at 3:17 pm

      I blame it on ignorance. 🙂

      Thanks for the tip and so very happy to see the post.

  2. Johan Horak said on March 18, 2016 at 8:23 am

    Hi

    I want to create a form that will update x number of calendars depending on the x selected when the form is submitted.

    I can use the old FormMule script but not sure if it can send events to different calendars.

    • Tom Woodward said on March 18, 2016 at 1:57 pm

      Johan – That should be possible. I think just push the various calendar IDs into an array (based on the form choices) and loop the event creation piece for each calendar ID.

      I’m at a conference at the moment but I’ll make a demo in the next week or so.

      • Johan said on March 18, 2016 at 11:42 pm

        Thanks for commenting Tom. Appreciated. I am looking forward to the demo if you have the time. BTW: I think I can do the first bit but not sure about the last “looping the event” 🙂

        • Tom Woodward said on March 22, 2016 at 11:13 am

          Here’s the loop for adding to multiple calendars. You’d just work it in with the create event portion and map fromSS to the form entry that allows users to pick the calendars. I’ll probably rewrite an example that takes advantage of the simpler version Jeff created and adding this element. That’ll probably happen this weekend at the latest.

  3. Sebastian said on March 23, 2016 at 9:23 am

    Hey Tom,

    Thanks for posting this. I have a question: What adjustments would I have to make if I wanted to schedule the event for a specific time instead of for specific dates? Example: Monday, July 25th from 1 pm to 4 pm.

    Would appreciate your help on this.

    Best,
    Sebastian

    • Tom Woodward said on March 23, 2016 at 9:34 am

      Pretty sure this one will do that. You just have to activate the time option in the form date field. If it doesn’t (and maybe you should anyway) take a look at the script Jeff references above.

  4. Eric said on March 23, 2016 at 10:22 am

    Thanks for the great information! Not sure if my previous comment posted so I’ll try again.

    Hopefully you can help me with a couple of questions. I almost have what I need but I can’t seem to figure out two details: (1) I would like to make it so that there is a default end date/time (always two hours later than the start date/time) built into the script and therefore NOT entered manually at all because (2) I would also like to add recurring events with two specific options–a one-time event and another option that allows me to repeat the event 12 times. Does that make sense?

    Is this something you would be able to provide some suggestions with? I haven’t had any luck in my efforts up to now and with only limited programming experience.

    Thanks,

    Eric

    • Tom Woodward said on May 22, 2016 at 10:49 am

      Sorry Eric. Your comment got caught in the spam folder . . . which I need to check more regularly.

      As penance, I’ll try to write a decent post about this in the near future. In the meantime . . .

      1. You could create an auto-end time in the script itself by doing something like (pseudo code- obviously)
      var endTime = startTime+2;

      2. You could make the initial question something like ‘is this a one time or repeat?’ If they choose repeat, you’d set the variable in the script to 12 if (column A = 'repeat') { var repeat = 12} else {var repeat = 1}
      Then you’d loop through the event creation 12 times incrementing the date variable in whatever way you needed.

      Tom

  5. jeff yeage said on September 8, 2016 at 4:33 pm

    I am completely new at this,

    I am experiencing an issue wherein when I submit the form, the information is recorded in my google worksheet,

    however.. unless I open the script editor and run the script the script doesnt function..

    I am sure I am missing something? just not sure what.

    • Tom Woodward said on September 8, 2016 at 7:40 pm

      Yep – you want to set the script trigger to fire on form submission. I did not have that in the directions. I’ve amended them.

  6. loublotter said on January 12, 2018 at 3:39 pm

    Just wanted to say thank you for the code and the clear explanation. Automated vehicle submission thanks to you at my non-profit. Appreciate it.