These are the Google Forms add-ons that we have used and recommend. The most important actions that we incorporate are:
Immediate notification (including the content) of submitted safety activities
Conditional logic that supports if/then notification based on specific data input
Generation and sharing of EditForm URLs to support activity follow-up and oversight
Email Notifications for Google Forms --
Offers a free entry-level option that doesn’t provide access to all the functionality that you would probably want. The paid version includes the conditional logic that supports the kind of feedback our platform features.
Form Email Notifications
Free, but no conditional logic. Check it out if your company is small and you’re interested in safety activity documentation and a straight-line system of feedback and reinforcement.
Free -- and an excellent tool to pull data from Google Sheets into your Google Forms. We use this with our Heat Illness Prevention forms.
A free and very useful add-on to extend the data-gathering capability of your forms.
These two Google Sheets add-ons can do almost everything, including:
>Immediate email or text message notification (including the content) of submitted safety activities
>Conditional logic that supports if/then notification and feedback based on specific data input
>Generation and sharing of EditForm URLs to support activity follow-up and oversight
>And so much more
We use one or both of them in the development of all of our safety management systems. The primary advantage over Google Forms add-ons is that you are able to manage activities on the backend -- using our formulas and script to develop powerful in-the-moment process management tools.
Magic Cell Notifications
This free add-on was developed by a teacher for teachers. We requested two modifications that make this add-on a powerful tool for safety management, and you just can’t beat the price. A great user handbook walks you through getting started and more.
Automation is the key, and Sheet Automation is the most powerful add-on we have found for business process management. There is a modest fee, but if you want to build the best possible framework this is your Huckleberry. We offer recipes we have developed that power the Mashup Safety framework. And again, great online documentation to get you going.
Formulas and Script
When you work with us we share a number of Google Sheets formulas that are actually the secret sauce required to get the most out of the add-ons and support efforts to build a best-practice digital safety management system. We currently only use one snippet of script, but it is a critical piece of the puzzle if you are interested in developing a safety management dashboard that contains essential leading indicator data.
Free for up to five applets, we use IFTTT applets to automate triggers that drive safety processes and to initiate heat illness prevention activities. And there is so much more you can do -- create your own applets or use our published applets.
Two huge advantages of NestForms -- (1) installable app with offline capability if needed, and (2) more options than Google Forms when specific form behavior and functionality is needed. Connects to Google Sheets with a couple of clicks.