Guest User

Untitled

a guest
Jan 17th, 2019
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. var docTemplate = "DocsLinksHere";
  2. var docName = "Recruiting Requirement Profile -";
  3.  
  4. function onFormSubmit(e) {
  5. Logger.log(e)
  6.  
  7. var Q1 = e.values[2];
  8. var Q2 = e.values[3];
  9. var Q3 = e.values[4];
  10. var Q4 = e.values[5];
  11.  
  12.  
  13. var copyId = Driveapp.getFileById(docTemplate)
  14. .makeCopy(docName+Q4+' - '+Q1)
  15. .getId();
  16. var copyDoc = DocumentApp.openById(copyId);
  17. var copyBody = copyDoc.getbody();
  18.  
  19. copyBody.replaceText('keyQ1', Q1);
  20. copyBody.replaceText('keyQ2', Q2);
  21. copyBody.replaceText('keyQ3', Q3);
  22. copyBody.replaceText('keyQ4', Q4);
  23.  
  24.  
  25. copyDoc.saveAndClose();
  26.  
  27. var pdf = driveapp.getFileById(copyId).getAs("application/pdf");
  28.  
  29. var subject = DocName+Q4+"-"+Q1;
  30. var body = "Here is your "+docName+Q4+"-"+Q1;
  31. mailApp.sendEmail("name@name.com", subject, body, {htmlBody: body, attachments: [pdf]});
  32.  
  33. // Delete temp file
  34. driveapp.getFileById(copyId).setTrashed(true);
  35. }
Add Comment
Please, Sign In to add comment