I am in charge of a little neighborhood project. I’ve collected almost 700 vinyl record albums from neighbors who no longer want them. I want to distribute them to the 15-20 other neighbors who do want them. Because of the pandemic and for scheduling purposes, I don’t want to just put the albums out on a table and invite the neighbors over to pick through them. So I have entered them into an Access database.
Since I am certain that there will be some albums chosen by more than 1 neighbor, I am developing an algorithm that will allow me to distribute them fairly.
What I need now is a way for the neighbors to let me know which albums they want. I thought about just sending out a printed list and letting them mark the ones they want, but this has a couple of problems. It is messy and error prone both for them and for me. And there are almost 700 albums.
I think a cloud-based application is the ideal solution. It would allow each neighbor to “log on” to the master list. They would see a list of the albums with title, artist, rpm (33, 45, 78), and condition (Mint, Very Good, Good, Fair, Poor).
Those fields would all be read only. There would be one data entry field where they could enter a priority number (1-10). It would be great if they could sort the list on different columns. When they are satisfied with their choices, they tell the app to send the list to me. I would then merge the lists from all of the neighbors and apply my algorithm.
Is this something Airtable can do? If so, point me to where I can read up on how. If there are consultants who are experienced with Airtable, I’d be happy to pay one to get me started.
PS: If this is not a good application for Airtable, I would appreciate any suggestions for alternatives.