Google Forms Confirmation Email with Attachment |Google Apps 

Sorry for the late reply, but thanks for watching!

Awesome! The fundamentals don't change all that month since Apps Script is so stable.

+Elena Alcalde Thanks for watching! Check out my blog linked in the video description for other cool things you can do with Google apps.

Thanks for watching!

+Tomahawk Diving Very cool. Glad you got it to work! Thanks for watching.

+Thomas Mwadime Hey Thomas, according to the docs, there is an onEdit trigger, but that might fire everytime you make a change, not just a change to one column: developers.google.com/apps-script/guides/triggers/ Not sure about the pop up, as that is outside the scope of what I do in Google Docs, but I'm sure you could find some good resources on Stack Overflow to get you started.

+Tomahawk Diving Hmm, everything looks alright. Set error notifications to send immediately and let me know what you receive.

That error displays when you don't have permission on that file. I'd request access from the owner of the file, and then you shouldn't see that error anymore.

@@jeffeverhart Thank you. It seems that I needed to log out of that gmail account and then it worked. Your code was perfect though. Thank you so much.

Diane Sierra According to the documentation, yes. Take a look at the example here. It looks like you just pass the two attachments into an array. developers.google.com/apps-script/reference/mail/mail-app#sendEmail(String,String,String,Object)

All of the customization options for Google forms should be in the UI for the form itself. Not sure it lets you change fonts, but will support uploaded images.

+Justo Dantas - Ousar com Responsabilidade Obrigado! Vou trabalhar nisso no futuro!

+Soe Min Latt Where is the code coming from?

Yup, just follow the same steps outlined here, but send the mail to you instead of another person.

+Jeff Everhart Thank you.

You're welcome! Thanks for watching

I don't know that you can set up a conditional trigger, but you could always set up a time driven trigger (to run after the due date) that could include some conditional logic. The programming would be different than this video though. You would need to loop over the spreadsheet and add the student who've submitted to an array, then compare those students to the whole class and then run the function if they don't appear in the completed array. Let me know if I can help to find some specific resources to get started. Always happy to help out a fellow educator! Cheers, JE

Great thank you will try.

Andrew Woodward Hello Jeff I would be grateful if you could point me at a starting place, I am trying to get the students to own their work more by being sign posted about where they are in their learning. Thank you for your support. Kindest regards Andy

Check to make sure the line of code that specifies the Mime Type is accurate with what is here: jeffreyeverhart.com/2015/01/30/tech-tip-google-forms-confirmation-email-with-attachments/ I'd assume that capitalization matters here: MimeType.PDF

Random Videos Sorry for the delayed reply, but you can just do that by manually accessing the spreadsheet range and putting the value in the final cell of the row you just modified: developers.google.com/apps-script/reference/spreadsheet/range

Random Videos Also check out get last row and get last column on the sheets app here: developers.google.com/apps-script/reference/spreadsheet/sheet

+Hala NE You can generate an email from the spreadsheet submission as I've shown here and populate the table as HTML in the email. You would just need to create an HTML table with spots in it for the variables submitted on the form. Other tutorial on sending email: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GuFZ78_NZtQ.html See this link on sending HTML body: developers.google.com/apps-script/reference/mail/mail-app#sendEmail(String,String,String,Object)

HomeScienceIdeas.com I have a bit of PHP and mySQL experience, so let me know if you want me to look at your code. PHP has a built in mail function. You can read about it here: stackoverflow.com/questions/5335273/how-to-send-an-email-using-php Basically, we are doing the same thing programmatically in PHP as in the tutorial for Google Apps. Create some PHP variables to hold POST data from HTML form. Transmit those same variables to the SQL database, and then populate an email with those variables and some other options if you want. Sometimes your hosting service may have some additional options of PHP plugins.

Right now I have a sort of Frankenstein code put together. It works a bit like I want it to but it is missing some stuff. It will send one part (email) to my database but not the name. It is a mix of two peoples code so I am trying to cut stuff out I don't need and put it what I do need but when I do that I get errors. WRONG CODE! See post below this one for the code...

I left out my database info but it connects:) My two tables in my database are "username" and "email". When I submit the form it will grab the "email" but it does not grab the "username". SORRY! That code was wrong:( HERE IS THE RIGHT CODE:

Here is the form: homefarmideas.com/phptest/Sendemail.html

HomeScienceIdeas.com In you SQL statement you try to transfer the value "$_POST[username]' into the table, but everywhere else it is $first_name or $last_name. When I viewed source on the HTML form there was no input for username. Switch this to either first name, last name or a variable that concatenates both first and last name for the username. Try that and let me know how it works out!

Rick DeLoach Hey Rick: That is a really interesting problem. I've never tried that, but there is one draw back. When you create the script, it asks you to authorize access to your drive, so I'm not sure how it would work to get a document out of someone else's drive. It might work because it is shared with you, but it would be worth a test drive. Another alternative would be to format the message as HTML and display the link or document URL in the body of the email. Do you want to try coding up an example and post it here or on my blog so we can troubleshoot?

Jeff Everhart The code below sends the output of my form to a defined distribution list as BCC in email AND saves a PDF version on a defined drive location. The code is below. Ideally, I need the user to submit an attachment that goes to the BCC distribution. These are all internal users so the document should be view permissions for anyone with the link. Here's the code I cobbled together from different sources (I'm not a developer). /* Send Google Form by Email v2.1 */ // www.labnol.org/internet/google-docs-email-form/20884/ /* For customization, contact the developer at amit@labnol.org */ /* Tutorial: www.labnol.org/?p=20884 */ function Initialize() { var triggers = ScriptApp.getProjectTriggers(); for(var i in triggers) { ScriptApp.deleteTrigger(triggers[i]); } ScriptApp.newTrigger("SendGoogleForm") .forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet()) .onFormSubmit() .create(); } function SendGoogleForm(e) { try { // You may replace this with another email address var email = Session.getActiveUser().getEmail(); var bccs = 'rdeloach@rentpath.com' var s = SpreadsheetApp.getActiveSheet(); var columns = s.getRange(1,1,1,s.getLastColumn()).getValues()[0]; var message = "ANNUAL VENDOR ASSESSMENT"; // Only include form fields that are not blank for ( var keys in columns ) { var key = columns[keys]; if ( e.namedValues[key] ) { message += key + ': ' var answer = ""; var answer = e.namedValues[key].toString(); //Replace with in rest of text var answer = answer.replace(/ /g, ''); message += answer + ""; // + e.namedValues[key] + ""; if (key=="Service Provider Name") { var Vendor = e.namedValues[key] ; } } } //Add Footer message += "=================================================================================" message += "All Annual Vendor Assessments can be found in this directory." // This is the MailApp service of Google Apps Script // that sends the email. You can also use GmailApp for HTML Mail. // Optional but change the following variable // to have a custom subject for Google Form email notifications var subject = "Annual Vendor Assessment for: "+Vendor; GmailApp.sendEmail(email, subject, message, {bcc:bccs, htmlBody:message}); //Save as PDF in folder var filename = 'AVA-'+Vendor+'.PDF' htmlToPDF(message,filename); } catch (e) { Logger.log(e.toString()); } } function htmlToPDF(html, filename) { var dir = DriveApp.getFoldersByName("Annual Vendor Assessments").next(); var blob = Utilities.newBlob(html, "text/html", "text.html"); var pdf = blob.getAs("application/pdf"); dir.createFile(pdf).setName(filename); }

Rick DeLoach Jeff Everhart It was easier than I thought - but I still need to test permissions. The assumption is the file is shared to everyone in the organization with view access. In the form, I ask the user to give me the google doc ID. Then I just use the DriveApp.getFileByID(fileID) command and use that in the GmailApp.sendEmail command ..attachments:[fileID] It don't even convert to PDF because that was failing (oddly enough) on certain file types.

Ok, cool. Yes, if the whole org uses Google Drive, then converting to PDF is unnecessary. Not sure what your audience is for this, but it might be helpful to add some help text about finding the document ID if you haven't already. If they end up putting something other than the actual ID, you'll end up with a lot of errors.

Matej Stanovský If the email still sends, what part of the script is not working? Can you post the code you're using here or on my blog so that I can take a look? Thxs

G&A Security NE Ltd It is, but that requires a few more steps and isn't something that I can explain in the comments. If you give me a few days, I can create another video explaining how to do it.

Jeff Everhart that would be great go slow please haha is their any way you take donations if that works you will have saved me and my company loads of time. bit cheeky but can it also be sent to a printer that is connected to the internet , is that possible also ? Thanks again your a star

all i need to send to printer is the email so that simple enough, can not wait for this video Jeff Everhart :D

Jeff Everhart have you had any luck ? many thanks

Awesome! Thanks for watching!

+Rodrigo Costa (rodricosta) Hello Rodrigo, I'm sure that's something you'd want to do with Google Apps Script, and if you did you'd need to build a fully functioning web app to do it. Since we are only editing things in the script editor of the spreadsheet, we don't really have access to other things outside the Google ecosystem this way. I might try looking for another tutorial that teaches you how to build a payment processing system in PHP instead, as this sounds more like what you are looking for. Thanks for watching!

First of all, thank you pretty much for the answer, yes PHP make more sense . So I'm looking all kind of things I could to do with Google platform. Another thing, instead PDF could I set slide presentation or videos, to be send automatic after form submission??? Thanks once again for your time and help , I really appreciate sir, regards.

You should be able to do that. Instead of getting the file as a mime type pdf, you can get it as a mime type MICROSOFT_POWERPOINT, as outlined in the docs here: developers.google.com/apps-script/reference/base/mime-type Let me know how that works out.

Hi sir, yap, but I have to type MICROSOFT_POWERPOINT so google have the similar tool , the slide presentation. so I'm working in my project and I was finish figure out some error I was , so I'll test those your script now and see how works here for me, one more thing, I have already a script working in my spreadsheet editor and that script allow me receive response in my spreadsheet and gmail at same time , this is really nice and I want keep it, so any problem if I add another function script in the same spreadsheet editor, sorry I'm so raw with java script , I was reading little about in w3school to understand better, but I don't much , so if I can use more than one script function in the same spreadsheet editor , how to separate those script to each one work fine. thanks alot sir, I appreciate , you have help me alot. thanks. regards.

Ok, =) take example of your code , I have to change just some script lines and that should work. var docs = DriveApp.getFilesByType(MimeType.GOOGLE_SLIDE); while (docs.hasNext()) { var doc = docs.next(); Logger.log(doc.getName()) }

I am using the following script... function myFunction(e) { var Name = e.values[1]; var Email = e.values[9]; var subject = "LSU Membership Confirmation"; var message = "Thank you, " + Name + " for choosing LSU CSI Services "; var waiver = DriveApp.getFileById("1jc-USEBFjI_z7-3zmCBuMVQSmvSxFijNYx6-wz0H_XU"); var liabilityWaiver = waiver.getAs(MimeType.GOOGLE_DOCS); MailApp.sendEmail(Email, subject, message, {attachments:[liabilityWaiver]}); }

+Emily Tatum It looks like the getFilesByType returns a collection of files, not just one file: developers.google.com/apps-script/reference/drive/drive-app?hl=en#getFilesByType(String) Why don't you just grab the single certificate file by ID?: developers.google.com/apps-script/reference/drive/drive-app?hl=en#getFileById(String) That way, you know that you are getting the one, singular file you need. Try that and let me know if it works or if there is some reason you need to get the collection of files.

+Emily Tatum The certificate variable you created is a folder, not a file. Use getFileById instead with certificate and that should work with what you have here.

You will need to make an HTML email using the htmlBody advanced parameter here:developers.google.com/apps-script/reference/mail/mail-app#sendEmail(String,String,String,Object)

Hey Jeff, I have gone through entire blog, but I am unable to track code for converting string to hyperlink. It would be great if you can send the code of just this, currently I am sending an auto reply with attachments, as per you tutorial. Regards, Piyush Ghiya