<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Filter By Categories
Gwen Chen
March 20, 2018

Using AppSheet to Manage Materials Engineering and Testing

Appsheet_Slump Testing.jpeg

There is little room for error in the materials engineering and testing space, where a mistake like misinterpreting your data or losing track of your equipment can delay a project and ruin a client relationship. Your back-end systems have to be on point at all times.

Reducing risk through apps

Many companies in this space — like Canadian Construction Materials Engineering & Testing Inc. (CCMET), formally Metro Testing Group — are building apps to modernize their processes and reduce risk. As CCMET Tech Innovations Lead and App Maker Joseph Romualdez explained, traditional paper and spreadsheet-based data entry systems are fragile and risky, and not optimal for daily record keeping and management.

“I recognized the potential for error that existed with this system early on,” Romualdez said. “So I searched online, found AppSheet and knew immediately that this was what we needed.”

How CCMET Uses AppSheet

Despite only having a working knowledge of Java, Romualdez was able to create multiple apps using AppSheet’s no code app maker platform.

CCMET is using AppSheet for:

Tracking shotcrete panels: Shotcrete panels, which the company uses to test concrete at client locations, are typically very expensive. They can easily be mistaken as trash, though, and thrown out. CCMET created an app that allows technicians to track shotcrete panels using pictures and notes, which saves money while enabling them to document and track their assets.

Filing safety forms and recording equipment calibration data: AppSheet helped CCMET obtain Certificate of Recognition certification by increasing the amount of Field Level Risk Assessment (FLRA) submissions filed every day—a 10-fold increase!

Having an electronic-based form removes a lot of work and time in filing and processing the forms. Before using AppSheet, CCMET was using paper-based field level risk assessment (FLRA) forms and vehicle and equipment inspection forms. After completing a FLRA form, the technician had to go back to the office to submit to another person for filing and processing. Now, when technicians in the field file an FLRA through a safety app, the safety officer can review the data in seconds. 

Besides FLRA, CCMET also uses the safety app for Construction Personal Protective Equipment safety, equipment and vehicle inspections.

One other widely used app at CCMET is the Equipment Calibration App. CCMET has lots of equipment, which has to be calibrated every one to three months. Different equipment is managed by different technicians. Before using AppSheet, technicians had to enter the calibration data into a form and submit the form to the manager. This app helps streamline data entry and approval, and ensure greater accuracy when entering equipment calibration data, which is a step that is considered mission critical for safety and compliance.

Technician reports: In the past, technicians needed to return to the office to complete field assessment reports. Now, these reports can be completed on-site in an app — even without WiFi.

AppSheet, it should be noted, is also helping bridge the technology gap that exists between the company’s younger and older workers.

“AppSheet provides a platform that is easy to create with and easy to use,” Romualdez pointed out. “Many technicians here are weary of using new technologies. But having an app that is nice on the eyes and easy to operate really helps us.”

To learn more how your company can benefit from AppSheet, click here.


Discover Sample Apps from Excel Spreadsheets

Google Search

Subscribe Email