I found this script on youtube CREATE - Membuat CRUD dengan Database Google Spreadsheet di Kodular/ MIT Appinventor #Part1 - YouTube
function doGet(e) {
return ceksheet(e);
}
function doPost(e) {
return ceksheet(e);
}
function ceksheet(e){
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName(e.parameter.SH);
//CREATE
if (e.parameter.func == “Create”) {
var nis = e.parameter.NIS;
var nama = e.parameter.NAMA;
var alamat = e.parameter.ALAMAT;
var data=false;
var lr= sh.getLastRow();
for(var i=1;i<=lr;i++){
var data_nis = sh.getRange(i, 1).getValue();
if(data_nis==nis){
data=true;
}
}
if (data){
var result= “ID Sudah ada”;
}else{
var rowData = sh.appendRow([nis,nama,alamat]);
var result=“Berhasil Input”;
}
return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.TEXT);
}
//Read
if (e.parameter.func == “Read”) {
var rg=sh.getDataRange().getValues();
var data=“”;
for(var row=1;row<rg.length;++row){
data +=rg[row].join(‘,’)+‘\n’;
}
return ContentService.createTextOutput(data).setMimeType(ContentService.MimeType.TEXT);
}
}
what I want to ask is how to make the data display from the spreadsheet on //Read be descending?
