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
Google Form to Video Display
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 […]
Rampages Stats vs My Own Data
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 […]
Online Google Earth Tours
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.
Trackbacks and Pingbacks on this post
No trackbacks.
- TrackBack URL
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.