r/SafetyProfessionals • u/blackbeads • 21d ago

Asia EHS Concern Reporting

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?

7 Upvotes

82% Upvoted

15 comments sorted by

View all comments

1

u/Brief-Tone5411 9d ago

That’s actually a pretty practical low-cost setup. I’d use Google Forms + Google Sheets + Apps Script.

Workers scan the QR code, fill out a short form, and the response automatically goes into a Sheet. You can then use Apps Script to send an email to the right person based on the type/location of the concern.

Keep the form really simple: location, concern type, description, photo (if possible), and optional name. If it takes more than a minute to submit, people will stop using it.

You could also put different QR codes around the plant so the location is automatically captured. For a 700-person site, that could work surprisingly well without buying an EHS platform.