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.
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.
Or – how I do things since I can’t program – but isn’t the first title much more fun?I freely admit that this may be seen as a stupid and useless thing to do (esp. by people who can write any sort of php.) I still see it as interesting if only for the fact that it shows different ways to make the information both portable, dynamic and embeddable. First off, thanks to Jim Groom for letting me bounce ideas off him, giving some technical assistance and for testing services rendered. Now to business. Here’s what I wanted- a web accessible form that would display the data as it rolled in right under the submission form. Just like comments for a post but we wanted multiple questionsTo help make sure people actually addressed each aspect of the questions. If you give three questions in a post and ask people to answer in the comments you tend to get 1.4 questions answered rather than the 3 you wanted. and we wanted to be able to divide the responses. So that, in and of itself, is pretty narrow and stupid but what this can do in the end is pretty cool and can have widespread power. Using Google forms and the selective publishing option you can embed all sorts of user inputted […]