I'm helping an organization that connects with wealthy schools to share surplus items (from scissors to books to furniture) with under-funded schools.
I'm looking to set something up so the wealthy schools can create a membership account online, create a list of items they have available, and then those items can be assigned to various under-funded schools, which have also created their own account along with a list of what they need.
These lists are currently being done through spreadsheets, but I'd like a way to integrate the list functionality with the member management functionality. At the very least my hope is that doing that will give more power to the schools to facilitate the donations on their own, and I hope it will make it easier for past donations to be displayed online. Ideally, I'd like the software to automatically assign the items to the schools in need, but that's probably asking too much.
Anyway, my main question is: will Civi be helpful with the management of these donation item lists, or are good old Google spreadsheets the way to go?