Davey Rogulich
Member
TLDR: What do folks use for checking in and out audio/lighting/miscellaneous gear to people in your organization?
I am the Technical Director of a children's dance theater in Albuquerque, New Mexico, called NDI New Mexico. We do a lot of work in elemeanrty schools around town, and our instructors take PA's and wireless microphones to the schools to teach class.
We have 5 PA kits, and 10 wireless mic and we have a real problem with inventory control. Gear goes missing often, and it turns into a game of "so-and-so had it last, I think..."
We started out with a paper log in the storage closet, but of course no one ever filled it out.
I currently use the spreadsheet to track who has what, when they checked it out, when it's due back, and when it was actually returned. The advantage of this, is I can see the history of where a piece of gear. Who's had it when and where it's been. The disadvantages, it's a clunky interface (I have about 20 sheets in this workbook) and the data entry is very slow. Also, I am the only one who has access to the document, so I have to fill everything out myself.
I have tried other programs in the past such as Delicious Library, and AirTable but neither of them have the "history feature" as far as I can tell.
Ideally, I would like some sort of app where I build a library of all the stuff we have. Then, when someone wanted to check out a piece of gear, I could scan a barcode on the piece of gear and choose who it was check out to and add a due date. In a super ideal world, it would be able to ID the person some how (by taking a picture, or scanning their phone, or something) and send them a reminder when their stuff was due.
Dose anyone know of such a program? Am sure that there is proper library software that does just that exact thing, but I'm hoping to not break the bank trying to get this setup.
What do you all use for this sort of thing?
I am the Technical Director of a children's dance theater in Albuquerque, New Mexico, called NDI New Mexico. We do a lot of work in elemeanrty schools around town, and our instructors take PA's and wireless microphones to the schools to teach class.
We have 5 PA kits, and 10 wireless mic and we have a real problem with inventory control. Gear goes missing often, and it turns into a game of "so-and-so had it last, I think..."
We started out with a paper log in the storage closet, but of course no one ever filled it out.
I currently use the spreadsheet to track who has what, when they checked it out, when it's due back, and when it was actually returned. The advantage of this, is I can see the history of where a piece of gear. Who's had it when and where it's been. The disadvantages, it's a clunky interface (I have about 20 sheets in this workbook) and the data entry is very slow. Also, I am the only one who has access to the document, so I have to fill everything out myself.
I have tried other programs in the past such as Delicious Library, and AirTable but neither of them have the "history feature" as far as I can tell.
Ideally, I would like some sort of app where I build a library of all the stuff we have. Then, when someone wanted to check out a piece of gear, I could scan a barcode on the piece of gear and choose who it was check out to and add a due date. In a super ideal world, it would be able to ID the person some how (by taking a picture, or scanning their phone, or something) and send them a reminder when their stuff was due.
Dose anyone know of such a program? Am sure that there is proper library software that does just that exact thing, but I'm hoping to not break the bank trying to get this setup.
What do you all use for this sort of thing?