Inventory catalog
Find what your production needs
Search, filter, and add items to your basket. Availability stays visible while you browse.
Design & Production · Stock Inventory
Use categories, tags, or search to find the equipment you need
Click "Add to Basket" on items and adjust quantities as needed
Open the request form in this system, review your basket details, and submit your request
📎 Hi! I'm Legally Distinct Clippy!
Unified request system: single Requests sheet for all categories.
Replaced equipment-only form with unified request form (equipment, film, other items).
Added Category column to Requests sheet for per-line categorization.
Added Emails sheet for configurable email addresses (Manager, shop heads, etc.).
Request numbering starts from REQ-0001 (scans all sources for next ID).
Free-text "other items" section for uncataloged hand props/costumes.
Renamed all RS_equip* functions to RS_* (v5.0 namespace).
Fixed equipment auto-numbering skipping IDs (race condition + multi-row support).
Added LockService protection to ID generation to prevent concurrent conflicts.
Added SpreadsheetApp.flush() for read/write consistency in ID generation.
onEdit auto-ID now handles multi-row pastes/fills correctly.
Added split basket for Film/Equipment with separate copy buttons.
Added Equipment Request form with per-line-item approve/deny.
Added MaintenanceNotes and Cost fields to inventory.
Added _getItemRequestCounts_ for popularity tracking.
Added _num_ helper function for parsing cost values.
1. Browse or search for the items you need
2. Click "Add to Basket" on each item
3. Adjust quantities using the +/- buttons
4. Click "Review & continue" to open the request form
5. Fill in your details and submit
● Green = Plenty available
● Yellow = Low stock (≤20% remaining)
● Red = None available
Items with red badges are currently checked out and may not be available for your requested dates.
Bundles are pre-made equipment packages for common events. Instead of adding items one by one, you can add a whole bundle with one click. Great for concerts, plays, and dance shows!
Yes! Click "Save Basket" in the basket section. Your items will be saved to your browser and restored next time you visit. Click "Load Saved" to restore a previously saved basket.
Use the "Request Lookup" search at the top of the page. Enter your request number (e.g., "57" or "REQ-0057") to see the status and items in your request.
Reply to your request confirmation email for request-specific help, or visit the Design & Production shop during the pickup hours shown in the request form.
Design & Production
Browse equipment, check availability, and prepare your request.
(Internal Mode)Inventory catalog
Search, filter, and add items to your basket. Availability stays visible while you browse.