Sending Confirmation Emails with a Google Docs Form

246 Comments

1. 

   Jeff - December 16, 2012

   Yep, I understand the logic I just don’t know the code that I’d use to get it to do that. Anyone able to help me with the syntax?
2. 

   Mindi - December 18, 2012

   Does anyone else get a “TypeError: Cannot read property “values” from undefined.” It’s shows this error for all the lines like this:

   var timestamp = e.values[0]

   The script works, but I only get the first line of my emailBody in the email.
3. 

   Alamoxie Web Design - December 22, 2012

   The syntax is quite simple, Jeff. Can you see the script in this form? https://docs.google.com/spreadsheet/ccc?key=0AiRHFmVcsy64dFNBTkhMdEpkNVpPVF93Qy16SlZFYUE

   Basically:

   if (pageSelector == "Option One") {
var emailBody = "something";
} else {
var emailBody = "something else";
}

   But see the script I linked to for a fuller example, and to see how the form is set up as well.
4. 

   Alamoxie Web Design - December 22, 2012

   Mindi, I don’t know for sure what the issue could be, but it sounds like “e” is undefined. Make sure the top of your script says:

   function onFormSubmit(e) {

   Then make sure your trigger is set properly as described in the post.

   If that doesn’t work, I can look at your exact code–it’s probably a simple issue, a character or line missing.
5. 

   Christoffer - January 9, 2013

   Thank you for this! The code worked straight out of the box.
6. 

   Alamoxie Web Design - January 9, 2013

   Thanks Christoffer! I really appreciate it.
7. 

   John M. - January 10, 2013

   Hey there: thanks for this site, very helpful, but I’m having trouble making this work. Would be able to take a look at my code below?

   When I submit the form, I don’t get an email…

   Much appreciate your help..

   function onFormSubmit(e) {
   var timestamp = e.values[0];
   var yourName = e.values[1];
   var toAddress = e.values[2];
   var payTo = e.values[5];
   var payToAddress = e.values[6];
   var amount = e.values[7];
   var subject = “SFA Check Request Confirmation”;
   var emailBody = “Thank you for your check request submitted on ” + timestamp +
   “\n\nThe details you entered were as follows: ” +
   “\nPayee: ” + payTo +
   “\nMailing Address: ” + payToAddress +
   “\nCheck Amount: ” + amount
   “\nThis check will be process and mailed as you have requested.”
   “\nif the recipient does not received the check within 30 days,”
   “\ncall John Mesko at 763-260-0209”;
   var htmlBody = “Thank you for your SFA check request submitted on ” + timestamp +
   “ The details you entered were as follows: ” +
   “Payee: ” + payTo +
   “Mailing Address: ” + payToAddress +
   “Check Amount: ” + amount;
   “This check will be process and mailed as you have requested.”
   “if the recipient does not received the check within 30 days,”
   “call John Mesko at 763-260-0209”;
   MailApp.sendEmail(toAddress, subject,
   emailBody);
   }
8. 

   Alamoxie Web Design - January 10, 2013

   John, the first things to check are error logging and your trigger. Make sure to follow the instructions about setting the trigger very carefully; is it set up to run your code when a form is submitted? Did you choose to be immediately alerted to any errors if there are problems when running the script? Are you getting any errors? Also see if the email is going to your spam folder, just in case.
9. 

   John M. - January 10, 2013

   Hey its’ working great!!

   Thanks!!
10. 

    Alamoxie Web Design - January 10, 2013

    At a quick glance, John, it looks like you may be missing some + signs for your string concatenation in your emailBody and htmlBody. Look into that, but if you’re sure the trigger is working, a good thing to do is a very simple use case… just try something like
    MailApp.sendEmail(“myemail@mydomain.com”, “test subject”, “the email got sent, yay!”);
    If that doesn’t work, then you know there must be a problem with the trigger. If that does work, then you can gradually add in more of your code until you find what causes the problem.
11. 

    daveg - January 19, 2013

    Nice write up and example, I appreciate your posting this.

    How can I reference a second work sheet’s values instead of the first work sheet’s?
12. 

    Alamoxie Web Design - January 19, 2013

    Two things, daveg:
    1. If you’re talking about the values that are passed to the function, those are the values entered in the form, which will always go to the primary work sheet of the spreadsheet.
    2. If you want to read values, not from what was just entered in a form but from specific preexisting cells in the spreadsheet (which is a bit different than what the post discusses) you can do that.

    SpreadsheetApp.getActiveSheet().getRange(‘F2’).getValue();

    (Example extrapolated from http://stackoverflow.com/questions/11334296/google-docs-script-set-cell-value)
13. 

    daveg - January 19, 2013

    Thanks for the response. As it turns out what I was trying to do was a bit of math on the entered values on another sheet to go into the email, but the values aren’t in the spreadsheet until the submit event, so the math always failed. I solved it by doing the math in the script instead, which worked just fine. Just had to approach the problem from a different direction.
14. 

    Dave - January 25, 2013

    I’m trying to adhere to your email width warning. I can’t seem to get a carriage return to work in my confirmation email. I’m not sure what I’m doing wrong? The script is working great, just not the line returns?

    https://docs.google.com/spreadsheet/ccc?key=0Ai_2YLvaQba0dHFEc3J3TmN6dm5xYWVtczZmQzNpVmc#gid=0

    Thanks,

    Dave
15. 

    Alamoxie Web Design - January 25, 2013

    Dave, can you show the code?
    For the confirmation email, remember that there are actually two versions of the message: plain text and HTML. What shows to the recipient will depend on their email client–most (but not all) modern clients will show the HTML version.

    For the plain text email, you use \n to indicate that Google Apps Script should replace it with an invisible newline character.

    For HTML, you need to use HTML/CSS… the easiest way is to use the line break tag <br/>
16. 

    Dave - January 25, 2013

    Alamoxie, thanks for the help.

    Here is the code. I actually took out the HTML code since it’s such a simple message.

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var sessionDate = e.values[1];
    var firstName = e.values[2];
    var toAddress = e.values[4];
    var visitorComment = e.values[5];
    var subject = “Todd Talk Confirmation – ” + sessionDate;
    var emailBody = firstName + “, thank you for registering to Todd Talks on ” + timestamp +
    “\n\nYou are reserved for the Todd Talk Session on: ” + sessionDate +
    “\nThe session you’ve reserved will be held in the ” +
    “\nexecutive board room on the 3rd floor of the ” +
    “\nHannibal Regional Medical Building. ” +
    “\n\nIf you have questions please email Jean at ” +
    “\nmyemail@mydomain.com or call X1605 ” +
    “\n\nThank you again for registering.” +
    “\n\nWe look forward to seeing you on ” + sessionDate;
    MailApp.sendEmail(toAddress, subject,

    emailBody);
    }

    Thanks again for trying to help me.
17. 

    Alamoxie Web Design - January 25, 2013

    And what does the email look like? I can’t see for myself unless you provide a link to the public form itself (not the spreadsheet)
18. 

    Dave - January 25, 2013

    Sorry… I thought you could get into and edit everything on the sheet because I publically shared it with edit rights.

    Here is the form.

    https://docs.google.com/spreadsheet/viewform?formkey=dHFEc3J3TmN6dm5xYWVtczZmQzNpVmc6MQ#gid=1
19. 

    Dave - January 25, 2013

    Here is what I came up with after talking with Chad. I took out the HTML code and the optAdvancedArgs.

    It works perfectly with GMail, but the Outlook response is less than desirable. Go figure…

    So, I put them back and the script works perfectly.

    Thanks Chad for all your help. You ROCK!
20. 

    Alamoxie Web Design - January 25, 2013

    No problem Dave, glad you got it sorted out!
21. 

    Kristin - January 30, 2013

    I got the original code working and I must say it is amazing to finally find something that functions. Unfortunately I have had to make a good deal of changes to the content of the email message and in doing so have I think royally screwed it up. Do you think you could help me out? Also, sorry for the long code.

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var firstName = e.values[1];
    var lastName = e.values[2];
    var email = e.values[3];
    var phoneNumber = e.values[4];
    var mecLib = e.values[5];
    var specAccom = e.values[6];
    var bbFirstText = “Blackboard Collaborate First-Time Users”;
    var bbFirst = “http://support.blackboardcollaborate.com/ics/support/default.asp?

    deptID=8336&task=knowledge&questionID=1473”;
    var eliTipsText = “ELI Collaborate Tips”;
    var eliTips = “http://eli.nvcc.edu/it/tips.htm”;
    var mecEmailText = “MECLibraryClasses@nvcc.edu”;
    var mecEmail = “MECLibraryClasses@nvcc.edu”;
    var bbLinkText = “https://sas.elluminate.com/m.jnlp?sid=2011079&password=M.0834BD863E56FED5A281B7F0939BFE”;
    var bbLink = “https://sas.elluminate.com/m.jnlp?sid=2011079&password=M.0834BD863E56FED5A281B7F0939BFE”;
    var subject = “MEC Library Researcg Class Registration Confirmation – ” + firstName + ” ” + lastName;
    var emailBody = “Thank you for registering for a research class with the MEC Library.” +
    “\n\nFor your online class, you will need to a good internet connention and speakers or headphones to

    participate in the course. Please check that your computer is able to successfully run Collaborate by visiting

    the ” + ” ” + document.write(bbFirstText.link(bbFirst)) + ” ” + “page prior to class. If you will attend the

    virtual session from an off-campus location, have your MyNOVA username and password nearby; you will need to

    login to the library databases.” +
    “\n\nOn the evening of your class, click the link below to enter the virtual classroom.” +
    “\n ” + document.write(bbLinkText.link(bbLink)) +
    “\n\nAfter you click the link, a popup will ask you to enter your username. Please enter your first and last

    name as your username (This will be used for attendance purposes).” +
    “\nOnce you successfully enter the classroom, you will need to set up your microphone and audio. On the top

    toolbar, click on Tools > Audio > Audio Setup Wizard. The wizard will take you through the audio setup

    process.” +
    “\n\nIf you have any problems accessing the Collaborate Classroom, try visiting the ” + ” ” + document.write

    (eliTipsText.link(eliTips)) + ” ” + “page or contact ELI IT at 703-764-5051 for further assistance. The ELI IT

    office clases at 8pm – please leave yourself enough time to manage technical issues should they arise.” +
    “\n\nWe look forward to meeting you virtually!” +
    “\n\nMEC Library” +
    “\n ” + document.write(mecEmailText.link(mecEmail));
    var htmlBody = “Thank you for registering for a research class with the MEC Library.” +
    ” For your online class, you will need a good internet connection and speakers or headphones to

    participate in the course. Please check that your computer is able to successfully run Collaborate by visiting

    the ” + ” ” + document.write(bbFirstText.link(bbFirst)) + ” ” + “page prior to class. If you will attend the

    virtual session from an off-campus location, have your MYNOVA username and password nearby; you will need to

    login to the library databases.” +
    ” On the evening of your class, click the link below to enter the virtual classroom.” +
    ” ” + document.write(bbLinkText.link(bbLink)) +
    ” After you click the link, a popup will ask you to enter your username. Please enter your

    first and last name as your username (This will be used for attendance purposes).” +
    “Once you successfully enter the classroom, you will neeed to set up your microphone and audio. On the

    top toolbar, click on Tools > Audio > Audio Setup Wizard. The wizard will take you through the audio

    setup process.” +
    ” If you have any problems accessing the Collaborate Classroom, try visiting the ” + ” ” +

    document.write(eliTipsText.link(eliTips)) + ” ” + “page or contact ELI IT at 703-764-5051 for further

    assistance. The ELI IT office clases at 8pm – please leave yourself enough time to manage technical issues

    should they arise.” +
    ” We look forward to meeting you virtually!” +
    ” MEC Library” +
    ” ” + document.write(mecEmailText.link(mecEmail));
    var optAdvancedArgs = {name: “MEC Library Class Registration”, htmlBody: htmlBody};
    MailApp.sendEmail(email, subject,
    emailBody, optAdvancedArgs);
    }
22. 

    Kristin - January 30, 2013

    Some of my html got deleted out somehow…sorry again.

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var firstName = e.values[1];
    var lastName = e.values[2];
    var email = e.values[3];
    var phoneNumber = e.values[4];
    var mecLib = e.values[5];
    var specAccom = e.values[6];
    var bbFirstText = “Blackboard Collaborate First-Time Users”;
    var bbFirst = “http://support.blackboardcollaborate.com/ics/support/default.asp?deptID=8336&task=knowledge&questionID=1473”;
    var eliTipsText = “ELI Collaborate Tips”;
    var eliTips = “http://eli.nvcc.edu/it/tips.htm”;
    var mecEmailText = “MECLibraryClasses@nvcc.edu”;
    var mecEmail = “MECLibraryClasses@nvcc.edu”;
    var bbLinkText = “https://sas.elluminate.com/m.jnlp?sid=2011079&password=M.0834BD863E56FED5A281B7F0939BFE”;
    var bbLink = “https://sas.elluminate.com/m.jnlp?sid=2011079&password=M.0834BD863E56FED5A281B7F0939BFE”;
    var subject = “MEC Library Researcg Class Registration Confirmation – ” + firstName + ” ” + lastName;
    var emailBody = “Thank you for registering for a research class with the MEC Library.” +
    “\n\nFor your online class, you will need to a good internet connention and speakers or headphones to participate in the course. Please check that your computer is able to successfully run Collaborate by visiting the ” + ” ” + document.write(bbFirstText.link(bbFirst)) + ” ” + “page prior to class. If you will attend the virtual session from an off-campus location, have your MyNOVA username and password nearby; you will need to login to the library databases.” +
    “\n\nOn the evening of your class, click the link below to enter the virtual classroom.” +
    “\n ” + document.write(bbLinkText.link(bbLink)) +
    “\n\nAfter you click the link, a popup will ask you to enter your username. Please enter your first and last name as your username (This will be used for attendance purposes).” +
    “\nOnce you successfully enter the classroom, you will need to set up your microphone and audio. On the top toolbar, click on Tools > Audio > Audio Setup Wizard. The wizard will take you through the audio setup process.” +
    “\n\nIf you have any problems accessing the Collaborate Classroom, try visiting the ” + ” ” + document.write(eliTipsText.link(eliTips)) + ” ” + “page or contact ELI IT at 703-764-5051 for further assistance. The ELI IT office clases at 8pm – please leave yourself enough time to manage technical issues should they arise.” +
    “\n\nWe look forward to meeting you virtually!” +
    “\n\nMEC Library” +
    “\n ” + document.write(mecEmailText.link(mecEmail));
    var htmlBody = “Thank you for registering for a research class with the MEC Library.” +
    ” For your online class, you will need a good internet connection and speakers or headphones to participate in the course. Please check that your computer is able to successfully run Collaborate by visiting the ” + ” ” + document.write(bbFirstText.link(bbFirst)) + ” ” + “page prior to class. If you will attend the virtual session from an off-campus location, have your MYNOVA username and password nearby; you will need to login to the library databases.” +
    ” On the evening of your class, click the link below to enter the virtual classroom.” +
    ” ” + document.write(bbLinkText.link(bbLink)) +
    ” After you click the link, a popup will ask you to enter your username. Please enter your first and last name as your username (This will be used for attendance purposes).” +
    “Once you successfully enter the classroom, you will neeed to set up your microphone and audio. On the top toolbar, click on Tools > Audio > Audio Setup Wizard. The wizard will take you through the audio setup process.” +
    ” If you have any problems accessing the Collaborate Classroom, try visiting the ” + ” ” + document.write(eliTipsText.link(eliTips)) + ” ” + “page or contact ELI IT at 703-764-5051 for further assistance. The ELI IT office clases at 8pm – please leave yourself enough time to manage technical issues should they arise.” +
    ” We look forward to meeting you virtually!” +
    ” MEC Library” +
    ” ” + document.write(mecEmailText.link(mecEmail));
    var optAdvancedArgs = {name: “MEC Library Class Registration”, htmlBody: htmlBody};
    MailApp.sendEmail(email, subject,
    emailBody, optAdvancedArgs);
    }
23. 

    Dave - February 6, 2013

    I’m having one minor issue. Everything is working fine, but when our team members receive the confirmation email it says the persons name in From: of which I have set this up for but my email address is next to hers?

    The reply address is correct if you hit reply, but since I setup the form and script, I guess it’s using my email address as the From?

    Thanks for any help you can throw my way.
24. 

    Alamoxie Web Design - February 6, 2013

    If you’ll remember, you had to explicitly grant permission for the doc to send emails from your account–that only works for your individual account. If you want it to come from a different Google account (Google Apps won’t let you spam the from address, at least not reliably) then you would need to go into their Google Apps account, create the trigger and grant that permission–you may need to add the full script itself as well under the other user account, even though it is for the same draft. Hope this helps!
25. 

    Christina W - February 22, 2013

    Setting up a conference website. Your code is working perfectly for me! I really appreciate you having this out here. Thanks!
26. 

    Alamoxie Web Design - February 23, 2013

    You’re quite welcome Christina, glad it helps!
27. 

    Ros - February 27, 2013

    when i past the script and when it runs, it is appear that “TypeError: Cannot read property “values” from undefined. (line 2, file “Code”)”

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var Name = e.values[1];
    var email = e.values[1];
    var subject = “Registration Confirmation – National Training Course “;
    var emailBody = “Dear ” + Name +
    “\nThis is to confirm that you have successully registered on” + timestamp + ” for the training couse on Disaster Preparedness and Reponse”
    “\n\nThe details you entered were as follows: ” +
    “\nYour Name appear on certificate: ” + Name +
    “\nTraining Venue: Cambodia Japanese Cooperation Centre of Ruyal University of Phnom Penh ”
    “\nTraining Date: 25 March 2013 to April 2013 ”
    “\n\nSincerely, ”
    “\n\nCHF Secretariat ”
    MailApp.sendEmail(email, subject,
    emailBody);
    }

    any idea?
28. 

    himanshu - March 1, 2013

    Hi.. Thanks for the script.

    I have modified the script as per my requirement but it gives me an error “TypeError: Cannot read property “values” from undefined. (line 2, file “Code”)”….what is it that i am missing. Kindly guide.

    Thanks in advance..
29. 

    Manny G - March 1, 2013

    Great script, works very well! I appreciate you sharing with all of us!
30. 

    Alamoxie Web Design - March 2, 2013

    Ros/himanshu – the first thing I would doublecheck is that you are running the script by submitting a new form entry. That data becomes the “e” in the script. If you run the script by itself manually, it will always fail because no form data is being passed into it. Please start at the top of the blog post again and carefully follow the directions step by step to set up the script, form and trigger, and I think it will work better. 🙂

    Manny – thank you!
31. 

    Donnie - March 7, 2013

    How do I know what my form values should be? My form contains Full Name, Email, Company Name, Desired Training (with training titles listed next to radio bullets), Desired Session. Do I look in the forms source code to find the values? I tried just using these titles from my form but it doesn’t allow the spaces. Obviously I don’t know anything about using script. I am trying to use your script to send a confirmation to trainees when they sign up for a training session. Please help. I believe I do have the triggers set appropriately.

    The script is as follows:

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var FullName = e.values[1];
    var CompanyName = e.value[2];
    var Email = e.values[3];
    var DesiredTraining = e.values[4];
    var DesiredSession = e.values[5];
    var subject = “LAMCO Training Confirmation – ” + DesiredTraining + ” ” + DesiredSession;
    var emailBody = “Thank you for using LAMCO to meet your training needs. Reservation Timestamp: ” + timestamp +
    “\n\nThe details you entered were as follows: ” +
    “\nFull Name: ” + FullName +
    “\nEmail: ” + Email +
    “\nDesired Training: ” + DisiredTraining +
    “\nDesired Session Start Date: ” + DesiredSession +
    “\nCompany Name : ” + CompanyName;
    var htmlBody = “Thank you for registering. Your request was submitted on ” + timestamp +
    “ The details you entered were as follows: ” +
    “Full Name: ” + FullName +
    “Email: ” + Email;
    var optAdvancedArgs = {name: “LAMCO and Associate”, htmlBody: htmlBody};
    MailApp.sendEmail(toAddress, subject,emailBody);
    MailApp.sendEmail(‘donniemc@att.net’, ‘testsubject’, ‘the email got sent, yay!’);
    }
32. 

    Alamoxie Web Design - March 8, 2013

    Donnie, the variable names (like “var FullName”) are unimportant–they’re just for your use so you can refer to that value consistently throughout the code. “e” represents a collection of data that the user submitted in the form. e.values[0] will always be the timestamp, then the others will be the form fields in order. If you look at the spreadsheet, column A will be e.values[0], column B is e.values[1], column C is e.values[2], etc. Does that help?
33. 

    Donnie - March 8, 2013

    Yes. That helps. But still not working.
34. 

    Donnie - March 9, 2013

    Thanks so much for your assistance. The final scipt is working great.

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var FullName = e.values[1];
    var Email = e.values[2];
    var Training = e.values[3];
    var SessionDate = e.values[4];
    var Employer = e.values[5];
    var subject = “Registration Confirmation “;
    var emailBody = “Thank you for using THISCOMPANY to meet your training needs.” +

    “\n\nThe details you entered on ” + timestamp + ” were as follows: ” +
    “\nFull Name: ” + FullName +
    “\nEmail: ” + Email +
    “\nDesired Training: ” + Training +
    “\nDesired Session Start Date: ” + SessionDate +
    “\nEmployer: ” + Employer;
    var htmlBody = “Thank you for registering. Your request was submitted on ” + timestamp;

    “ The details you entered were as follows: ” +
    “Full Name: ” + FullName +
    “Email: ” + Email +
    “Desired Training: ” + Training +
    “Desired Session Start Date: ” + SessionDate +
    “Employer: ” + Employer;

    MailApp.sendEmail(Email, subject,emailBody);
    }
35. 

    Kevin - March 16, 2013

    This worked great for me. Thanks very much for an excellent tutorial.
36. 

    Chris - March 25, 2013

    I was searching for a simple tutorial on this. I appreciate how you anticipated some basic questions from a non-expert like me. Works great. Thank you.
37. 

    Lue - March 25, 2013

    Dear Alamoxie,

    I was very grateful when I found your tips,it would be great if it worked. However, perhaps it was just another so sent email case. I was trying with the short and long form however the result was just the same. I couldn’t figure out where was the wrong one.

    https://docs.google.com/spreadsheet/ccc?key=0Auenjo3sgd1wdEhXSHR4SHptTS03SjZYWXZZSVhpc3c#gid=0

    function onFormSubmit(e) {

    var timestamp = e.namedValues[0];

    var yourName = e.values[1];

    var toAddress = e.values[2];

    var subject = “CAP Confirmation – ” + eventName + ” ” + visitDate;

    var emailBody = “Thank you for your Club Ambassador Program report submitted on ” + timestamp +

    “\n\nThe details you entered were as follows: ” +

    “\nYour Name: ” + yourName +

    “\nYour Email: ” + toAddress ;

    var htmlBody = “Thank you for your Club Ambassador Program report submitted on ” + timestamp +

    “ The details you entered were as follows: ” +

    “Your Name: ” + yourName +

    “Your Email: ” + toAddress;

    var optAdvancedArgs = {name: “Club Ambassador Program”, htmlBody: htmlBody};

    MailApp.sendEmail(toAddress, subject,

    emailBody, optAdvancedArgs);
    }

    Kinda a lot of copy paste from yours, but still I got no response in my inbox.
    I am looking forward to your kindess and help.
38. 

    Alamoxie Web Design - March 25, 2013

    Chris, Kevin — thanks so much! I’m glad it helped.

    I wouldn’t be able to see your spreadsheet without you granting access to me, and even then I wouldn’t see your code.

    Lue:
    “var timestamp = e.namedValues[0];” – should be e.values, not e.namedValues
    “var subject = “CAP Confirmation – ” + eventName + ” ” + visitDate;” – since your form is not using eventName or VisitDate, you should remove them. Change the subject to something appropriate for you.

    Other than that, a few common things to check:
    Does your form have the person’s name as the first field, and an email address as the second field?
    Did you set up the trigger?
    Did you set the trigger to email you with error messages when a script fails?
    Are you testing it by actually submitting the form?
    Are you entering a valid email address in the form’s email field?
    Did the email go to spam?

    Also, here’s a common debugging technique: get it to the simplest version that works. For example, you could try something like

    function onFormSubmit(e) {

    var subject = “Test”;

    var emailBody = “Test message”;

    MailApp.sendEmail(“lues-email-address@youremailservice.com”, subject,

    emailBody, optAdvancedArgs);
    }

    If that works, great–start adding pieces back in until it breaks, then you know where the problem is. If even that simplest version doesn’t work, then you need to check your email address and the trigger.
39. 

    abhi - March 26, 2013

    how can i add attachment to the above mentioned script??
    thank you
40. 

    Alamoxie Web Design - March 26, 2013

    Abhi, you would use optAdvancedArgs. As described in https://developers.google.com/apps-script/class_mailapp

    var myFiles = [{fileName:”my_document.html”, content:”Insert any HTML content here”}]
    MailApp.sendEmail(“mikemike@gmail.com”, “Attachment example”, “Here is my document”, {attachments: myFiles});

    However, that requires the body of your file to be in the script, which is not what you want.

    Far and away the easiest method in this case–or in most cases where you want to email attachments–would probably be to put the file on Dropbox (or your web server) and then just put a link to it in the email. That way you aren’t cluttering people’s inboxes with attachments.
41. 

    harish - March 27, 2013

    Hi ,

    I have tried all the above options , but still am not able to get the mail notification when users submit on the form.

    The spreadsheet has the below columns
    1. timestamp
    2. name
    3. contact number
    4. email address

    function myFunction() {

    }

    function onFormSubmit(e) {

    //var timestamp = e.values[0];
    var yourName = e.values[1];
    // var yourFirstName = e.values[1];
    //var yourLastName = e.values[2];
    var toAddress = e.values[3];
    var subject = “TN Toastmasters Conference Confirmation”;

    var emailBody = “Dear ” +yourName +
    “\n\n Thank you for registering for TAMIL NADU TOASTMASTERS ANNUAL CONFERENCE and extending your support .”

    “\n\nPlease add your name in the description .”
    “\n\nYou can also contact harish”
    “\n\n — Team TamilNadu Toastmasters “;
    var optAdvancedArgs = {name: “Tamil Nadu Toastmasters Conference ~ 2013”, htmlBody: htmlBody};
    MailApp.sendEmail(toAddress, subject,emailBody, optAdvancedArgs);
    }
42. 

    harish - March 27, 2013

    Would appreciate if you could send me an email or provide your contact # for me to call and get this sorted
43. 

    Alamoxie Web Design - March 27, 2013

    Harish, some suggestions:
    delete myFunction()
    Add plus signs to connect the different strings for your emailBody–currently you have strings separated by quotes with no plus signs between them
    You have no htmlBody, so remove that from optAdvancedArgs

    Make sure your trigger is set up, that you have set it to notify you immediately of errors when running the script, that you are testing the script by submitting a form and that the email does not go into spam.

    You can also try testing it by using a simpler form of the script–a shorter emailBody and “youremail@whateveryouremailis.com” instead of toAddress in the MailApp call, to see if it goes through then or not.
44. 

    Luda - March 31, 2013

    Hey,

    I copied your code but when I try to run it, I get this error message:

    TypeError: Cannot read property “values” from undefined. (line 3, file “Code”)

    Here’s my code. Can you please tell me how I can fix it?

    function onFormSubmit(e)
    {
    var timestamp = e.values[0];

    var Event = e.values[1];

    var FName = e.values[2];

    var Lname = e.values[3];

    var Email = e.values[4];

    var subject = “Accounting Society Community Service Sign-up”;
    var emailBody = “Thank you for signing up for the ” + event + “event!”
    “/n/nThis is an automated response to confirm that we’ve received your online sign-up. ”
    “/n/nYou will receive a final confirmation email within 48 hours from us.”
    “/n/nIf you have any questions, please feel free to contact us.”

    var htmlBody = “Thank you for signing up for the event ” + event + “!” +
    “This is an automated response to confirm that we’ve received your online sign-up.” +
    “You will receive a final confirmation email within 48 hours from us.” +
    “If you have any questions, please feel free to contact us.”

    var optAdvancedArgs = {name: “Accounting Society Community Service”, htmlBody: htmlBody};

    MailApp.sendEmail(Email, subject,

    emailBody, optAdvancedArgs);

    }
45. 

    Anj Shaw - April 1, 2013

    Everything works SPLENDIDLY, except I would like to have my email include a cell on the active row that is not within the form. In this case, I have another script that generates an auto-incrementing ProjectID in column C, which is not part of the form, so can’t call the e.value.

    I want my email to say:

    “Thank you for your Capital Project form submission.
    Your Project ID is” + ProjectID

    (Where ProjectID is column C, active row.)

    Please help!

    Current script:

    function onFormSubmit(e) {
    var timestamp = e.values[0];
    var Username = e.values[1];
    var ProjectID = e.values[2]; (this is actually calling next consecutive column or form field, not what I want… I want ProjectID, which is outside of form but on spreadsheet)

    var ProjectName = e.values[9];
    var subject = “Capital Project Confirmation – ” + ProjectID + ” ” + ProjectName;
    var emailBody = “Thank you for your Capital Project form submission.” +
    “\n\nYour Project ID is: ” + ProjectID
    “\nPlease refer to this number when communicating about your project, or, when you submit a change.”
    var htmlBody = “Thank you for your Capital Project form submission” +
    “ Your Project ID is: ” + ProjectID
    “Please refer to this number when communicating about your project, or, when you submit a change.: ”
    var optAdvancedArgs = {name: “Capital Project Confirmation”, htmlBody: htmlBody};
    MailApp.sendEmail(Username, subject,
    emailBody, optAdvancedArgs);
    }
46. 

    Alamoxie Web Design - April 2, 2013

    Luda, make sure you run your code by actually submitting a form. You can’t just run the code directly from the script editor.
47. 

    Alamoxie Web Design - April 2, 2013

    Anj, I know this is possible, but I haven’t looked into how exactly to do it. My guess is that you would need to get a reference to the sheet, look up the timestamp from e.values(0), find out what row that is in, and then use that to look up the exact cell value you need–if you do some Googling and experimentation and find out, make sure to post your answer here! 🙂
48. 

    Anj - April 2, 2013

    Hm, I realized last night that the reason it won’t work (within or without the form data) is because the script runs on submit. So… if I have a script generating a unique id that ALSO runs on submit, these scripts occur simultaneously and if my email script looks for data in the ID field, it correctly finds nothing, because it hasn’t been populated yet.

    Ideally, I could have a counter or delay in the email script that could loop back to pick up the ID number generated by the on submit script.

    Does anyone know how I could achieve this? I have also thought of cheating and creating a separate sheet that would be a manager’s approval sheet, and linking the two by script (so, user fills out the capital request, email goes to manager to approve, manager reviews and clicks to approve, generating a project ID which is then emailed with confirmation [and project ID] to user. Anyone want to help me build that? 😛
49. 

    LM - April 3, 2013

    Excellent tutorial. Works perfectly. Thanks for your time!