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.
I was just messing around a bit more with mashing up the YouTube API post from earlier with the Twitter post from earlier today. This Google Script will get the view count of a particular video (Gangnam Style) and send out the total views and the time elapsed watching the video (assuming I did the math right). It has no real purpose (other than the scale of the number amuses me) but it’s one of those things with concepts that I’ll be able to apply more usefully in the future. That’s a gut feeling but I’m pretty confident. Don’t forget to add the Twitter library as directed here.in the Apps Script project, include the library MKvHYYdYA4G5JJHj7hxIcoh8V4oX7X1M_ with the identifier set to Twitter
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 […]
It has been interesting to see the excitement surrounding WolframAlpha . The new “Computational Knowledge Engine” called Wolfram|Alpha has gone through a full media cycle before it has even been unleashed on the world. It has been hyped as a “Google Killer” and denounced as snake oil, and we’re still at least a few days from release. The simple goal behind the engine is to connect searchers with precise information. Wolfram|Alpha’s search magic comes through a combination of natural language processing and a giant pool of curated data. That quote is from Radio Berkman (which is a very interesting podcast out of Harvard Law) and they’ve got an interview with the creator as well. Watch the abbreviated 10 minute version below. I’m not sure how well the idea of a curated semantic web will work (although I can understand that urge). This does really show a different way to think about searching for information. It really takes it beyond search, making it closer to exploration maybe. It’s similar in some ways to one of David Huynh’s Parallax project (of Simile Exhibit fame) which has been out for quite a while now. Video of that is below. Freebase Parallax: A new way to browse and explore data from David Huynh on Vimeo. While the media may be portraying Google as being […]