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.

  1. first person submitting form - email confirmation data submitted.
  2. hr department - gets email same data submitted, subject line users name.
  3. 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

Popular posts from this blog

Fail to load namespace Spring Security http://www.springframework.org/security/tags -

sql - MySQL query optimization using coalesce -

unity3d - Unity local avoidance in user created world -