First Aid Inventory App

CASE STUDY

Cartonplast Group are a global leader in the field of processing and servicing of reusable layer pads, used in the transportation of glass containers and cans for the food and beverage industry. Here’s how we helped them digitise their strict auditing process with a First Aid Inventory App.

Setting the scene

Carton Plast’s (CP) First Aid boxes are positioned at various locations around their site, to ensure compliance is maintained, it is necessary to inspect each of them regularly to make sure items inside are in date and within the correct box (e.g. eyewash bottles). A monthly First Aid check is undertaken by the Production Manager onsite, who emptied each box, recorded the date on each item and restocked the items when necessary. Each month, this information was recorded on paper and repeated eight times across the site, taking several hours for the Production Manager to complete.

At the end of each inspection, the completed paperwork was filed away in a drawer, giving CP no visibility of the data. Should CP fail a Health & Safety audit or, in a worst-case scenario, one of their staff have an accident, they could have found that the right equipment was not available and faced serious repercussions.

How we did it

Our team worked with one of the Production Managers to understiand the process of completing a check. From those discussions, we were able to:

Workflows

Gain a better understanding of their current process and how they operate

Wireframes

Create a skeleton of the future solution so all stakeholders can see the key elements

Backlog Creation

Make a product backlog (a list of tasks and features) based on User Stories (end goals)

Once we felt confident that we had all the information, we began working in weekly sprints. By keeping CP informed at every step of the development process, we created a continuous feedback loop, enabling us to adapt to change quickly at every stage, with the features and results of the product being refined.

Solution – First Aid Inventory App

Using Power Apps, our team created a mobile-friendly checklist of items included in every First Aid box on CP’s premises, organised by location. All checkpoints needed completing and the applicable dates entered before a submission can be allowed. Expiration dates are stored until the item needs to be replaced. CP can add items to boxes within Sharepoint, and they can change their locations in the future.

We stored the data to enable CP to see when the last inspection was performed, who completed it, and whether it was complient. Finally, Production Manager is notified, via Power Automated flows, when a check was due and when an item was about to be out of date. As a result, all First Aid boxes were refilled before the next inspection and warehouses were kept in compliance with health and safety regulations.

Using Power Apps, our team created a mobile-friendly checklist of items included in every First Aid box on a client’s premise, organised by location. All checkpoints needed completing and the applicable dates entered before a submission can be allowed. Expiration dates are stored until the item needs to be replaced. Clients can add items to boxes within Sharepoint, and they can change their locations in the future.

We stored the data so our client could see when the last inspection was performed, who completed it, and what was collected. Finally, Production Managers were notified, via automated flows, when a check was due and when an item was about to be out of date. As a result, all First Aid boxes were refilled before the next inspection and warehouses were kept in compliance with health and safety regulations.

Technologies we used

Power Apps

Power Automate

SharePoint

Outcomes

An app that empowers Production Managers to carry out inspections in an easy and accessible manner

Reduction in the time it takes to complete a First Aid inspection, from hours to minutes

An easy-to-use SharePoint repository for all inspection data

Automating human processes, limiting human error

Reduction of paper used, lowering carbon footprints and stationery costs

Cookie	Type	Duration	Description
_ga	0	2 years	This cookie is installed by Google Analytics. The cookie is used to calculate visitor, session, camapign data and keep track of site usage for the site's analytics report. The cookies store information anonymously and assigns a randoly generated number to identify unique visitors.
_gid	0	1 day	This cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.