0
Total
0
Waiting
0
In Process
0
Done
⏳ Waiting 0
⚙️ In Process 0
✅ Done 0
Waiting Orders
| Order ID | Client | Reseller | Model | Service | Tool ID | Status | Date | Actions |
|---|
| Order ID | Client | Reseller | Model | Service | Tool ID | Status | Date | Actions |
|---|
function doPost(e){
var ss=SpreadsheetApp.getActiveSpreadsheet();
var sh=ss.getSheetByName("Orders")||ss.insertSheet("Orders");
if(sh.getLastRow()===0){
sh.appendRow(["Order ID","Client","WhatsApp","Reseller",
"Reseller Code","Model","Service","Tool ID","Status","Date","Notes"]);
}
var d=JSON.parse(e.postData.contents);
d.orders.forEach(function(o){
var found=false,lr=sh.getLastRow();
for(var i=2;i<=lr;i++){
if(sh.getRange(i,1).getValue()===o.id){
sh.getRange(i,1,1,11).setValues([[o.id,o.client,o.wa,
o.reseller,o.resellerCode,o.model,o.service,
o.tool,o.status,o.date,o.notes]]);
found=true;break;
}
}
if(!found)sh.appendRow([o.id,o.client,o.wa,o.reseller,
o.resellerCode,o.model,o.service,o.tool,o.status,o.date,o.notes]);
});
return ContentService.createTextOutput(
JSON.stringify({ok:true})).setMimeType(ContentService.MimeType.JSON);
}