var timestamp = e.values[0];
var recipientName = e.values[1];
var firstLineOfAddress = e.values [2];
var secondLineOfAddress = e.values[3];
var thirdLineOfAddress = e.values[4];
var postcode = e.values [5];
var recipientEmail = e.values[6];
var todaysDate = e.values[7];
var invoicenNumber = e.values[8];
var dueDate = e.values[9];
var item1Description = e.values [10];
var item1Qty = e.values [11];
var item1UnitPrice = e.values [12];
var item1Amount = e.values[13];
var templateFile = DriveApp.getFileById("1VjJI3VUNSJDQuv8NsgSfSugIfi3c_ev4cGpbk5_LQ3I");
var templateFolder = DriveApp.getFolderById("1MsmTVhosVz0S4Nquz2qMr-SZtYZYyV9S");
var copy = templateFile.makeCopy(recipientName, templateFolder);
var doc = DocumentApp.openById(copy.getId());
var body = doc.getBody();
body.replaceText("{{RECIPIENT NAME}}", recipientName);
body.replaceText("{{FIRST LINE OF ADDRESS}}", firstLineOfAddress);
body.replaceText("{{SECOND LINE OF ADDRESS}}", secondLineOfAddress);
body.replaceText("{{THIRD LINE OF ADDRESS}}", thirdLineOfAddress);
body.replaceText("{{Postcode}}",postcode);
body.replaceText("{{EMAIL}}",recipientEmail);
body.replaceText("{{DATE}}",todaysDate);
body.replaceText("{{REF}}", invoicenNumber);
body.replaceText("{{DUEDATE}}", dueDate);
body.replaceText("{{desc1}}", item1Description);
body.replaceText("{{qty1}}", item1Qty);
body.replaceText("{{unitprice1}}", item1UnitPrice);
body.replaceText("{{amount1}}", item1Amount)
doc.saveAndClose();
}
我還在學習 googleappscript/java，所以很抱歉聽起來很愚蠢。我使用表格來生成發票，但是如果留空，我希望能夠從它生成的檔案中清除 e.values[10] 的變數。
因此，如果 e.value 為空白，則 body.replace 文本應將其替換為空。如果填寫了 e.value，則 body.replace 文本應填寫適當的回應。
任何想法我怎么能做到這一點？
uj5u.com熱心網友回復：
表單中的每個提交始終包含時間戳。因此，當用戶將問題留空時，它的值e.values就是空的。它會產生這樣的東西：[3/4/2022 5:50:53, , , , , , , , , , , , ].
空值起作用body.replaceText()并且不會產生錯誤。因此，您無需更改代碼中的任何內容。
如果您的 中有null值e.values，可以通過編輯 的內容來完成，只需在替換字串旁邊e.values附加一個。||''
您的代碼應如下所示：
body.replaceText("{{RECIPIENT NAME}}", recipientName||'');
body.replaceText("{{FIRST LINE OF ADDRESS}}", firstLineOfAddress||'');
body.replaceText("{{SECOND LINE OF ADDRESS}}", secondLineOfAddress||'');
body.replaceText("{{THIRD LINE OF ADDRESS}}", thirdLineOfAddress||'');
body.replaceText("{{Postcode}}",postcode||'');
body.replaceText("{{EMAIL}}",recipientEmail||'');
body.replaceText("{{DATE}}",todaysDate||'');
body.replaceText("{{REF}}", invoicenNumber||'');
body.replaceText("{{DUEDATE}}", dueDate||'');
body.replaceText("{{desc1}}", item1Description||'');
body.replaceText("{{qty1}}", item1Qty||'');
body.replaceText("{{unitprice1}}", item1UnitPrice||'');
body.replaceText("{{amount1}}", item1Amount||'')
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/440009.html