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.
A while back I posted about using GoogleLookup to get data quickly and easily to make and put into Google Earth via Google Spreadsheets. The example file is at http://spreadsheets.google.com/pub?key=pGAYO0Q5WpT8_Rsss6Uw2LQ&output=txt&gid=2&range=a1. It’s a network link. In Google Earth- click Add– Network Link and paste the URL into the Link box. Here’s some information on how to do this if you’re interested. Put Info into Google Earth from a Google Spreadsheet Things ended up being far easier than I anticipated. The last time I did a networked KML link from a spreadsheet (sounds way fancier than it is) I had to make it myself and go through a different service. Now Google has a nice template all set up to make things work well and it makes things pretty as well. Adding GoogleLookup to the Template So the next thing I did was play around a little with the lookup function. I didn’t do too much. I was just playing around to make sure it would work. This wouldn’t save you much time as it’s only five cities but it you wanted to plot all this information for 50 cities things would start to get a lot more interesting. I just added a few columns at the end of the spreadsheet and then set up the following formulas. I put the lookup […]
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 […]
Kin Lane mentioned that IFTTT, a service entirely built on APIs, doesn’t have an API. That bothered Kin and the more I thought about it it bothered me. So I figured I’d start disentangling myself from IFTTT. One of the things I did with IFTTT was to send out a Tweet any time I posted something new on my blog. Crazy to think I set that up in 2012. Granted, I could have replaced this with any number of plugins but I thought this would be fun and bit of API work but most interestingly it’d put me (mostly) in charge of how the tool worked. The following script is just cobbled together from something I found to get an RSS feed into a spreadsheet and a script I used a while back to send a tweet from a Google SS. Next steps will be to start playing with adding amusing variables to the message. The first message kicked through with a minor error but progress! Grabbing Flickr Photos was blogged & can be found athttp://bionicteaching.com/grabbing-flickr-photos/ — Tom Woodward (@twoodwar) March 20, 2016