The work behind the scenes of a pet food bank is immense. I was describing the work that we do to a volunteer today and my words were, “It’s pretty simple. The client needs pet food. We have pet food.” But it’s so much more than that. We need to find the pet food, store it, keep a decent inventory, transport it to pet food bank locations, find volunteers to distribute, keep track of how much food we give out, take the remaining food back to the warehouse and fundraise for all the above.
I always wish there was more time in the day. One thing we really need, and it would save hours upon hours every week, would be a database. Three to four more hours a week for myself and volunteers would mean more time for all of the other things on the list that need to be tackled.
Because in the end, if it was as easy as “they need pet food, we have pet food” we could help so many more pets and families. And that’s good for everyone.
I would be very happy to explain in-depth what we need in a database to any developer who would be willing to listen and potentially work on this project with us. The gist is we track and report on how much pet food we distribute at each pet food bank and how much each client receives (for as long as they come to the pet food bank).
It started out as a nice little Excel spreadsheet.
Now, for our largest pet food bank (which is just one out of five locations) we have 481 clients, which when printed so that we can check people into the pet food bank, is 24 pages.
Our ideal scenario (at least the way I am imagining this) would be to scrap the paper and use electronic tablets to record this information and input it directly into a database. We would need to be able to enter new clients, and then to be able to search and add to current clients each time they visit the pet food bank. And we’d need to be able to report totals on the various fields.
If you have ideas, please contact us. We would be grateful for any help or advice.
Eileen, Colorado Pet Pantry Executive Director