function doPost(e) {
try {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');
if (!sheet) {
sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
}
// Data dihantar dalam bentuk JSON
var data = JSON.parse(e.postData.contents);
var timestamp = new Date();
var module = data.module || '';
var name = data.name || '';
var email = data.email || '';
var score = data.score || '';
var percent = data.percent || '';
var status = data.status || '';
var wrong = data.wrongItems || '';
var rawAns = data.rawAnswers || '';
var ua = data.userAgent || '';
sheet.appendRow([
timestamp,
module,
name,
email,
score,
percent,
status,
wrong,
rawAns,
ua
]);
return ContentService
.createTextOutput(JSON.stringify({success: true}))
.setMimeType(ContentService.MimeType.JSON);
} catch (err) {
return ContentService
.createTextOutput(JSON.stringify({success: false, error: err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}