In my day job, I work on two, large-scale education initiatives at the Oregon Community Foundation. The Studio to School initiative focuses on arts education and the K12 Student Success Out-of-School Time initiative funds after-school and summer programs. For each initiative we collect data at the organization level (e.g. how their programs are structured) as well as the individual level (e.g. interviews with specific staff members). Right now, the data that we collect lives in a series of Excel spreadsheets and Word documents scattered in various places throughout our internal network drive. I constantly bang my head on the desk trying to find specific pieces of data in our unorganized, unconnected mess of a data management “system.” Because my office runs on Windows, using the notoriously terrible search feature is futile. And because we use an internal network drive (i.e. not Dropbox, Google Drive, or the like) I am constantly informed that I can’t open a file because someone else has it open.

Sound familiar?

From talking with other researchers, I know that my organization is not the only to struggle with data management. The series of unconnected, poorly organized, and non-searchable spreadsheets strategy is, in fact, quite common among researchers working in teams.

So what’s the solution?

Ask some technologically-inclined people and they will tell you the answer is simple: a relational database. Microsoft Access is the most well-known of these databases in the research world (from what I’ve gathered, but please correct me if you think otherwise), but it is, let’s say, less than 100% user friendly. Databases can be useful, but often have a fairly steep learning curve. The promise of having all of your data in one place, connected, searchable, and able to be worked on by multiple people simultaneously remains a challenge unless you want to invest some serious time and energy into learning how to create and manage a database.

Fortunately, companies are recognizing the challenge of disconnected data and coming up with simple and elegant solutions.

One option that we are currently testing in my job is called Fieldbook. The product’s slogan is “create a database, as easily as a spreadsheet,” and it does exactly what it says on the tin. With the look and feel of a spreadsheet, it is incredibly easy to navigate. Here, for example, is a peek at one of the sheets we use to keep general information on our grantees. Looks just like a spreadsheet, right?

fieldbook-overview

But this is far more powerful than a simple spreadsheet. The power of Fieldbook comes in the ability to link sheets, as the company’s video demonstrates.

 

So, in the case of our initiative, I can click on any of the grantees in “Project Eval Plans” column on the sheet above and that takes me to another sheet where I can enter information about their project evaluation plans (obviously, this sheet is blank, but you get the idea!). No longer am I looking through folders trying to find their project evaluation plan document; now I simply click on that cell and immediately I am taken where I need to go.

fieldbook-project-eval

Fieldbook has many other useful features. Like Google Apps, it allows you to collaborate with others, enabling you to edit simultaneously. And it allows you to create and save filtered and sorted views of our data, allowing us to, for example, easily see which grantees mentioned the words “musical instrument” in their project evaluation plans. The example video from Fieldbook highlights this feature.

 

While we are only testing out Fieldbook at the moment, its power is already abundantly clear. Were we to switch to using it more robustly, the problems of our current system — not being able to find data in our disconnected mess of files, not being able to search for data, and not being able to work simultaneously with others — would be reduced significantly.

If your organization is using a system like ours and you have nightmares of yourself searching through layers of folders, looking for the most recent version of spreadsheets, check out Fieldbook. It is a new product, one benefit of which is that it is currently free (though there is a paid version with additional features).

Have you used Fieldbook or anything similar to manage your data? What’s working (or not working) for you? Leave a comment to let us know!

  1. Nik A Hafiz

    ,

    i also find airtable easy to learn / use / build dbases but i surely think tht wth more practice / repeated use, fieldbook may b as easy too.

    though i haven’t studied the details regarding the storage limitation to the new attachment feature, in terms of record size for each dbase (base or book), here’s the comparison between airtable & fieldbook:

    fieldbook
    total rows in a book (all sheets): 10,000
    column in a sheet: 500
    cooks on an account : no maximum

    airtable:
    free acct: 1,200/base | 2gb attachmt space/base
    plus acct: 5,000/base | 5gb attachmt space/base
    pro acct: 50,000/base | 20gb attachmt space/base
    [enterprise acct: to b released later]

      1. Nik A Hafiz

        ,

        while still checking with fieldbook if they allow their books to b embedded in websites, note that it’s already possible to embed view/base (read-only) from airtable into websites with 2 options as per the 2 instructional vdo’s below:

        sharing a table view link
        https://vimeo.com/134359957

        embedding a view
        https://vimeo.com/134359208.

        + you have really good collaborative feature in airtable.

        the flwg vdo is qte interesting as it tries to make a distinction between a normal spreadsheet (e.g. ms excel or g.sheets) & a spreadsheet that’s actually a relational dbase (i.e. airtable) :

        https://youtu.be/zttu1JNgRck

        i guess, we can’t discount out airtable as it yet.

        kind regards: -nik-


  2. I tend to like Fieldbook’s aesthetics a bit more, as Airtable feels more mass-market/consumer-y vs power user tool, and Fieldbook has a nice search bar interface. That being said, I’m using Airtable for now because it has an iPhone app (though not Android yet I think), file attachments, forms support, more field types (rollups/lookups/checkboxes are particularly important for me), @mentions, & a Zapier integration. We also use Slack and Airtable plus in there

    1. David Keyes

      Yeah, I definitely feel like Airtable is much further along. I do also really like the spare look of Fieldbook. I’ve corresponded with the developer of Fieldbook and I know they’re going to add attachments and other field types in the future. I’ll be curious to see how the two compare in a few months!


  3. Have you tried Airtable? Seems pretty similar.

    1. David Keyes

      Yeah, I’ve played around with Airtable a bit and definitely find it similar. We are testing out Fieldbook at my job in large part because it’s completely free for our purposes. Have you used Airtable? If so, I’d be curious to hear your thoughts on it and/or how it compares to Fieldbook.

Leave a Reply