javascript - 函数未使用定义的变量执行

Question

该项目的要点是:我有 Google 表单答案，这些答案会填充到 Google 文档中，我们将此文档称为模板。模板是复制的，所以我永远不会覆盖原始模板。该副本将转换为 PDF、发送到电子邮件并移至我的云端硬盘上的特定文件夹。每次提交表单时都会完美地执行此功能，并在提交时触发。我的下一个功能应该是将复制的文档发送到我的 Google 云打印，但我在编写代码时遇到了麻烦。我已经做到了它将在表单提交上打印文档，但我必须专门定义文档的 ID。不幸的是，ID 不是静态的，因为每次提交都会生成一个新文档。这是我的完整代码，减去任何敏感信息:

// Work Order


// Get template from Google Docs and name it
var docTemplate = ""; // *** replace with your template ID ***
var docName = "Work Order";

function addDates() {
  var date = new Date(); // your form date
  var holiday = ["09/04/2017", "10/09/2017", "11/23/2017", "12/24/2017", "12/25/2017", "01/01/2018"]; //Define holiday dates in MM/dd/yyyy
  var days = 5; //No of days you want to add
  date.setDate(date.getDate());
  var counter = 0;
  if (days > 0) {
    while (counter < days) {
      date.setDate(date.getDate() + 1);
      var check = date.getDay();
      var holidayCheck = holiday.indexOf(Utilities.formatDate(date, "EDT", "MM/dd/yyyy"));
      if (check != 0 && check != 6 && holidayCheck == -1) {
        counter++;
      }
    }
  }
  Logger.log(date) //for this example will give 08/16/2017
  return date;
}

function createNewDoc(values) {
//Get information from form and set as variables
  var email_address = "";
  var job_name = values[1];
  var ship_to = values[11];
  var address = values[12];
  var order_count = values[7];
  var program = values[2];
  var workspace = values[3];
  var offer = values[4];
  var sort_1 = values[5];
  var sort_2 = values[6];
  var image_services = values[9];
  var print_services = values[10];
  var priority = values[13];
  var notes = values[14];
  var formattedDate = Utilities.formatDate(new Date(), "EDT", "MM/dd/yyyy");
  var expirationDate = Utilities.formatDate(addDates(), "EDT", "MM/dd/yyyy");

  // Get document template, copy it as a new temp doc, and save the Doc's id
  var copyId = DriveApp.getFileById(docTemplate)
    .makeCopy(docName + ' for ' + job_name)
    .getId();
  // Open the temporary document
  var copyDoc = DocumentApp.openById(copyId);
  // Get the document's body section
  var copyBody = copyDoc.getActiveSection();

  // Replace place holder keys,in our google doc template  
  copyBody.replaceText('keyJobName', job_name);
  copyBody.replaceText('keyShipTo', ship_to);
  copyBody.replaceText('keyAddress', address);
  copyBody.replaceText('keyOrderCount', order_count);
  copyBody.replaceText('keyProgram', program);
  copyBody.replaceText('keyWorkspace', workspace);
  copyBody.replaceText('keyOffer', offer);
  copyBody.replaceText('keySort1', sort_1);
  copyBody.replaceText('keySort2', sort_2);
  copyBody.replaceText('keyImageServices', image_services);
  copyBody.replaceText('keyPrintServices', print_services);
  copyBody.replaceText('keyPriority', priority);
  copyBody.replaceText('keyNotes', notes);
  copyBody.replaceText('keyDate', formattedDate);
  copyBody.replaceText('keyDue', expirationDate);

  // Save and close the temporary document
  copyDoc.saveAndClose();

  // Convert temporary document to PDF by using the getAs blob conversion
  var pdf = DriveApp.getFileById(copyId).getAs("application/pdf");

  // Attach PDF and send the email
  var subject = "New Job Submission";
  var body = "Here is the work order for " + job_name + "";
  MailApp.sendEmail(email_address, subject, body, {
    htmlBody: body,
    attachments: pdf
  });

  // Move file to folder
  var file = DriveApp.getFileById(copyId);
  DriveApp.getFolderById("").addFile(file);
  file.getParents().next().removeFile(file);
}

function printGoogleDocument(copyId, docName) {
  // For notes on ticket options see https://developers.google.com/cloud-print/docs/cdd?hl=en
  var ticket = {
    version: "1.0",
    print: {
      color: {
        type: "STANDARD_COLOR"
      },
      duplex: {
        type: "NO_DUPLEX"
      },
    }
  };

  var payload = {
    "printerid": "",
    "content": copyId,
    "title": docName,
    "contentType": "google.kix", // allows you to print google docs
    "ticket": JSON.stringify(ticket),
  };

  var response = UrlFetchApp.fetch('https://www.google.com/cloudprint/submit', {
    method: "POST",
    payload: payload,
    headers: {
      Authorization: 'Bearer ' + GoogleCloudPrint.getCloudPrintService().getAccessToken()
    },
    "muteHttpExceptions": true
  });

  // If successful, should show a job here: https://www.google.com/cloudprint/#jobs

  response = JSON.parse(response);
  if (response.success) {
    Logger.log("%s", response.message);
  } else {
    Logger.log("Error Code: %s %s", response.errorCode, response.message);
  }
  return response;
}

// When Form Gets submitted
function onFormSubmit(e) {
  var values = e.values;
  createNewDoc(values);
  printGoogleDocument(copyId, docName);
}

Answer 1

从“createNewDoc(values);”返回新文档通过将其添加到 createNewDoc() 函数的末尾、右括号之前来更改函数:

//Starting at the code here
// Move file to folder
var file = DriveApp.getFileById(copyId);
DriveApp.getFolderById("").addFile(file);
file.getParents().next().removeFile(file);

//Add this
var newDocName = docName + ' for ' + job_name;
return [file, newDocName];
//To this point

}

然后更改 onFormSubmit() 函数，如下所示:

// When Form Gets submitted
function onFormSubmit(e) {
  var values = e.values;
  var returnedDocValues = createNewDoc(values);
  var file = returnedDocValues[0];
  var docName= returnedDocValues[1];
  printGoogleDocument(file, docName);
}

如果有错误，请告诉我，因为我自己没有测试过此代码。