Custom equipment inventory and check-out system using Airtable, Retool, and QR code stickers for tracking studio equipment across multiple locations.
Manual equipment tracking led to lost or misplaced gear, along with scheduling conflicts, at a studio with remote and on-site production teams.
Built comprehensive inventory system with QR code scanning and real-time availability tracking.
Reduced missing equipment, and eliminated the need for manual equipment tracking.
Using SerpAPI, I scraped equipment metadata from the web, created an Airtable database for tracking equipment, and, using Retool, developed a mobile-friendly interface with a QR code scanner for intuitive check-in/check-out workflows. Airtable kept a log of equipment location history, and Retool provided a real-time view of equipment availability.
Significantly reduced time looking for equipment, and created a system of accountability.