📖 首次設定教學
- 建立一個新的 Google 試算表
- 在第一列輸入標題:uid, id, 日期, 客戶, 方式, 本卦, 變卦, 變爻, 備註, 時間, 本卦號, 變卦號
- 擴充功能 → Apps Script → 貼上以下程式碼
- 按「部署」→「新增部署」→ 類型選「網頁應用程式」
- 存取權限選「所有人」→ 部署
- 複製產生的網址貼到下方欄位
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
var uid = data.uid || 'default';
if (data.action === 'delete') {
var rows = sheet.getDataRange().getValues();
for (var i = rows.length - 1; i >= 1; i--) {
if (rows[i][0] === uid && rows[i][1] === data.recordId) {
sheet.deleteRow(i + 1);
}
}
return ContentService.createTextOutput(
JSON.stringify({status:'ok'})
).setMimeType(ContentService.MimeType.JSON);
}
if (data.rows) {
data.rows.forEach(function(row) {
sheet.appendRow([uid, row.id, row.date, row.client, row.method, row.mainHex, row.changedHex, row.changingYao, row.memo, row.timestamp, row.mainHexNum || '', row.changedHexNum || '']);
});
}
return ContentService.createTextOutput(
JSON.stringify({status:'ok', count: data.rows ? data.rows.length : 0})
).setMimeType(ContentService.MimeType.JSON);
}
function doGet(e) {
var uid = e.parameter.uid || 'default';
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var rows = sheet.getDataRange().getValues();
var result = [];
for (var i = 1; i < rows.length; i++) {
if (rows[i][0] === uid) {
result.push({
id: rows[i][1], date: rows[i][2], client: rows[i][3],
method: rows[i][4], mainHex: rows[i][5], changedHex: rows[i][6],
changingYao: rows[i][7], memo: rows[i][8], timestamp: rows[i][9],
mainHexNum: Number(rows[i][10]) || null,
changedHexNum: Number(rows[i][11]) || null
});
}
}
return ContentService.createTextOutput(
JSON.stringify({status:'ok', records: result})
).setMimeType(ContentService.MimeType.JSON);
}