function doPost(e) {
try {
var d = JSON.parse(e.postData.contents);
var ss = SpreadsheetApp.openById(d.sheetId);
var sh = ss.getSheetByName('Expenses')
|| ss.insertSheet('Expenses');
if (sh.getLastRow() === 0) {
sh.appendRow(['Date','Time','Vendor','Location',
'Type','Product','Qty','Unit','UnitPrice',
'Gross','Discount','TotalPaid','Tax','GST%',
'Payment','Currency','Vehicle','Duration',
'SessionRef','TxnID','Notes','File']);
sh.getRange(1,1,1,22)
.setFontWeight('bold')
.setBackground('#e8f0fe');
}
d.rows.forEach(function(r){
sh.appendRow([r.date,r.time,r.vendor,
r.location,r.type,r.product,
r.quantity,r.quantityUnit,r.unitPrice,
r.grossAmount,r.discount,r.totalAmount,
r.taxAmount,r.taxPercent,r.paymentMethod,
r.currency,r.vehicleNo,r.sessionDuration,
r.sessionRef,r.transactionId,r.notes,
r.filename]);
});
return ContentService
.createTextOutput(JSON.stringify(
{success:true,added:d.rows.length}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService
.createTextOutput(JSON.stringify(
{success:false,error:err.message}))
.setMimeType(ContentService.MimeType.JSON);
}
}
Comments
Post a Comment