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

01

Google Form to Google Sheets to Vue Website

When @cogdog & @twoodwar Were Building Websites From Google Spreadsheets Years Ago https://t.co/Im7oCecvpg — Keegan?Long-Wheeler (@KeeganSLW) February 28, 2018 This post from Keegan kicked of this demo.It also made me feel old. I can’t believe I’ve been doing this for so long. The goal is to create a pretty flexible template for using Google Forms to Google Sheets to simple website. I opted to do this one in Vue but may get around to doing it in plain JS or jquery if time allows. The first thing you need to do is make the form and put in some entries. You’ll be happier if your form prompts aren’t super long. Make them readable just keep them concise.There are ways to deal with that but they add steps so I’m ignoring them in this post. Once you’ve made a few entries so you have some data to work with, publish your spreadsheet as HTML. File>Publish to the Web. Click OK and what not. Don’t bother going to that link as Google has made that a fake promise. You just need the ID of the document in your current view. It’ll be something painful like 12WsyLvtfIPJkCXgEXsRkrI6dS0_K6brJikZqzkQa8TU and is visible in the URL after the /d/ but before the /edit. You can see the spreadsheet here. It doesn’t really matter but !full transparency! […]

A screenshot of the art-based baseball cards.

FotoFika Art Baseball Cards

Origin Story The 2020 All Stars projectWarning. There is nudity. Art nudity. is tied to the FotoFika site supporting photography faculty teaching online due to COVID. One of the concerns that came up in discussions was that this year’s graduating class wouldn’t be getting the personal connections that normally happen during exhibitions. That led to a discussion around Mike Mandel’s baseball card series for photographers back in the 1970s. The idea here is that we’ll generate baseball card-style images for graduating students. We’ll have a second portion where curators will be invited to comment on specific artist cards and their comments will be integrated into the card. Some portion of the cards will eventually be printed.I’m hazier about this side of things but I’m likely to be messing around with some InDesign workflow based on the data we have. Technical Stuff of Interest The site ends up being interesting in a few ways. It’s running off a Google Form for image uploads etc. What you may or may not know already is that Google stopped letting you serve images from folders in any sort of decent way a while back.6 months? A year? What is time? Who cares? The past is the past. Sure you can do stuff like what the Awesome Table people suggest here but the image quality […]

Fridge Poetry – Google Sheets as Database

Back in 2013 I built a refrigerator poetry page using javascript. I really wanted to make it so anyone could add any words they wanted in some easy way but didn’t have the skills to do that at the time. It’s been hanging out in the back of my mind since then and the bits and pieces I’ve learned since then now make it pretty straightforward. This url will prompt you to copy a Google Sheet. That’s a nice little trick- just append /copy to the public sheet where it normally says /edit?usp=sharing if you copy the typical sharing URL. Sadly, it only works for Sheets. Once we’ve published the sheet, we now have a JSON feed of the data and the little URL trick in the Google Sheets gives you the URL to the fridge poetry page with Sheet ID included as a parameter. (That’s the chunk after the question mark.) http://bionicteaching.com/fridgepoetry/google_words.php?id=1KExHjArU6ZAR2l2r00XYWHAAUen-Z6WOQGchHWmPs-4 The PHP to make all the words into divs is below. I usually do something like feed->entry->$t to parse out the JSON but that didn’t work with the Google Sheet data.I think, in part, because of the use of the $t as the title. I wonder why that’s the way Google does it. I still don’t quite get things well enough to know why but this alternate […]

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.