Protecting School Campuses with a Proactive Incident Reporting Solution

Solutions We Offered

Capital Numbers began the work by syncing WordPress with Azure to give schools secure Microsoft logins. With Single Sign-On (SSO) via Azure Active Directory, we ensured only authorized school admins could access the incident tracking system, ensuring data safety.

The real magic began when we tackled the challenges of integrating Gravity Forms with advanced conditional logic. We ensured the process flows as follows: When a school admin selects the type of incident - an injury or illness of a school bus driver, the form comes to life, dynamically revealing only the relevant fields. For example, upon choosing "injury," the form instantly prompts for key details - injury type, location, time, and immediate actions taken. First aid fields appear only if needed. This ensures context-specific data collection without drowning users in unwanted fields.

Gravity Flow takes over once the form gets submitted, automating every next step like a well-oiled machine. For a serious injury, the workflow immediately notifies the health officer, assigns follow-ups, and triggers tasks like submitting a WorkSafe BC form. For minor incidents, escalation occurs only when further action is flagged. Behind the scenes, this orchestration relies on a meticulous web of nested logic, where every rule is carefully layered to deliver an intuitive and intelligent system.

We combined PHP, MySQL, HTML, CSS, jQuery, and Ajax to build this powerhouse, crafting a rock-solid foundation to manage all types of incident data. RESTful APIs and Security Assertion Markup Language (SAML) ensured secure communication, keeping every piece of incident data encrypted.

We didn't stop there. To deliver a unified experience, we embedded the WordPress platform into Microsoft Teams and built a dedicated Microsoft App for access across desktops and browsers. The result? School admins could jump into the system anytime, anywhere, without switching between tools.

Taking it further, we developed a site duplication mechanism so each school admin could spin up its own WordPress site, retaining unique data while maintaining a standardized configuration, including themes, plugins, and settings. This game-changing site duplication mechanism offers schools consistency in setup with enough room for individual tweaks.