Google Script - onFormSubmit - Automate an email confirmatio -
any appreciated. situation: created google form employer (attendance form) , automated email 3 different people on data submitted on form. first person submitting form - email confirmation data submitted. hr department - gets email same data submitted, subject line users name. the employees manager - gets notification stating person late or absent. this have far... please help... here link form attendance form function onformsubmitreply(e) { var useremail = e.values[3]; mailapp.sendemail(useremail, "attendance form", "thanks submitting attendance form. \n\nyour form submission " + "will reviewed our managment. \n\nemployer,|hr department", {name:"hr department"}); } function onformsubmitreply(e) { var username = e.values[1]; var optsituation = e.values[2]; var emailrecipients = "example@gmail.com"; mailapp.sendemail(emailrecipients, username +"submitted attendance...