Digitalizing Medical Equipment Maintenance: A CMMS Approach Using Google Forms and App Script (#2025)

Authors

Cáceres Lagos, Fernanda De Lourdes

López Girón, Brayan Neptali

Abstract

This research addresses the challenges of technology management in hospitals and clinics, which stem from the limited use of information technology. This limitation leads to adverse consequences, such as delays in maintenance scheduling and inefficient resource utilization. To tackle this issue, a Computerized Maintenance Management System (CMMS) was proposed using Google Forms, specifically adapted to the context of a private clinic in Tegucigalpa, Honduras. A qualitative approach was employed, involving interviews and detailed observations to understand the maintenance department's workflow. Key sections of this process were then digitally replicated using Google Forms and automated with App Script. The resulting system consists of two forms: one for reporting medical equipment failures and another for documenting maintenance work orders. Functionality tests demonstrated that the implementation successfully eliminated paper-based work order management and automated maintenance notifications.