Screen Shot 2016-07-19 at 8.22.56 AM

Custom Web Form to Google Sheets

Sometimes the options given in Google Forms just won’t quite work for what you want to do. Maybe you want a particular look, or an interaction, or whatever that Google Forms just won’t do. Luckily, it’s not too hard to make a custom form that can do whatever you want and still has the ability to write the submitted data to a Google Spreadsheet and the form HTML is still served by Google. The following steps should get you up and running and comments in the scripts should provide additional details. Make a new spreadsheet in Google Sheets. Go to Tools>Script Editor Select all that stuff and replace it with the content below. Replace the string of ****** with the ID of your spreadsheet. Then save it. If you get any permissions prompts approve them. Make a new HTML page (File>New>HTML File) and name it index.html Select all and replace it with this.1 Save it. To make sure things work, let’s publish it (Publish>Deploy as Web App). Now go to that URL and submit something and see if it goes to the spreadsheet. If so, great. Now you can start customizing the form to reflect your needs. This form should now write to a spreadsheet like this. Do keep in mind that each form field you want to write to […]


Weekly Web Harvest for 2016-07-10

Comparing Fully-Online vs Mixed-Course Enrollment Data -e-Literate The Online Photographer: The Angry Man “Many years ago when I was but a wee clod-kicker in high school, I had amazing conversation with a pretty blonde girl in english class about the ‘news.’ She stated proudly that she didn’t pay any attention to current events…bragged actually. I was flabbergasted. She reasoned that since she had no plans to do anything about what she read, why bother. I had no retort beyond stunned indignation. All these years later she now appears as a wise woman in my memory. If only I could resist having my emotions hijacked by stories like this one. Why be angry? I’m not going to do anything about it.” SoundCiteJS — Northwestern University Knight Lab The Windows Shutdown crapfest So that nets us an estimate — to pull a number out of the air — of 24 people involved in this feature. Also each team was separated by 6 layers of management from the leads, so let’s add them in too, giving us 24 + (6 * 3) + 1 (the shared manager) 43 total people with a voice in this feature. Twenty-four of them were connected sorta closely to the code, and of those twenty four there were exactly zero with final say in how the feature worked. […]

Screen Shot 2016-07-10 at 6.49.24 PM

5.3 Reasons Pokemon Go will Replace the LMS

I was inspired by this post and the way that Slack also replaced the LMS.1 1. Pokemon is fun to say Like Schoology or Moodle, Pokemon is a fun word to say. You can also say words like Venusaur, Charizard, Blastoise, and Pikachu. That’s pretty much a foreign language credit right there! It’s pretty awesome! 2. Mobile Blackboard Mobile is a thing and phones exist. And so hot right now. App. APP! APPPP!!!!!! Plus see that kid. He’s capturing a round thing that’s pretty much what you do to win Pokemon. That’s directly from Blackboard’s site. It’s pretty much like they were grooming us for this. 3. Circles Schoology, Canvas, Pokemon . . . COINCIDENCE?!?!?!?! Case CLOSED! 4. Reality That Pokemon is too far away . . . just like your dreams!!!! Pokemon will get kids in the real world! 5. Other Things Pretty much the stuff! If you can see it. The things! A kid got out of bed to do this once. That’s the bar for exercise now. Imagine if they also rode in a car someplace. That’s like jogging or giving an essay to TurnItIn. Instant goodness!! .3 YEAAAAAAAHHHHHH!!!!! New THING! 1 I’m being obnoxious but come on people. Seriously? How can we do this every single time? The logic is literally terrible.

Portfolio Work – Interweaving the Personal API

I know. The title is pure click-bait. That’s part of why this blog is so wildly popular.1 I’ve been building a new portfolio site2 and I think some of this is kind of interesting even if it sounds boring. There are a few different goals in play. One challenge is to create a site that stays up to date with minimal work on my end. It’s a parallel of the small-pieces-loosely-joined mentality. I want tiny-actions-over-time (from the aforementioned small pieces) rather than widely-spaced-herculean efforts. I’m also trying to make sure that it fits in well with my current workflow and that I’m capturing the work I do elsewhere in ways that make sense. Another focus is to keep any work highly portable. I’ve had to re-enter data a number of times as I’ve migrated and I don’t want to do that any more. That’s going to be made possible mainly through some new API options and by working on my API/JSON, JavaScript skills. I’ll probably have to do chunks of it over anyway but I like to pretend I wont. I’ve got a ways to go but I’ve made some decent progress. The basic template/visuals are handled by Bootstrap. I’ve also got some simple Angular views, Timeline JS, JSON from Google sheets, WordPress WP Rest API v2, and Pinboard’s API. […]


Weekly Web Harvest for 2016-07-03

The land grab for farm data | TechCrunch Specifically, ownership and control of agronomic and equipment data is understood to have dramatic escalating value. Which seed varieties were the most successful and where? Which plant populations performed best? Whose recommendations (e.g. nitrogen programs) outperformed their peers? Which input datasets are used for these recommendations, how were they acquired and are they standardized and accessible? How are the big companies actually using the data? Who has access, how long have they been acquiring it and how long do they keep it? Which documents did I sign to give them access? Data is one of the most valuable things farmers harvest. Make no mistake, the ambiguity around the value of this data is intentional. Nobody wants to initiate paying for something that has always been free. Returning Meaning To The Heart Of Communications – Brand Quarterly The P&I (Persuasion and Influence) industries, like so may others such as education, policing and (in the UK) the NHS (National Health Service), are increasingly falling under the sway of an “arithmocracy”. It is a reductionist system where managers are risk averse, increasingly reliant on ‘safety in numbers’ and prone to what Gerd Gigerenzer calls “defensive decision-making”. This system is based on a sort of physics envy: the belief (or hope) that human beings are more […]

Screen Shot 2016-07-08 at 9.49.21 AM

Drag/Drop/Sort to Google Doc Creation

This is an experiment focused on getting content chunks from a Google Spreadsheet into a drag/drop web interface for manipulation then back to a Google Form (could be skipped but I did left it so people could add/alter other form elements as desired) and then spitting out the final product as a Google Document. The image above essentially shows the flow. It’s all done based on the one spreadsheet which has three sheets- one for the content from the form, one for the drag/drop stuff, and one for some additional content to throw into the final document. It sounds more complicated than it is . . . although it could be simplified. There is interesting potential here to create some really unique experiences without a lot of programming knowledge. Drag/Drop/Sort I looked around a bit and ended up settling on a really slick js library called Sortable. The page consists of a couple of different elements. The HTML is straight forward. This gives me a text field, and three divs – bacon related, animals, and a drop zone. The spreadsheet stuff will be added to the first two and the human will be able to drag and drop them onto the drop zone (and then sort them as well). This chunk of javascript gets the json from the second sheet […]