Test get data app script
Describe your app:
my application wants to display attendance log data from google spreadsheet and has created the app script.
Screenshots:
screenshots code block
// screnshoots data sheet
kode getlog in app script
// ---------- Ambil Log Kehadiran (tanpa filter RT) ----------
else if (mode === “getlog”) {
var data = logSheet.getDataRange().getValues();
var hasil = “”;
for (var i = 1; i < data.length; i++) {
if (data[i].length >= 4) {
var nama = data[i][3];
var tanggal = Utilities.formatDate(new Date(data[i][1]), timezone, “yyyy-MM-dd”);
var waktu = Utilities.formatDate(new Date(data[i][2]), timezone, “HH:mm:ss”);
hasil += nama + “;” + tanggal + “;” + waktu + “;\n”; // gunakan \n agar tampil baris-baris
}
}
return ContentService
.createTextOutput(hasil)
.setMimeType(ContentService.MimeType.TEXT);
}
// ---------- Mode tidak dikenali ----------
return ContentService.createTextOutput(“error: Mode tidak dikenali.”);
}