var SS = SpreadsheetApp.
openById('MASUKKAN SHEET ID');
var hours = 0
var str = "";
function doPost(e) {
var parsedData;
var result = {};
try {
parsedData = [Link]([Link]);
}
catch(f){
return [Link]("Error in parsing request body: " +
[Link]);
}
if (parsedData !== undefined){
var flag = [Link];
if (flag === undefined){
flag = 0;
}
var sheet = [Link](parsedData.sheet_name);
var dataArr = [Link](",");
//var date_now = [Link](new Date(), "CST", "yyyy/MM/dd");
//var time_now = [Link](new Date(), "CST", "hh:mm:ss a");
var Curr_Date = new Date(new Date().setHours(new Date().getHours() + hours));
var Curr_Time = [Link](Curr_Date, "Asia/Jakarta", 'HH:mm:ss');
var nama = dataArr [0];
var nim = dataArr [1];
var fakultas = dataArr [2];
var prodi = dataArr [3];
var jenis_kelamin = dataArr [4];
switch ([Link]) {
case "insert_row":
var nextRow = [Link]() + 1;
[Link]("A" + nextRow).setValue(Curr_Date);
[Link]("B" + nextRow).setValue(Curr_Time);
[Link]("C" + nextRow).setValue(nama);
[Link]("D" + nextRow).setValue(nim);
[Link]("E" + nextRow).setValue(fakultas);
[Link]("F" + nextRow).setValue(prodi);
[Link]("G" + nextRow).setValue(jenis_kelamin);
str = "Success";
[Link]();
break;
case "append_row":
var publish_array = new Array();
publish_array [0] = nama;
publish_array [1] = nim;
publish_array [2] = fakultas;
publish_array [3] = prodi;
publish_array [4] = jenis_kelamin;
[Link](publish_array);
str = "Success";
[Link]();
break;
return [Link](str);
} // endif (parsedData !== undefined)
else {
return [Link]("Error! Request body empty or in
incorrect format.");
}
}
