Google Apps Script条件分支故障：合并表单后无法生成对应文档

我有一段Google Apps Script代码，原本用两个表单加两张表格分别处理添加、移除托管人业务，现在想合并成一套——在表单里设置单选框让用户选择「添加」或「移除」，但根据选项生成对应模板文档的逻辑没跑通，试了IF函数也没用，求技术支持。

预期逻辑：用户选择「移除」时，基于移除模板生成移除文档；选择「添加」时，基于添加模板生成添加文档。以下是我写的带IF分支的代码：

function autoFillGoogleDocFromForm(e) {
  var timestamp = e.values[0];
  var removaladdition = e.values[1];
  var CustomerName = e.values[2];
  var TrustName = e.values[3];
  var TrustDate = e.values[4];
  var CoTrusteeNames = e.values[5];
  var DocLink = e.values[6];

  if (removaladdition !== "Adding"){
    var templateFile = DriveApp.getFileById("xxxx");
    var templateResponseFolder = DriveApp.getFolderById("xxxx");

    var copy = templateFile.makeCopy(CustomerName + ' Appointment Of Co-Trustees', templateResponseFolder);
    var doc = DocumentApp.openById(copy.getId());

    var body = doc.getBody();

    body.replaceText('{{Customer Name}}', CustomerName);
    body.replaceText('{{Trust Name}}', TrustName);
    body.replaceText('{{Trust Date}}', TrustDate);
    body.replaceText('{{Co-Trustee Names}}', CoTrusteeNames);

    doc.saveAndClose();
  }

  if (removaladdition !== "Removing"){
    var templateFile = DriveApp.getFileById("xxxx");
    var templateResponseFolder = DriveApp.getFolderById("xxxx");

    var copy = templateFile.makeCopy(CustomerName + ' Removal Of Co-Trustees', templateResponseFolder);
    var doc = DocumentApp.openById(copy.getId());

    var body = doc.getBody();

    body.replaceText('{{Customer Name}}', CustomerName);
    body.replaceText('{{Trust Name}}', TrustName);
    body.replaceText('{{Trust Date}}', TrustDate);
    body.replaceText('{{Co-Trustee Names}}', CoTrusteeNames);

    doc.saveAndClose();
  }
}

问题根源 #

你的IF条件判断逻辑完全写反了：

• 第一个判断removaladdition !== "Adding"表示只要不是「Adding」就执行添加文档生成，当用户选「Removing」时，这个条件成立，会错误生成添加文档；
• 第二个判断removaladdition !== "Removing"表示只要不是「Removing」就执行移除文档生成，当用户选「Adding」时，这个条件成立，会错误生成移除文档；
• 如果单选框值出现拼写错误、空值等异常，两个IF都会触发，生成两份错误文档。

修正后的代码 #

用精准匹配的if-else分支替代错误的逻辑，同时提取重复代码优化可读性：

function autoFillGoogleDocFromForm(e) {
  // 提取表单提交值
  var removaladdition = e.values[1];
  var CustomerName = e.values[2];
  var TrustName = e.values[3];
  var TrustDate = e.values[4];
  var CoTrusteeNames = e.values[5];

  // 定义模板和文件夹ID（替换成你的实际ID）
  const TEMPLATES = {
    "Adding": {
      id: "添加模板的ID",
      folderId: "添加文档存放文件夹ID",
      fileNameSuffix: " Appointment Of Co-Trustees"
    },
    "Removing": {
      id: "移除模板的ID",
      folderId: "移除文档存放文件夹ID",
      fileNameSuffix: " Removal Of Co-Trustees"
    }
  };

  // 匹配选项并生成文档
  if (removaladdition === "Adding") {
    generateDoc(TEMPLATES.Adding, CustomerName, TrustName, TrustDate, CoTrusteeNames);
  } else if (removaladdition === "Removing") {
    generateDoc(TEMPLATES.Removing, CustomerName, TrustName, TrustDate, CoTrusteeNames);
  } else {
    // 处理异常情况（可选）
    console.log("无效的选项值：" + removaladdition);
  }
}

// 提取重复的文档生成逻辑为独立函数
function generateDoc(templateConfig, customerName, trustName, trustDate, coTrusteeNames) {
  var templateFile = DriveApp.getFileById(templateConfig.id);
  var targetFolder = DriveApp.getFolderById(templateConfig.folderId);
  
  // 复制模板并命名
  var docCopy = templateFile.makeCopy(customerName + templateConfig.fileNameSuffix, targetFolder);
  var doc = DocumentApp.openById(docCopy.getId());
  var body = doc.getBody();

  // 替换占位符
  body.replaceText('{{Customer Name}}', customerName);
  body.replaceText('{{Trust Name}}', trustName);
  body.replaceText('{{Trust Date}}', trustDate);
  body.replaceText('{{Co-Trustee Names}}', coTrusteeNames);

  doc.saveAndClose();
}

关键修正点 #

1. 精准匹配条件：用===替代!==，确保只有选中对应选项时才执行对应逻辑；
2. if-else分支：避免两个IF同时触发的问题，逻辑互斥；
3. 代码优化：把模板配置和重复的生成逻辑分离，后续修改模板ID或文件夹更方便；
4. 异常处理：添加else分支捕获无效选项，便于排查问题。

内容的提问来源于stack exchange，提问作者Elizabeth Arcudi