customization - Google forms stopped working -
i student worker , learning how work google forms. trying build form our department involved in. have custom google form working bit stopped. located @ http://www.uaf.edu/marketing/intake/. have trigger set onformsubmit > fromspreadsheet > onformsubmit . using code in script editor , set onformsubmit:
function onformsubmit(e) { var name = e.values[1]; var title = e.values[2]; var department = e.values[3]; var email = e.values[4]; var phone = e.values[5]; var newproject = e.values[6]; var project = e.values[7]; var description = e.values[8]; var descriptcomment = e.values[9]; var audience = e.values[10]; var audiencecomment = e.values[11]; var accomplish = e.values[12]; var result = e.values[13]; var tarday = e.values[14]; var compday = e.values[15]; var infoday = e.values[16]; var chat = e.values[17]; var refer = e.values[18]; // change address address want notification go var = "email#1,email#2"; var subject = "mc intake form notification"; var message = "your name: " + name + "\n \n"; message += "your title: " + title + "\n \n"; message += "department: " + department + "\n \n"; message += "email: " + email + "\n \n"; message += "phone number: " + phone + "\n \n"; message += "is new project: " + newproject + "\n \n"; message += "project title: " + project + "\n \n"; message += "project description: " + description + "\n \n"; message += "project description comments: " + descriptcomment + "\n \n"; message += "who's audience? " + audience + "\n \n"; message += "audience comments " + audiencecomment + "\n \n"; message += "what trying accomplish? " + accomplish + "\n \n"; message += "what desired result, , success like? " + result + "\n \n"; message += "what targeted start date? " + tarday + "\n \n"; message += "what targeted completion date? " + compday + "\n \n"; message += "information distrbution target dates, date event happening, when can provide content,etc. " + infoday + "\n \n"; message += "are working in our department? " + chat + "\n \n"; message += "how referred form? " + refer + "\n \n"; var mailoptions = { name: name, replyto: email, }; mailapp.sendemail(to, subject, message, mailoptions); }
try remove ` @ first line?
also, open developer tools -> console , see if there error messages.
Comments
Post a Comment