IT Helpdesk template
Tickets, assets, and people — a public request form, an SLA-breach formula driven by priority targets, assignment notifications, and an asset register with validated IP and MAC fields.
Tables
Tickets
Subject, Description, Category, Priority, Status, Requester, Assignee, Ticket #, Channel, Department, Requester e-mail, Site, Approval, Approver and 20 more
Assets
Asset, Type, Assigned to, IP address, MAC address, Asset tag, Serial number, Hostname, Operating system, Site, Department, State, Purchased, Purchase price and 10 more
People
Name, Department, Email, Phone, Job title, Site, Manager, Employee number, Started, IT confidence, Priority support, Works remotely, Extension, Timezone and 7 more
Views
- Ticket board (kanban)
- All tickets (grid)
- Due dates (calendar)
- Asset register (grid)
Forms
- Submit an IT request
Automations
- Notify assignee on assignment
- Email helpdesk on new request
- Notify on customer-visible update
- “Tickets” reached “Resolved”
- “Assets” reached “Retired”
- Daily sweep — still open in “Tickets”
- “Billable” was ticked in “Tickets”
- Large value in “Time spent (h)”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.