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.
Related posts
Custom Web Form to Google Sheets
Sometimes the options given in Google Forms just won’t quite work for what you want to do. Maybe you want a particular look, or an interaction, or whatever that Google Forms just won’t do. Luckily, it’s not too hard to make a custom form that can do whatever you want and still has the ability to write the submitted data to a Google Spreadsheet and the form HTML is still served by Google. The following steps should get you up and running and comments in the scripts should provide additional details. Make a new spreadsheet in Google Sheets. Go to Tools>Script Editor Select all that stuff and replace it with the content below. Replace the string of ****** with the ID of your spreadsheet. Then save it. If you get any permissions prompts approve them. Make a new HTML page (File>New>HTML File) and name it index.html Select all and replace it with this.This is as parsed down as I could get it so it’s easier to understand (I hope). Save it. To make sure things work, let’s publish it (Publish>Deploy as Web App). Now go to that URL and submit something and see if it goes to the spreadsheet. If so, great. Now you can start customizing the form to reflect your needs. This form should now write to a […]
CSV Parser Shortcode Plugin
flickr photo shared by The Library of Congress with no copyright restriction (Flickr Commons) The title just rolls off the tongue, yes? But what it does is kind of interesting. It’s not a drag/drop solution but it starts to show how we can better knit different services together. In this case, I run a Google Script to generate a spreadsheet of files (I can probably make that a straight up API connection in the near future). I publish that spreadsheet as CSV because Google sheets to JSON feels a good bit slower.I have no data to back me up but I’m relatively sure that’s true. Then the following shortcode (but w/in square brackets) generates the little unordered lists below. It’s taking that list of 464 files and just chopping out the ones where the filename’s first letters match A-1 and the parent folder is Tasks. Not brain surgery, right? But it is a pretty flexible solution to allow flexible access to any chunk of CSV (should work on any CSV on the web- assuming you adjust the elements to reflect the data) text you want to display portions of on the fly. People can do all their work in Google Drive and it seamlessly updates in WordPress. People without WordPress skills can update and change where these lists appear through […]
Publishing Google Docs to WPMU
I was looking to have some people in my class publish lesson plans to their WPMU blogs via Google Docs. So I consulting the dean of WPMU, The Right Reverend Jim Groom, and he made it look so easy. Yet, I failed. Feeling stupid I started drinking looked at the differences in our set up. I began to worry it was because I wasn’t using dynamic subdomains. I reached such a depth of despondency that I actually read one of the error messages from Google itself. It said “Hey Dummy, you haven’t turned on XML-RPC publishing for that blog. Why don’t you go turn it on?” I did and everything now works. There’s a video on how to do that below in case it helps. pub2wpmu
Comments on this post
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!
I blame it on ignorance. 🙂
Thanks for the tip and so very happy to see the post.
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.
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.
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” 🙂
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.
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
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.
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
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
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.
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.
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.
Awesome!