Image Source: pixabay

Feedback is crucial for growth and improvement. With the advent of technology, creating feedback mechanisms has become more efficient and customizable. In this tutorial, we’ll explore how to create a feedback form using Google Apps Script, which not only gathers feedback but also sends notifications to specific instructors based on user selections.

Google Apps Script is a powerful tool that allows users to extend the functionality of Google Workspace applications such as Google Sheets, Google Forms, and Gmail. By leveraging its capabilities, we can automate tasks and create tailored solutions like our feedback form.

Step 1:

Setting up the Feedback Form First, create a Google Form to collect feedback from users. Include fields for the user’s name, email, feedback message, and a dropdown menu to select the instructor. This dropdown menu will dynamically populate with a list of instructors.

Step 2:

Creating the Google Apps Script Open the associated Google Sheets spreadsheet where responses from the form are collected. From the “Extensions” menu, select “Apps Script” to open the Google Apps Script editor.

In the script editor, write the code to extract form responses, parse the selected instructor, and send notifications accordingly. Here’s a simplified version of the code:

function onFormSubmit(e) {

var response = e.response;
var itemResponses = response.getItemResponses();

var instructor = itemResponses[3].getResponse(); // Assuming dropdown menu is the 4th item

// Define email addresses of instructors
var instructorEmails = {
“Instructor A”: “instructorA@example.com”,
“Instructor B”: “instructorB@example.com”,

// Add more instructors as needed
};

var recipientEmail = instructorEmails[instructor];
var feedbackMessage = “”; // Construct the feedback message

// Send email notification
MailApp.sendEmail({
to: recipientEmail,
subject: “New Feedback Received”,
body: feedbackMessage
});
}

Step 3:

Deploying the Script Once you’ve written the script, save it and deploy it as a trigger to run on form submission. Go to the “Triggers” menu in the script editor, add a new trigger, and select the function “onFormSubmit” to run on form submission events.

Step 4:

Testing the Form Test the feedback form by submitting responses with different instructor selections. Ensure that the notifications are sent to the respective instructors based on the dropdown menu selection.

Use Case Applications:

Educational Institutes: Educational institutions can use this feedback form to gather feedback from students about their instructors. Notifications can be sent directly to the respective instructors for timely review and action.Professional Training Programs: Organizations offering professional training programs can implement this feedback mechanism to collect feedback from participants. Notifications can be routed to trainers or instructors for continuous improvement.Online Courses Platforms: Platforms offering online courses can integrate this feedback form to collect feedback from learners. Notifications can be sent to course instructors or facilitators for personalized follow-ups and improvements.Workshops and Seminars: Event organizers can utilize this feedback form to gather feedback from attendees about workshop presenters or seminar speakers. Notifications can be sent to speakers for insights and future enhancements.

Conclusion

Creating a feedback form with Google Apps Script offers a customizable and efficient way to gather feedback and send notifications based on user selections. By following the steps outlined in this tutorial, educational institutions, training programs, online course platforms, and event organizers can streamline their feedback processes and foster continuous improvement.

I hope you find this article helpful. For latest post intimation you may follow, subscribe and share this with your friends. Happy learning! 💻🥳🎉

Boost your Google Workspace potential with our e-book: Google Apps Script: A Beginner’s Guide. Streamline your workflow and automate tasks today. Get your copy now!

Open to freelance opportunities and welcome to collaborations. Please feel free to contact me via email at dilipkashyap.sd@gmail.com. Thank you :)

How to Create a Feedback Form: Sending Email Notifications Based on Selected Instructor was originally published in Level Up Coding on Medium, where people are continuing the conversation by highlighting and responding to this story.

​ Level Up Coding – Medium

about Infinite Loop Digital

We support businesses by identifying requirements and helping clients integrate AI seamlessly into their operations.

Gartner
Gartner Digital Workplace Summit Generative Al

GenAI sessions:

  • 4 Use Cases for Generative AI and ChatGPT in the Digital Workplace
  • How the Power of Generative AI Will Transform Knowledge Management
  • The Perils and Promises of Microsoft 365 Copilot
  • How to Be the Generative AI Champion Your CIO and Organization Need
  • How to Shift Organizational Culture Today to Embrace Generative AI Tomorrow
  • Mitigate the Risks of Generative AI by Enhancing Your Information Governance
  • Cultivate Essential Skills for Collaborating With Artificial Intelligence
  • Ask the Expert: Microsoft 365 Copilot
  • Generative AI Across Digital Workplace Markets
10 – 11 June 2024

London, U.K.