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.
Image from page 981 of “A system of instruction in X-ray methods and medical uses of light, hot-air, vibration and high-frequency currents : a pictorial system of teaching by clinical instruction plates with explanatory text : a series of photographic cli flickr photo by Internet Archive Book Images shared with no copyright restriction (Flickr Commons) This is a bit odd but if you work in education it’s quite possible it’ll come up . . . Sometimes people just want the blog comments in a nice friendly CSV file. That might be for grading, it might be for further analysis in Voyant or something like that. What I need to do is write a little plugin for the export like Alan did for posts but until I get around to that I took advantage of another plugin Alan wrote to expand comments to the 100 most recent comments. So since I have lots of comments available in the feed, I can just use the =IMPORTXML function to port right into Google Sheets. There’s probably a smart way to parse out multiple XML fields at a time but this seems to work ok. All the functions I used are broken down in the sheet embedded below. Most are simply some version of IMPORTXML(b1,”//title”). B1 is the URL for the feed and the […]
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