Protecting School Campuses with a Proactive Incident Reporting Solution

The client was stuck using outdated Google Forms to track health and safety incidents at schools - a solution that quickly fell short. These rigid forms couldn't handle the depth and complexity of monitoring injuries, first aid, or illness reports for diverse school staff, from bus drivers and teachers to nurses, food service providers, librarians, and beyond.

The client's vision was clear: a custom WordPress platform powered by Gravity Forms and Gravity Flow that can collect detailed health and safety data while adapting dynamically to different scenarios. Whether reporting incidents or responding to specific campus needs, the platform had to ensure seamless data collection.

But this project was far more than plugging in a few forms and calling it a day. It required advanced conditional logic to make the forms dynamic, adapting fields in real-time based on user input for scenario-specific data collection.

That wasn't all. Each school needed a Microsoft login for the WordPress site to ensure secure access. This required diving deep into Azure Active Directory (AAD) to integrate Microsoft's Identity Platform seamlessly into WordPress.

The challenges didn't stop there. Setting up user roles, managing permissions, and enabling smooth Single Sign-On (SSO) while meeting strict security standards called for a deep understanding of Microsoft's authentication frameworks.

Recognizing the technical challenges, the client turned to Capital Numbers. With mastery in WordPress, PHP, Gravity Forms, Gravity Flow, and Azure authentication, we had to deliver a dynamic incident tracking system that multiple school campuses could use.

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.

Crafted by Capital Numbers’ meticulous team, the final product is a powerhouse incident tracking portal, championing safety across 50+ school campuses. The project wasn't just about integrating Microsoft Logins or creating forms but redefining how schools approach safety with smarter incident reporting mechanisms.

Here are the kinds of incidents schools can report on: