Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var docTemplate = "DocsLinksHere";
- var docName = "Recruiting Requirement Profile -";
- function onFormSubmit(e) {
- Logger.log(e)
- var Q1 = e.values[2];
- var Q2 = e.values[3];
- var Q3 = e.values[4];
- var Q4 = e.values[5];
- var copyId = Driveapp.getFileById(docTemplate)
- .makeCopy(docName+Q4+' - '+Q1)
- .getId();
- var copyDoc = DocumentApp.openById(copyId);
- var copyBody = copyDoc.getbody();
- copyBody.replaceText('keyQ1', Q1);
- copyBody.replaceText('keyQ2', Q2);
- copyBody.replaceText('keyQ3', Q3);
- copyBody.replaceText('keyQ4', Q4);
- copyDoc.saveAndClose();
- var pdf = driveapp.getFileById(copyId).getAs("application/pdf");
- var subject = DocName+Q4+"-"+Q1;
- var body = "Here is your "+docName+Q4+"-"+Q1;
- mailApp.sendEmail("name@name.com", subject, body, {htmlBody: body, attachments: [pdf]});
- // Delete temp file
- driveapp.getFileById(copyId).setTrashed(true);
- }
Add Comment
Please, Sign In to add comment