Many nonprofits want to manage information for volunteers or members submitting regular reports by paper or email. Volunteers or members have wildly varying locations, computer skills, software, and platforms, and so most of the forms used for this purpose, if electronic, produce inconsistent results -- they look different when opened onscreen, or use a program the member or volunteer doesn't have on his or her computer, etc. And if they're done by PDF and printed out to be submitted in writing, the information has to be redigitized before it can be used -- and nonprofits don't have enough staff to handle re-typing that kind of data (and scanning/OCR has its own similar challenges).
A system that allowed for simple data management online -- like a database of upt to, say, 20 customizable fields -- that accepts input through online forms would help address this problem. The resulting database content itself could be viewable as a web page, and/or reside offline in a common program format like Excel. The important thing would have to be that the online forms the volunteers or members can pull up and fill out using their browser, would have to either post the content directly to the database online, or autogenerate some type of report (like csv) that could then be opened and pasted into Excel.
Content quality from the reports could be controlled by a) allowing the nonprofit to customize the form ahead of time to request the information it needs to be getting; and further by format restrictions that only permit date formats where a date is requested, using pulldown menus or checkboxes for sets of data, and also allowing occasional text fields.
The model for this is a database like etapestry (www.etapestry.com), but without being focused exclusively on contact management, finance, and fundraising like that database is. In other words, if a nonprofit accepts reports from its volunteers who go on working trips for the nonprofit, and wants to design a database that contains information only from those reports about the field conditions, the dates and locations of trips, recommendations, activities, etc., then the nonprofit would benefit greatly from a database like I'm suggesting.
Comments
Social Problem Solving System
What would an online system look like for providing/developing/comparing solutions to social problems, and social participation in providing solutions? Could this be a tool? an ecosystem of applications? a social network that connects face to face connections to the net and world? I have notes and ideas and open ears.