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).
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.
flickr photo shared by OSU Special Collections & Archives : Commons with no copyright restriction (Flickr Commons) As part of a future project, I’m looking for easy, automated ways to push/pull CSV files around. Initially I thought I’d just do the =importdata(‘http://theurl.com/data.csv”) function but I realized that had some drawbacks that made it less ideal which lead to the script below. Using Google Script triggers this script could be set to retrieve a CSV file every X amount of time and write it to a Google Sheet. The upper portion is adapted from this answer. In any case, it opens up some decent automatic options and would keep data fresh for easy access charts and graphs in Google.
The challenge as initially laid out was to let students log the miles they walk and have those miles show their progress from Richmond VA to Key West FL on a map. I found quite a few ways not to do this- mostly because I was attacking the problem in the wrong way. I wanted to set a point of origin, a destination direction and then map a straight line for X amount of miles. It may be possible but it feels like you’re fighting the system the whole way. I took some time off and let it marinate in my head and a much easier solution appeared. Goal In the end I realized I wanted to get the path from Richmond to Key West and then be able to add a marker to that path at any mileage point along the way. The miles would be pulled from Google Form submissions. One of the key helpers was epoly.js . It adds a number of tricks which come in handy- including the option to GetPointAtDistance along a path. I used this example for find the midpoint of a route as the starting template. I figured I’d leave the midpoint as a goal and then all I needed to do was add another marker that was placed based on the sum […]
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 […]