Bank Soalan Editor
Google Sheets Web App Integration
Hantar rekod pelajar ke Google Sheets secara automatik.
// SALIN KOD INI KE GOOGLE APPS SCRIPT ANDA:
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
if (data.action === "appendRecords") {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var records = data.records;
if (sheet.getLastRow() === 0) {
sheet.appendRow(["Timestamp", "Name", "Matric", "Email", "Cohort", "Score", "Accuracy", "RoomReached", "TimeSpentSec", "TabSwitchCount"]);
}
for (var i = 0; i < records.length; i++) {
var r = records[i];
sheet.appendRow([r.Timestamp, r.Name, r.Matric, r.Email, r.Cohort, r.Score, r.Accuracy, r.RoomReached, r.TimeSpentSec, r.TabSwitchCount]);
}
return ContentService.createTextOutput(JSON.stringify({ok: true, appended: records.length})).setMimeType(ContentService.MimeType.JSON);
}
} catch (err) {
return ContentService.createTextOutput(JSON.stringify({ok: false, error: err.toString()})).setMimeType(ContentService.MimeType.JSON);
}
}