How to create a web form to talk with Google Docs

My friend and co-worker Jenny from Three Kid Circus pointed out a cool feature of Google Docs to me today. I use Google Docs spreadsheets mostly as wiki-like documents for a group of people to edit a web page in table form. In other words I use them for layout of a web page, and maybe for sorting columns, and sharing fairly simple information.

In another conversation I had recently, Elisa Camahort was talking about wanting a simple widget sort of thing for party RSVPs, but that would be more than a link to her email address – it would be a form for people invited to fill out. So, it occurred to me that the form-constructing capability in Google Docs would do all the things she wanted.

As I thought further, I realized it also might be helpful to my friend Squid Rosenberg, who has a son whose educational plan is managed by a fairly large group of people, using Google Docs, tracking his progress and patterns with a daily record. Similar documents could be very useful for anyone tracking health care issues, for a team of caregivers for an elderly person, for example.

Since this is a fairly new and obscure feature, and somewhat of a convoluted process to click around to where you even understand what the feature does, I thought I’d describe how to set it up.

1) Go to Google Docs.

2) Create a spreadsheet and call it “My potluck dinner” or whatever.

3) Make columns for whatever you like — name, email, # of people you’re bringing, what kind of food you will bring to the potluck.

4) Click “share”.

5) Click “invite people to fill out a form”.

6) Click “Start editing your form”.

7) Click the Save button.

8) Click “Choose recipients”. (You don’t have to put in any actual recipients.)

9) Click “Embed”, in the upper left corner.

10) Copy the code and stick it in your blog

Each column in the spreadsheet shows up as a title and text input field in the form! You can also add new fields.

It looks like this:

From there you might have to twiddle the formatting to make it look halfway decent. It is not set up to look nice in a blog sidebar, but it looks just fine in posts or pages in TypePad, and Blogger. It doesn’t work in LiveJournal or WordPress because it uses iframes, though in WordPress you can install a widget to get iframes to work.

The resulting input into the spreadsheet looks like this:


(click image to see it bigger)

Note the timestamp, automatically added!

So, this could be useful for many purposes. My potluck dinner example is frivolous, but anyone who’s suffered through the annoying interface of the spreadsheets on Google Docs, or who uses them for individual or group data entry, could set up extremely easy web forms with this hidden-away feature.

I would like to send a polite nudge to the Docs development team to uncover the forms feature! It would be very nice if it were an option to click directly from the spreadsheet or other document.

Secret texting at the school talent show!

Here’s the video of the 3rd grade dance act in the school talent show! An eighth grade girl choreographed it and coached all the 3rd graders through many practices. They dance to the James Bond theme, Soulja Boy, and then What Is the Sun? by They Might Be Giants.

I giggled a lot during it because it was SO AWESOME. Especially at the bits where the kids are all sneaking around like they’re James Bond spies with finger guns.

The whole show was impressive. A crew of middle school kids organized everything and ran the show, including practices, planning, stage crew, sound and lighting, getting the auditorium, and selling tickets. I enjoyed the piano solos, the many middle school girls doing solo dance routines, the group dances, the heartfelt songs sometimes sung a bit softly & deer-in-the-headlights. My mom friend who shall remain mercifully nameless kept texting me naughtily during the show and together we invented the camera-flask, perfect for all PTA type of school events so you could video your child’s song AND discreetly take a nip of soul-restoring tequila. It went sort of like this, (heavily fictionalized)

6:35 omg need drink
6:36 where iz flask
6:37 flask camera!
6:38 aaaaaagh
6:45 not my fault i do not allow hannah montana in teh house
6:46 bwahaha sucka
6:47 KILL ME
6:48 hahaha killing would be too slow
6:50 you have to admit they are sweet
6:50 no i dont
6:51 cynicism melting halp snif

Meanwhile the little kid next to me was all like “I know breakdancing. Why do you have a wheelchair? Can you do tricks? I think breakdancing is really cool. I know that girl! I know that girl too! I know her brother! Oh I can’t believe they’re going to do this, why, why why!” (said for anything mushy & sentimental) I think for him the show needed more explosions.

I remembered how I used to watch my friends make up dances and create mildly too-sexy outfits for our middle school talent shows. I could not fathom how to keep up with their dance moves and would not even try. They danced one year to “Jukebox Hero” and the next to “Controversy” which I couldn’t believe they got away with.

The other things I gleaned from the talent show experience were fashion-related. I really really really wanted the one guitar duet kid’s outfit with its vest, buttons, baggy pants, and ska-ish tie. Oh wait I have that outfit already, it’s just that I’m not 13 or 6 feet tall, and can’t play the guitar or stand in that sort of guitar player attitude. Oh well! (Their guitar solos were smoking!!!) The other fashion insight was that the 80s have come again in mutated form in a somewhat hideous way. Of course they were all cute as bugs and YET… the mutant halter-top-vest thing, over the long tank top, please god make it stop! But, finally now I understand all the teenage girls’ outfits as described in super bad Harry Potter fanfiction. So, I felt old and detached from things that girls wear in junior high, which is probably a good sign of almost-maturity, or that other thing where I am stuck in my decade, the way certain women in the 70s and 80s were stuck in 1945.

Oh also? Kids are awesome and I get all teary eyed and sentimental at the thought of how much nerve it takes them to get up on stage and sing a rock song or play the flute or dance around with everyone watching. I thought they all were amazingly cool. As a bonus, some of them had massive amounts of performing talent, the ability to connect to the audience and belt out a song — like this girl singing a country and western song with perfect self possession, or these girls dancing:

But the performances were good no matter what the level of ability was. I thought about karaoke bars and Rock Band and how we are more willing these days, maybe, than at some points in recent history, to stand up and perform for the fun of it and as a social activity rather than as perfect experts.

*UPDATE* And now I’m listening to the Langley School Project album. Trust me… go listen to it… at least to Space Oddity and Desperado.

Scaramouche, Scaramouche, will you do a fandango?

Moomin’s school choir sings Queen’s “Bohemian Rhapsody”. Ambitious of them!

If I didn’t totally love his choir director already, this would have done it. I’m taking suggestions for what they should put on their repertoire for next year. “Nevermind” would be just perfect.

The kids have worked incredibly hard this year. Every Monday and Friday, they got up and went to school an hour early for choir practice. I’m so impressed even with the difference since Christmas, in their timing and harmony.

Oh and… a sneak preview of next Monday’s talent show. I caught the 3rd grade at their dance practice, with an older kid as their choreographer and coach. They’re doing a dance to Soulja Boy.

Here’s the instructional video if you want to learn the dance. I can’t wait for this show!

Sonnet, twittered

Drum roll… a moment in Twitter history…

twittersonnet

Twittered by allaboutgeorge aka George Kelly, for Sarah Dopp.

The poem is better for having been twittered. I like it backwards, and getting the punchline first and then cycling back through it. The poetics of Twitter force circularity and rereading, disorder and reversal. Which goes perfectly with this poem’s theme!

Free Idea: Use ChaCha's structure for disaster relief

On the drive up to Seattle a few weeks ago, Cindy and Sarah Dopp and I were playing with ChaCha and wondering how they make money. Around here we all go “What’s your business model” right away… and then snicker.

So I think I might just have figured it out. Do it for free for a bit with your VC money and show how it works. Then, sell “Enterprise ChaCha” or something like it, to a big institution. (I was looking at Indiana University‘s page about it.) You’d sell the structure and the setup, and the institution creates its own number (and password or validation system) and pools its own experts. So, sell it to Exxon or something for its corporate librarians and geologists. Or to the military, obviously. Here is the military’s answer to its perpetual search for AI. “Human assisted search”.

Anyway, this could also work for disaster relief, because it’s ideal for situations that change very rapidly. I was looking at Jon’s empty wiki and thinking, well aside from all the problems with the whole idea of that, which I won’t go into, might a Twitter feed be better? I thought of myself on the 2nd floor of the Astrodome after Katrina, gathering and putting out information that was extremely up to date, and how quickly things changed on the ground. Would I want a wiki for it? (I tried. It is hopeless without a core of people already trained to use one and to work together with one.) Maybe I wouldn’t want one. Maybe a feed would be better. Page back through the “2nd floor astrodome” Twitter feed and see what’s up. Combine many different channels of all the people at various stations in the Astrodome and you’d know who says what is true, right in the moment.

But even better — a private setup for a ChaCha-like thing. You get 100 people together to monitor and answer questions and you would have an instant backup, fit for the general of an army. Or fit for a reporter on the ground in a rough situation. I think of how I combed google news all day long for the Back to Iraq guy back in like 2003 and emailed him updates on whatever was going on or being bombed in the area near him. How much better, if he could have called a phone number like ChaCha’s, and tapped into a network of people like me. Someone would have texted him back the information he wanted within minutes. And if there were sort of a combination of Ning and ChaCha, you’d be able to set up your own information broker network and invite people to join it.

The Red Cross should be using this (okay, maybe in 20 years if they can get it together that fast). But, I offer the idea up to whatever nonprofits or disaster relief workers can use it.

WordPress plugin idea – blikify

So I was at Recent Changes Camp this weekend talking smack about blikis with some people. And I told anyone who would listen about the plugins for WordPress that help you integrate your blog with Mediawiki or other wikis.

What about a plugin that would just let you designate any page or post as world-editable?

Add Markdown and your WordPress blog could be easily wikified. I could use this for my nascent Hack Ability blog, and it would make me (and readers, and other editors) a lot happier than setting up and maintaining a whole parallel wiki structure to go with the blog.

On #wordpress I was just talking with _ck_ who wrote a Wiki Post plugin for bbPress.

_ck_ also pointed me to this cool and hilarious video of andiacts and Selena discussing when to use Drupal and when to use WordPress:


“It’s so cool! It’s like a new solar system!” That made me laugh so hard.

I have never written a WP Plugin but this seems possibly within the scope of my coding ability. So maybe this summer I’ll give it a shot.

But, if anyone out there wants to write it, go ahead, take the idea and run. Just hat tip me when you do. And, I would be motivated to help and contribute, because it would be handy as hell.

Ubuntu "Girlfriend Experiment" PHAIL

Ugh… I really get pissed at the basic idea of “we can see how usable Ubuntu is by testing it on our girlfriends.” Assumption: “We” are male; “our” girlfriends are ignorant of technical matters. And are stupid. Femininity here is equated with non-technical status. This is not only untrue, it is a really poisonous idea to spread.

http://contentconsumer.com/2008/04/27/is-ubuntu-useable-enough-for-my-girlfriend/

First task: Tell me what the capital of Bosnia is. Second task: watch a video on YouTube Third task: Download a Spice Girls album.

Uhhh WTF with the Spice Girls? Care to infantalize women’s use on the internet any more?

How about finding some RECIPES too?

All of this just yanks my chain big time, like when people say in talks and demos, “It’s so easy, my MOM can do it.” (And then everyone in the audience laughs knowingly.) Like moms are the dumbest people ever. My pet peeve at technical conferences. I am a mom!

I am also a girlfriend!

I am also technically competent and don’t enjoy condescension!

Test Linux on your ignorant dad, next time, or your poker buddy. Be sure to have him download crap about the Backstreet Boys and other overly gendered BS.

Hundreds of women on the linuxchix mailing list are rolling their eyes in unison.

WAIT I’m so confused, maybe if they made the Ubuntu background pink?!?

DIY: Access Hacks project

For the second year in a row, I thought of the wheelchair modification and disability access projects that could and should be at Maker Faire. I’d like to make that happen next year.

At Maker Faire this year, I talked with Miguel Valenzuela, who was showing Lift Assist, a toilet lift device that can be built for $150 out of bits of PVC and junk from a hardware store, powered hydraulically from your own water system. That kind of thing costs thousands of dollars if you buy it as a medical device. If it were a DIY kit, and if it had open source plans and instructions up on the web, it could be useful to thousands of people all over the world.

So I got to thinking. Who would I even hook Miguel up with, to get his plans used? What other projects are spreading disability access devices, open source? Could things like this just be given over to an organization like Engineers Without Borders? How can they be open sourced or copylefted? Who’s collecting that information? Certainly not the U.N. committees on disability – ha!

There are specific projects like Whirlwind Wheelchair International and its design for the Rough Rider chair, developed by Ralf Hotchkiss and students over many years and meant to be distributed to shops or factories or organizations in developing nations. In other words, partnership with actual manufacturers. There’s the Free Wheelchair Mission which has a kit to build wheelchairs for under $50. They seem to take donations and then ship a giant crate of wheelchair kits to somewhere in the world. Those both look great. But neither of them were for a disabled person who might want to build their own stuff.

Then I found some nifty sites like Marty’s Gearability blog, which has a DIY category for “Life with limitations and the gear that makes things work”. She has made dozens of posts on modifications she’s made for her dad, who uses a wheelchair. I especially enjoyed the how-to for a wheelchair cup holder and the elegant, blindingly useful offset hinges to widen doorways.

I’m also somewhat familiar with Adafruit Industries and its projects like SpokePOV. What if assistive devices used something closer to this model? Rather than people patenting, and trying to sell their designs to a medical supply company, which marks it up a million times until disabled people in the U.S. can’t afford them unless they have insurance or can wait 5 years and fight a legal battle with Medicare.

I found organizations like Remap in the UK, that takes applications from individual disabled people, and hooks them up with an engineer who will build them a custom device. This I think exemplifies the well meaning but ill advised attempts to help disabled people through a “charity” model rather than through widespread empowerment. If an engineer is donating time and an invention, why not have them write up and donate the plans for whatever they are building, and post the DIY instructions for free? Then, thousands of people all over the world could build that invention for themselves.

Here’s another data-sucking black hole of information that should be out there on the beautiful, wild, free internet: academia. This paper on bamboo wheelchair designs is probably super great, but who knows? Only the libraries who have the bound copy of the conference proceedings of the 5th international bamboo conference back in 2002. This makes me very, very sad. OneSwitch, on the other hand, has the right idea. It’s a compendium of DIY electronics projects to build assistive devices. Perfect!

Meanwhile, I went looking for the latest news in open source hardware. What’s up with the Open Source Hardware License?

My own inventions for assistive devices have tended towards the creative yet slapdash use of duct tape. For example, my Duct Tape Crutch Pockets, an idea easily adaptable to small pouches for forearm crutches and canes, or to get more storage space onto your wheelchair.

My own canes and crutches that fold (with internal bungee cords) could use simple velcro closure straps to keep them folded up while they’re in my backpack or in the car. There are some ingenious ways, also, to attach canes or crutches to a wheelchair.

I have thought of, but not made, ways to extend storage space further. For example, I think that the lack of pockets in women’s clothing is a political issue. Women’s clothes are mostly designed without pockets, because of cultural pressure to look skinny, so women end up encumbered by bags and purses. If you think about how wheelchairs are made, it is interesting that they are assumed not to need storage space, cup holders, things like that. People hang little backpacks off their chairs. And there are a few custom made pouches for walkers, crutches, and wheelchairs, like this thin armrest pouch. You won’t find them in an actual wheelchair store – and rarely in a drugstore or medical supply house. Why not?

As wheelchair designs continue to evolve, I hope that manufacturers will create customizable backs and sides and seats. Nylon webbing with d-rings, sewn into the backs and under the seats of wheelchairs, would mean that custom pouches and packs could clip onto a chair. Then it would be easy to set up your chair with interchangeable bits. My laptop could go in a pouch under the seat, for example, so that it wouldn’t affect my center of gravity so drastically as it hangs off the seat back in a backpack.

I’d like to see more and more mods for chairs and canes and crutches that are just for fun. The little holes in adjustable-height, hollow metal walking canes — don’t they seem like the perfect size to stick an LED light in there?

Also, meanwhile, I had posted briefly the other day for Blogging Against Disablism Day 2008 with a list of ideas for Practical actions that will help, like smoothing out steps into a small business (ie just freaking pour some asphalt in there or build a wooden wedge even if it is not exactly to code; people do nothing, for fear of being sued, rather than spend thousands to do a to-code ramp, and I’d rather they just stuff in a slope and bolt a rail to the wall than do nothing!). After I made the list, I went looking for online instructions on how to do the things I was suggesting. What did I come up with ? Jack shit! Nothing! Nada!

So, here’s what I propose we do:

– Compile free and open source how-tos, plans, designs, etc. on Disapedia. I have made a page for DIY equipment.

– I will go and interview Hotchkiss and his class, and write up more detail on how their open source project works.

– A meeting to share access hacks and start to add to that wiki page on Disape
dia.

– I’ll head up an effort to organize a really good disability/accessibility hacking booth for Maker Faire next year.

For the Access Hacks booth, I’d like to pull in:
– craft/sewing people for stuff like mobility device storage and mods with velcro and fabric
– metal working people
– electronics people (like the OneSwitch folks)
– Maybe invite Tech Shop and the Bay Area wheelchair stores to participate
– obviously, disabled crafty/makery people. I thought I could try to pull in GimpGirl and put the word out in other communities
– Flyers on how to open source your hack and make it free – license info, where to post, hook up with places like WikiHow.

This could make a super fantastic real life application for hardware/craft hacks. I would love to just hang out all weekend with a bunch of other people with disabilities and share whatever hacks we’ve already come up with. That in itself would be productive without even doing it at Maker Faire. I’d like an Access Hacks meeting around here and I wonder if people would host them elsewhere and then post tips on Disapedia. (I would like to use them rather than host a new wiki, but I’m willing to make an access hacks wiki if that’s what people would like.)

Please, leave feedback in the comments.

Reading in Seattle this Friday, Apr 25


Liz Reading at Queer Open Mic
Originally uploaded by Liz.

I am road tripping up to Seattle this week! If you are there please come see me at this event ! I would love to see you all and would love the support. April 25, 8pm, Annex Theatre, 1100 East Pike Street.

You will hear me say the word “Lezzie” in a Texas accent. Also, I promise to wear leather pants. There will be bubbling, and silliness, and insane talk of poems and roadside geology and the roots of the Klamath Mountains. I will pop a wheelie for you and you may pat me on the head and tell me I am brave (JUST KIDDING about the patting).

I will not have my child with me, but you can bring yours, as long as you keep them out of the bar area and don’t mind them hearing some intense stories of playground bullies and maybe some cussing, plus you realize my story is about being queer, queer, queer. All the stories are AMAZING and are written about elementary school and early middle school experiences & with that audience in mind!

Get info & buy tickets here: Can I Sit W/You reading

Tickets are priced at $5 and $12, which means you can choose how much to donate. Money all goes to my hometown Special Ed PTA.