Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Settings specific to project
- var formTitle = "Nursing Application";
- var formLink = "http://www.oc.edu/academics/nursing/"; // Top logo link back to event or informational page
- // Email Addresses - Who will be notified, and who will get the email when the visitor hits the "reply" button?
- var staffemail="youremailaddress";
- var staffemailcc="";
- var staffemailbcc="";
- var staffReply="youremailaddress";
- var visitorEmailColumn = 22; // Column "V" is column #22
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var form = ss.getSheetByName('Sheet1'); // This is the default when you make a spreadsheet - change if necessary
- function distributeForm(){
- var lastrow=form.getLastRow();
- sendInfo(lastrow);
- }
- function sendInfo(trow){
- var visitorReply=form.getRange(trow,visitorEmailColumn).getValue();
- var visitorFirstName = form.getRange(trow,2).getValue();
- var visitorLastName = form.getRange(trow,4).getValue();
- var sbj=visitorFirstName+' '+visitorLastName+' - '+formTitle;
- var thismessage='<HTML>'
- +'<head></head>'
- +'<body style="background-color:#ECF1F7;padding:0;margin:0;font-family:Helvetica, Arial, Verdana, sans-serif;font-size:12px;color:#fff;text-align:center;"><a href="'+formLink+'"><img src="http://www.oc.edu/lucid/ochome/images/oclogo.png"></a><br><table align="center" width="550px;" style="border:1px solid #D2D8DF;background:#ffffff;color:#000000;">'
- +'<tr><td colspan="2" style="border-bottom:1px solid #D2D8DF;"><b>'+ formTitle +'</td></tr>';
- var topArray=form.getRange(1,1,1,form.getLastColumn()).getValues();
- var trowArray=form.getRange(trow,1,1,form.getLastColumn()).getValues();
- for(var ff=1;ff<=form.getLastColumn();ff++){
- thismessage+='<tr><td style="border-bottom:1px solid #D2D8DF;">'+topArray[0][ff-1]+'</td><td style="border-bottom:1px solid #D2D8DF;">'+trowArray[0][ff-1]+'</td></tr>';
- }
- thismessage+='</table>'
- +'</body>'
- +'</HTML>';
- MailApp.sendEmail(staffemail,sbj,'', {name:formTitle,htmlBody:'Notification to '+formTitle+':<br>'+thismessage,bcc:staffemailbcc,replyTo:visitorReply});
- MailApp.sendEmail(visitorReply,'Confirmation - '+formTitle,'', {name:formTitle,htmlBody:'Confirmation to Visitor<br>'+thismessage,bcc:staffemailbcc,replyTo:staffReply});
- form.getRange(trow,1).setComment('emailed');
- }
- function arrayNotation(){
- var thisArray=form.getRange(1,1,1,form.getLastColumn()).getValues();
- Browser.msgBox(thisArray[0][2]);
- }
Add Comment
Please, Sign In to add comment