Create a system to extract and format information from a database of records stored in a Google Docs spreadsheet (about 500 records). Probably will need to use Google API of some sort.
## Deliverables
Currently I manage an online database for a neighborhood organization using [login to view URL] (an online hosted database application). We have about 500 records in the database, so it is not large. The hosting company ([login to view URL]) is going out of business, so I want to migrate this to Google Docs as a spreadsheet, and then make it more user-friendly with some programming using the Google spreadsheet API. The data will be in a Google Docs spreadsheet, with one row per record and various columns (first name, last name, address, phone, etc.). I would like a web-based interface which will allow the creation of web pages or embedded frames with data extracted from the master spreadsheet but linked to the master (updated automatically) based on selection criteria -- such as all records in which a certain field is a certain value or contains a certain value. The new web pages that are extracted from the master spreadsheet will need to be tables with some customization -- column headings, cell formatting, etc. that is not exactly like the Google spreadsheet. For an example, here is the "board of directors" list on our current website, which is extracted from the [login to view URL] database: [login to view URL] -- that table is formatted specially but uses information extracted from the database. I will want several pages/tables set up like this (probably 10 or so). I have some limited coding/html experience so I may be able to take what a programmer does and modify it myself for future needs.