我不确定发生了什么。我的脚本工作正常,但现在我得到了一个无效的参数:var rangeElement = copyBody.findText(email);
function form(e) {
var ss = Spreadsheetapp.openById('xxxxxx');
var email = e.values[1];
var docTemplate = 'yyyyyyyy';
var newEstimate = 'firstName' + 'lastName';
var copyId = DriveApp.getFileById(docTemplate).makeCopy(newEstimate).getId(); // Get document template,copy it,and save the Doc’s id
var copyDoc = DocumentApp.openById(copyId); // Open the temporary document
var copyBody = copyDoc.getBody(); // Get the document’s body section
copyBody.replaceText('<Email>',email);
var mailto = 'mailto:' + email;
var rangeElement = copyBody.findText(email);
var startOffset = rangeElement.getStartOffset();
var endOffset = rangeElement.getEndOffsetInclusive();
var text = rangeElement.getElement().asText();
if (rangeElement.isPartial()) { text.setLinkUrl(startOffset,endOffset,mailto); } else { text.setLinkUrl(mailto); }
)
有什么想法吗?