Wednesday, January 11, 2017

Figs, mushrooms, maybe meatballs. Go Code Colorado 2017!


It’s time for Go Code Colorado, one of our favorite parts of the year. It’s a Colorado competition that invites developers and entrepreneurs to use public data to build apps that create business intelligence. It’s so, so, so much more than a hackathon. It’s an opportunity to meet new people, learn something new, and help build a stronger Colorado.

Each year, the Go Code team announces the challenge statement at their killer kick-off party. This year, it’s at Galvanize Golden Triangle on Wednesday, Feb. 1, at 6 p.m. -- and we’re promised figs, mushrooms...and maybe meatballs. Oh yeah, and Great Divide beers! How could you miss it? Register for the kick-off event right now and start building your team.

Go Code Colorado hinges on the open data posted on the Colorado Information Marketplace at At the end of the competition the three winning teams receive $25,000 to keep their app and business idea going. Learn more here and let the games begin!

Thursday, January 5, 2017

MacGyver Moment #1: Data sharing for the rest of us

We’ve got a new series for the #StateofCO IT blog to highlight state employees innovating in government—MacGyver Moments!

Our first MacGyver Moment comes from one of the state’s developers Greg Ostravich. Check out his video interview with Digital Transformation Officer Brandon Williams, and read what he says below.

If you've been around technology for a while then you probably remember Microsoft Access Database—a solution that was popular in the 90s enabling customers to easily share data.

At the State of Colorado we have the “big three” of solutions: SalesForce, Perceptive, and Google. These tools are great for large scale projects, but what do we do if we want a solution for a smaller dataset? Or if we want something that doesn't require the licensing of SalesForce or Perceptive? What if we want something that doesn't require in-house developers to come up with a Java solution that runs in the Google App Engine using a cloud-based database?

Well, there is a niche solution that does work for these types of scenarios. Enter Google Sheets.

There are two ways to do this:

  1. The newer option is using Google App Maker, a tool that is still bubbling up. It is a low code way of extending features within Google Apps.
  2. The other option, that I used, is to bind an HTML form and Google App Script to a Google Sheet to create a way for users to search content without having a heavy developer-dependent solution. The solution lives in the cloud, doesn't require any costs for deployment, and allows "read-only" sharing of content for a customizable set of users.
Without going into too much detail, here’s what I did: |

Took a Google Sheet and under the "Tools" menu clicked on the "Script Editor".

From the Script Editor, I inserted a Google App Script ( and an HTML file.

These two files, which are bound to the Google Sheet, work in conjunction with each other to allow the user to access a traditional HTML form where they type in their search criteria and submit the form. That action runs Google Apps Scripts that walk through the sheet searching for matching data, and then dynamically generates and populates the results in a div that lives on the HTML file that's bound to the sheet. Because it's just HTML, the Google Sheet can even contain HTML (bulleted lists in one example I worked on) and they will render correctly.

I’ve put together this example to show you how it works here.

Thank you Greg for an awesome example of building a technology solution on a shoestring budget, and without an over complicated architecture. What do you guys think?