Google Apps Script会员表单自动填充文本替换失效问题排查

对比你的两个脚本，发现以下关键问题导致会员表单的占位符无法替换：

1. 方法名大小写错误（核心问题） #

会员脚本中打开复制文档时使用了错误的方法名：

var doc = DocumentApp.openById(copy.getID());

JavaScript是大小写敏感的，正确方法名为getId()（小写字母d），推荐脚本使用的是正确写法。这个错误会触发代码异常，导致后续文本替换逻辑完全不执行，因此文档仅被创建但无任何替换操作。

修复：

var doc = DocumentApp.openById(copy.getId());

2. 占位符格式不统一 #

会员脚本中第一个替换语句的占位符未加大括号：

body.replaceText("PreferredName", PreferredName);

而其他字段替换均使用{XXX}格式（如{Surname}），若模板文档中PreferredName的占位符是带大括号的{PreferredName}，这行代码将无法匹配内容，导致该字段替换失败。

修复：统一占位符格式：

body.replaceText("{PreferredName}", PreferredName);

3. 变量名拼写错误 #

会员脚本中紧急联系人变量拼写错误：

var EmergenyContact = e.values[16];

正确拼写应为EmergencyContact（少写了一个c），但替换时使用的是{EmergencyContact}，变量名不匹配会导致该字段替换失败。

修复：修正变量名并同步替换语句：

var EmergencyContact = e.values[16];
// 对应替换语句修改为
body.replaceText("{EmergencyContact}", EmergencyContact);

修复后的完整会员脚本 #

function AutoFillMembershipForm(e) {
  var Timestamp = e.values[0];
  var PreferredName = e.values[1];
  var Surname = e.values[2];
  var Pronouns = e.values[3];
  var Different = e.values[4];
  var DOB = e.values[5];
  var Address = e.values[6];
  var Phone = e.values[7];
  var Email = e.values[8];
  var Language = e.values[9];
  var Contact = e.values[10];
  var Legal1 = e.values[11];
  var Legal1Contact = e.values[12];
  var Legal2 = e.values[13];
  var Legal2Contact = e.values[14];
  var Emergency = e.values[15];
  var EmergencyContact = e.values[16];
  var Disability = e.values[17];
  var Medical = e.values[18];
  var Support = e.values[19];
  var Allergies = e.values[20];
  var GP = e.values[21];
  var GDPR = e.values[22];
  var Voicemail = e.values[23];

  var templateFile = DriveApp.getFileById("\id");
  var templateResponseFolder = DriveApp.getFolderById("\id");

  var copy = templateFile.makeCopy(PreferredName + " " + Surname + " " + DOB + " Membership", templateResponseFolder);
  var doc = DocumentApp.openById(copy.getId());

  var body = doc.getBody();

  body.replaceText("{PreferredName}", PreferredName);
  body.replaceText("{Surname}", Surname);
  body.replaceText("{Pronouns}", Pronouns);
  body.replaceText("{Different}", Different);
  body.replaceText("{DOB}", DOB);
  body.replaceText("{Address}", Address);
  body.replaceText("{Phone}", Phone);
  body.replaceText("{Email}", Email);
  body.replaceText("{Language}", Language);
  body.replaceText("{Contact}", Contact);
  body.replaceText("{Legal1}", Legal1);
  body.replaceText("{Legal1Contact}", Legal1Contact);
  body.replaceText("{Legal2}", Legal2);
  body.replaceText("{Legal2Contact}", Legal2Contact);
  body.replaceText("{Emergency}", Emergency);
  body.replaceText("{EmergencyContact}", EmergencyContact);
  body.replaceText("{Disability}", Disability);
  body.replaceText("{Medical}", Medical);
  body.replaceText("{Support}", Support);
  body.replaceText("{Allergies}", Allergies);
  body.replaceText("{GP}", GP);
  body.replaceText("{GDPR}", GDPR);
  body.replaceText("{Voicemail}", Voicemail);
  body.replaceText("{Timestamp}", Timestamp);

  doc.saveAndClose();
}

内容的提问来源于stack exchange，提问作者Alex Thomas