我一直在研究這個應用程式腳本，試圖自動化來自 Google 作業表的資料以在 Google 日歷上創建事件。我嘗試將引號從單引號更改為雙引號并回傳。我一遍又一遍地檢查我的（）。我看不到我所做的事情給了我語法錯誤。如果你能看到，請告訴我。這讓我發瘋了。
function AutomateCalendarEvent() {
let sheet = SpreadsheetApp.getActiveSheet();
let pqCalendar = CalendarApp.getCalendarById("zyxwvutsrqp");
let reservation = sheet.getRange("C2:E1105").getValues();
reservation.splice(0, 1);
let rows = sheet.getDataRange().getValues();
rows.forEach(function (row, index) {
if (index === 0) return;
if (row[C3]) return;
pqCalendar.createAllDayEvent("Last Name"C2:C, "Arrival Date"D2:D, "Departure Date"E2:E);
})
}
uj5u.com熱心網友回復：
假設您的資料如下
嘗試（為防止重復，此處事件 ID 存盤在 AI fr instance 列中）
function AutomateCalendarEvent() {
let sheet = SpreadsheetApp.getActiveSheet();
let swCalendar = CalendarApp.getCalendarById("***********@gmail.com");
let rows = sheet.getRange(1, 1, sheet.getLastRow(), sheet.getLastColumn()).getValues();
rows.filter(row => row[2] != '').forEach(function (row, index) {
if (index === 0) return;
if (row[34] == '') { // AI
try {
sheet.getRange('AI' ( index 1)).setValue(swCalendar.createAllDayEvent(row[2], row[3], row[4]).getId())
} catch (e) { console.log(e) }
}
})
}
參考
uj5u.com熱心網友回復：
看看我的評論
function AutomateCalendarEvent() {
let sheet = SpreadsheetApp.getActiveSheet();
let pqCalendar = CalendarApp.getCalendarById("zyxwvutsrqp");
let reservation = sheet.getRange("C2:E1105").getValues();
reservation.splice(0, 1);
let rows = sheet.getDataRange().getValues();
rows.forEach(function (row, index) {
if (index === 0) return;
if (row[C3]) return;//C3 should be an index between 0 and 2
pqCalendar.createAllDayEvent("Last Name"C2:C, "Arrival Date"D2:D, "Departure Date"E2:E);//parameters should be a string followed by two dates
//this is not the way insert parameters into above command. Ranges do not return values
})
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/473323.html
標籤：javascript 谷歌应用脚本 谷歌表格 句法
下一篇：SpringDataElasticsearch：ExistsBy*存盤庫方法中拋出ClassCastException