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
Pre-Filling Forms via URL
I have to figure out a rather unpleasant and boring thing. I am, however, learning some fairly odd and interesting tricks as a result. This is one that might be useful to someone. Google Forms You can pre-fill Google form entries with a URL. That might be useful if you had 720 students in groups of 6 reviewing one another but didn’t want to build a form with 720 student names or build a 120 forms with 6 student names. I don’t think I’m going to end up using this for this purposeI have some other ideas around hidden fields, clues, and custom URLs based on user interactions . . . but maybe it’ll prove useful to someone else and it’s dead simple. Step one – Build your form. Step two – Go to Responses in the Form Editor view and select “Get pre-filled URL”. You then fill out the form the way you want and it creates the URL. In this case, I’m filling out a multiple choice question and a free form text entry. https://docs.google.com/forms/d/1P5_6vTv53MEKCEjd87xecI483goNqDg1-nPlFH84Mz0/viewform?entry.1615031756=Bob+Smith&entry.1012634392=I,+for+one,+have+always+admired+the+number+two. Now, you might wonder what would happen if in the URL you set a multiple choice answer to something not available as an option- like ‘Freddy Kruger’ for the first field in the form. I wondered that. It just comes up blank in […]
Citation Workflow – Diigo/Pinterest to Google SS
Talking to Bud the other day he mentioned that generating the citation page for his digital stories was something of a pain. I’ve thought about it a bit since then and decided to try to simplify a workflow for this. Odd thing I learned – – CHAR(10) is the official way to get line breaks in Google Spreadsheet formulas. Flickr to Diigo to Google Spreadsheets Initially, I looked at the Flickr galleries because that’s the option that Bud normally uses. I saw that the gallery was in a standard HTML list format and I had some hope. Google spreadsheets lets you pull lists and tables like these in via the IMPORTHTML function. Martin Hawksey has some good instructions and examples over here. So that failed but I could import just about every other list on the page. So, I decided doing this through Diigo would make pretty decent sense for a number of people. Assuming you choose a unique tag for the images you plan to use- this example just uses “flickr”, I’d suggest something story/movie specific. So the basic Diigo URL you’d get is https://www.diigo.com/user/bionicteaching/flickr. Trying to make this really easy for people, I set up the first page to allow you to paste that URL in and our friendly formulas transform it into https://www.diigo.com/rss/user/bionicteaching/flickr. The example linked here […]
Google Folder to Google Doc Script- The Video
Because I really thought the script to take Google Folder contents and automatically generate a document with headings that match the folder names and automatically linked source documentsIt certainly rolls of the tongue . . . was far cooler than anyone realized . . . I decided to make a poor quality video chastising you and proving the interestingness beyond doubt. Keep in mind that this could be customized to do far more interesting things depending on desired outcome and how you wanted to manage stuff. This is one of those places where I think the technology really has a chance to do something useful. No one wants to spend hours updating a CV/resume every year or two. Instead you could spend minutes spaced out and get all the grunt work down automatically. Google Docs also gives the option to publish the results to the web or download it as Word or PDF. The document and files can be as open or closed as you want.
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.