Using Google Forms to Collect Information from Newspapers

I have been doing a lot of newspaper research recently.  I like to track what I find in a spreadsheet, it allows me to quickly sort my information and color-code cells for analyzing the data.  The problem is I hate to fill out spreadsheets.  I just don’t like the layout when typing in all the stuff I need to put in the spreadsheet.
I use a lot of spreadsheets at work but I rarely create a spreadsheet from scratch.  Usually my spreadsheets are created from some other application that “exports” to the spreadsheet format.  I guess since that is what I am used to, that is what I like.
Also at work I recently discovered Google Forms.  I had to survey some of my co-workers and Google Forms was suggested as a way to create a quick, free survey.  Once I create the survey in Google Forms I can send it to my co-workers and once they fill out and submit the form their responses are collected within a spreadsheet.
As I was learning more about Google Forms I thought, “this may be a tool I can use for genealogy”.

I started doing a little googling.  I was sure I wasn’t the first person to come up with using Forms for genealogy.  I stumbled upon a webinar that Thomas MacEntee did way back in 2011 for the Legacy Family Tree webinar series (Google Forms for Genealogists).  I haven’t heard him really mention Google Forms recently, so maybe he isn’t using them as much as he was then.  Some of the “quirks” he mentioned back then have been addressed in updates to the Forms app, some haven’t.  But I think for my use it will be fine.

So my first step is to figure out what fields I want in my form:
1. Name of paper
2. Date of item
3. Page
4. Column
5. Type of article (Birth, Marriage, Death, Court, Land, News)
6. Transcription of article
7. Link to Image of paper

Based on the type of news item I will then have different fields I want to collect.
For example, if it is a birth notice I want to collect:
– Name of baby
– Name of father
– Name of mother
– Date of birth
– Place of birth

If it is a marriage item I want to collect:
– Name of groom
– Name of bride
– Date of marriage
– Place of marriage
– Name of officiant
Once I figure out what fields I need on the form I will create the form.  Since I will be the only one using it (for now) the form doesn’t need to be fancy.  But it can be customized and themes assigned to the form if you want.

Then when the form is designed I can start using it to collect my newspaper information.

I’ll be experimenting a bit with my form and next time I will have more detailed instructions on the process of creating the form and using it.
If this goes well I am thinking of using a form as a replacement for my vital records spreadsheet as well.
Stay tuned…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: