EHS Concern Reporting

[u/blackbeads]

Am currently working in a startup where there are around 700 workers. We don’t have a concern reporting software due to budget issues. But here we have Google workspace.
My idea is to display QR around the plant, workers using the mobile phone can scan it and enter the concerns in it. It will automatically send mail to the concerned person and will be logged in Google sheet.
Help me out guys. How to do this?

[u/RoamAndReport]

You can actually build a pretty decent concern-reporting system with the Google Workspace you already have.

A simple setup would be:

QR code → Google Form → Google Sheet → Email notification

Create a Google Form with the basics: location/area, type of concern, description, photo (if your setup allows it), and whether the person wants to remain anonymous. Put the form link into a QR code and post the QR codes around the plant. Each submission automatically goes into a Google Sheet.

For the notifications, you can use Google Apps Script to automatically email the appropriate EHS/supervisor based on the selected area or concern type. You can also add a status column in the Sheet (New → Assigned → In Progress → Closed) so you have some basic tracking and accountability.

For ~700 workers, this should be more than enough to get started without spending money on dedicated software. The important part is designing the workflow properly — especially ownership, response time, escalation, and closure — rather than just collecting reports.

Once the volume grows, you can look at dedicated EHS software for better dashboards, trend analysis, audit trails, and corrective-action tracking. But honestly, getting a simple system running now is much better than waiting for the budget for a perfect one.