我試圖獲得鎖 5 秒，我嘗試同時運行它，它會拋出已知錯誤：
Exception: Service invoked too many times for one day: email.
這就是我試圖得到它的方式：
function sendEmail() {
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getActiveSheet();
if (sheet.getName() != 'Todays Tests V2') {
return;
}
const testSheet = ss.getSheetByName("Todays Tests V2");
const row = sheet.getActiveCell().getRow();
const col = sheet.getActiveCell().getColumn();
const sendResults = testSheet.getRange(row, 15, 1, 1).getValue();
if (ss.getActiveSheet().getSheetName() == testSheet.getSheetName() &&
row > 5 &&
col == 15 &&
sendResults == true) {
const lock = LockService.getScriptLock();
try {
lock.tryLock(5000); // wait 05 seconds for others' use of the code section and lock to stop and then proceed
} catch (e) {
Logger.log('Could not obtain lock after 05 seconds.');
return HtmlService.createHtmlOutput("<b> Server Busy. Please try after some time <p>");
}
const email = testSheet.getRange(row, 5).getValue();
const name = testSheet.getRange(row, 3).getValue() ' ' testSheet.getRange(row, 4).getValue();
const testNo = testSheet.getRange(row, 2).getValue();
GmailApp.sendEmail(email, "subject", name " XXXXXX.", { name: 'Custom Name' });
lock.releaseLock();
}
}
uj5u.com熱心網友回復：
嘗試使用其他帳戶或等待 1 天。
以上是因為報錯資訊的意思是你當前使用的賬號已經超出了參考的配額。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/434952.html