Making a Mad Libs-esque tool

So, the idea is to make an interactive tool that uses the basic syntax of something like, say, outcome measures to build your own customized version(s). Not so much to create a perfect set of measures for your program/organization, but to get the idea of how it works so you can write some better, more useful ones on your own.

This is something that might complement an article about the topic to give better context.

Embedding an editable Google Sheet with data validation drop-downs seems like a simple option.

Alright, so this works pretty well. A few URL appendices to the iframe clean it up some (i.e., &rm=minimal, &chrome=false, etc. — just Google it), but it’s not the prettiest given the row, column, and sheet labels. And it’s a bit too interactive; I don’t want users to write in the empty cells or change the parameters of the data validation. The drop-downs don’t work in read-only mode.

Will continue to think about this one. Unless I forget about it. In that case, this is the final product.

Four days later…

After looking around for examples and peaking at background code, which I only kind of know how to sort of interpret, I found an example. And after dissecting that code, I realized all that’s needed is a simple HTML tag…no CSS, no javascript, no embedding, nothing. Just a SELECT tag with some OPTIONS, just like how you’d make a list.

Percent of who XYZ.

Dollars .


Checklists! It would be cool to not only make some mock result measures, but to also see if they meet some basic criteria.

Turns out, the solution was to have a basic working knowledge of HTML and CSS…

Leave a Reply

Your email address will not be published. Required fields are marked *