First of all, any help with this is hugely appreciated; I’ve been rolling this problem around in my head for quite a while now and I think I’ve hit the point where I’ve just thought about it too much and the same solution keeps cropping up.
I’m trying to translate a horrible way of cataloging the location/status of items in properties into a web-based experience rather than using PDF’s in this awful way:
Name, Location 1, Location 2, Location 3, Date Found, Status
At the moment people fill out these PDF’s that are then input into an SQL table. Obviously, this is ridiculous and restrictive.
There has to be a better way of doing it though, some way that would allow me to add new “locations” without dropdowns of submenus or having a big list of location options sitting above the actual items.
Again, any and all advice is hugely appreciated.