仍然在學習曲線上。我正在嘗試從 google 表格中獲取數據并發送數據 Gmail 應用程序，但出現 Missing variable name 錯誤。這是我在過去 2 小時內嘗試過的，我將感謝幫助構建代碼以使其正常工作。function emailTheLastRow(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var range = sheet.getRange("AO2:AO"+sheet.getLastRow()).getValues(); var searchString = "1"; for (var i = 0; i<range.length; i++) { if(range[i][0] == searchString) { var lastRow = sheet.getRange(2+i,1,1,41).getValues(); var data = { 'email':lastRow[0][1], 'project':lastRow[0][2], 'client':lastRow[0][3], 'sdate':lastRow[0][4], 'edate':lastRow[0][5], 'loe':lastRow[0][7], }; GmailApp.sendEmail("[email protected]", "Project", "A new project has been created with the following details: " + data()); } }}
嘗試將工作表行數據發送到 GmailApp 時缺少變量名稱；Javascript/谷歌應用腳??本
MM們
2022-01-13 19:24:01
