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 form", username +"will be" +optsituation+". \n\nyour form submission " + "the hr department has been notified , recorded, if have question please contact hr department. \n\nemplpoyer|hr department", {name:"hr department"}); }
Comments
Post a Comment