Case Study

A Mobile Warehouse System for 500+ Chain Hoists

Inventory, project assignments, and safety certification for equipment that lifts tons above people's heads — in a field crew's pocket, online or off.

500+chain hoists tracked
5permission roles
100%works offline
0per-seat license fees

The problem with tracking safety-critical gear

A chain hoist lifts thousands of kilograms of lighting, sound, and staging above a live crowd. There are hundreds of them in a busy rigging operation, each with a service history, a load rating, and a certification date that must not lapse. Where each unit is, which project it's on, and whether it's cleared for use is not paperwork — it's a safety obligation.

Stage Design ran this on a no-code app that got the operation off spreadsheets, but hit a wall as it grew: it couldn't scale to the full fleet, struggled with real multi-user field use, and — critically for crews working in venues and loading docks — it needed a live connection to do anything.

What we built

A purpose-built mobile system that runs in a field crew's hand. It tracks every chain hoist through its whole lifecycle — in stock, assigned to a project, out for maintenance, certified or overdue — and it keeps working when the signal doesn't.

Mobile app (React Native) API service (Express on Cloud Run) PostgreSQL (Supabase)
Field-first: the phone is the primary device, the cloud is where the record settles.
The DG Logistic dashboard on a phone, in Hebrew right-to-left: stat cards showing 504 total hoists, 27 active projects, 386 valid and 118 invalid, a 77% validity donut chart, and a six-month certification-expiry timeline
The field dashboard — fleet totals, certification validity, and what's expiring, at a glance.

Why we left the no-code app behind

Constraint on the old appIn the native build
Scaling to the full fleetreal database, built for hundreds of units
Working without signalfully offline-capable
Multi-user field editingconcurrent, role-based
Per-seat platform feesinfrastructure you own

No-code platforms are a superb way to start — they prove the workflow and get a team off spreadsheets fast. But when the tool becomes load-bearing for a safety-critical operation, its ceilings (scale, offline use, licensing) stop being annoyances and start being risks. The native rebuild keeps everything the team already learned to rely on, and removes the ceiling.

What we learned

Where this applies

If you manage a fleet of physical assets in the field — especially where safety, certification, or inspection matters — this architecture fits:

Your data on infrastructure you own, in an app that works whether or not the venue has WiFi.

Outgrown your spreadsheet or no-code app?

Let's talk about a field system that scales with the operation.

Talk to Us

ai4solutions builds AI systems that don't burn money. Based in Israel. This system was built for Stage Design Israel, where our founder leads the kinetics & automation department, to manage its rigging fleet.