Whats up there now is a a Google Form. I created a custom script on the spreadsheet that sends a confirmation email to me and then sender. Still not sure why none of the plugins are working…but thanks…
/* Send Confirmation Email with Google Forms */
//TRIGGERS WHEN THERE IS A NEW FORM RESPONSE
function Initialize() {
var triggers = ScriptApp.getProjectTriggers();
for (var i in triggers) {
ScriptApp.deleteTrigger(triggers[i]);
}
ScriptApp.newTrigger(“SendConfirmationMail”)
.forSpreadsheet(SpreadsheetApp.getActiveSpreadsheet())
.onFormSubmit()
.create();
}
//BEGINS COMPOSING THE EMAIL
function SendConfirmationMail(e) {
try {
var ss, cc, sendername, subject, columns; //DO NOT CHANGE “CC” TO “BCC” (IT WON’T WORK!)
var message, value, textbody, sender;
cc = “[email protected]”; //EMAIL THAT WILL BE CC’D ON THE CONFIRMATION TO THE USER
// SENDER NAME FOR THE EMAIL
sendername = “Team 1836: Milken Knights”;
//SUBJECT FOR THE EMAIL
subject = “Thanks for contacting Team 1836!”;
//BODY FOR THE EMAIL
message = “Thank you for submitting the contact form! A team member has recieved your information and will get back to you soon.
In the mean time, stay up to date with us:
Website: milkenknights.com
Facebook: fb.com/TheMilkenKnights
Twitter: @milkenknights
Thanks!
Team 1836
Here’s the data submitted on the form:
“;
ss = SpreadsheetApp.getActiveSheet();
columns = ss.getRange(1, 1, 1, ss.getLastColumn()).getValues()[0];
//SUBMITTED EMAIL ADDRESS
sender = e.namedValues[“Email Address”].toString();
// DOES NOT INCLUDE BLANK VALUES
for (var keys in columns) {
var key = columns[keys];
var val = e.namedValues[key] ? e.namedValues[key].toString() : “”;
if (val !== “”) {
message += key + ‘ :: ‘ + val + “
“;
}
}
//USE
FOR LINE BREAKS. GOOGLE WILL CONVERT TO \N
textbody = message.replace(“
“, “\n”);
//SEND EMAIL
GmailApp.sendEmail(sender, subject, textbody, {
cc: cc,
name: sendername,
htmlBody: message
});
} catch (e) {
Logger.log(e.toString());
}
}