Helpdesk App Starter · Industry version
One support desk for staff, students, and families — routed by campus, aware of devices, owned by the district.
A school helpdesk serves three populations at once — teachers mid-lesson, students on loaner laptops, parents locked out of portals — across buildings with different setups. This starter models campuses and device loans in the schema, so triage starts sorted instead of starting over.
01 · The problem
Who is asking matters more in a school than anywhere else. A teacher with a dead projector during third period, a parent who can't see grades, and a student with a cracked loaner screen need different queues, different tones, and different SLAs — but a generic desk sees three identical tickets from three email addresses.
Location is structural, not incidental. Districts run multiple buildings with different networks, different device carts, and often one traveling technician. Without the campus in the schema, dispatch is a guessing game and 'the west lab is down again' never becomes a pattern you can budget against.
And school time is lumpy. August brings a thousand device handouts in two weeks; June brings them all back. A desk that can't treat rollout season as a first-class workflow buries the year's most predictable crunch in a generic queue, then reports it as a mysterious SLA collapse.
02 · Data model
Everything in the base Helpdesk starter —
ticketsticket_messagesagentsteamssla_policiestags— plus the entities this industry actually runs on:
| table | what it holds |
|---|---|
campuses | Buildings and sites with their networks, rooms, and assigned technicians — the routing key for physical issues. |
device_loans | Loaner laptops and tablets checked out to students and staff, with condition notes, due dates, and repair history. |
03 · Screens
Requesters carry a role — staff, student, or guardian — and tickets route accordingly: classroom-tech issues to the campus technician, portal lockouts to the office, loaner damage to the device desk. Three audiences, one system, no shared-inbox archaeology.
Response targets run on bell schedules, not calendar hours — a classroom outage during instruction is a now problem, while a summer request can breathe. Term calendars and holidays live in your code, where the district actually controls them.
The help center splits by audience: portal guides and enrollment FAQs for families, classroom-tech playbooks for staff. Articles in plain language deflect the password-reset flood, and per-article stats show which August guide to rewrite by July.
04 · In practice
A rollout batch creates loan records as each student signs out a laptop — serial, condition, due date. Damage tickets through the year link to the loan, and June's collection report lists exactly who still holds what, by homeroom.
A teacher's urgent ticket carries the room and campus automatically, pages the building's technician, and starts the instructional-hours SLA. The pattern report later shows that room's smartboard has failed four times — a replacement case, not a repair ticket.
Report-card week triples parent lockouts. Tickets auto-suggest the reset guide on submission, the office queue handles the rest with a two-click macro, and the desk survives the wave without pulling technicians off classroom work.
Yes — campuses are a core entity, so each building has its own routing, technician assignments, and reporting while the district sees one system. Adding a new school is a row, not a new instance.
Loans are records linking a device, a student, and dates, with condition notes at checkout and return. Damage tickets attach to the loan, so a device's repair history follows the hardware across years and hands.
Families can submit by email alone — the desk threads replies like any mail conversation — or sign in to track requests. Staff get fuller views by role. None of this is seat-licensed; the whole district is covered by the code.
In your database, on infrastructure the district controls — which is most of the FERPA conversation settled at the architecture level. The generated app sends nothing to Dual7 at runtime.
Dual7 App Starters
One support desk for staff, students, and families — routed by campus, aware of devices, owned by the district. Describe your version to start — the output is a project you own.