AppScript Fix
Budget: €8 – €30 EUR
Hello,
I have this script that working good but i'm getting an error
function BorgoAlert() {
var objSettings = {
strSheetname: 'Borgo',
strEmailA :'test @ test.it',
strSubjectA : 'Vendite a Borgo',
strBodyPrefA : '<div>Ciao,</div><div>Ecco la situazione vendite aggiornata</div><br>',
strBodySufA : '<br><div>Buon lavoro</div>',
}
SpreadsheetApp.flush();
var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(objSettings.strSheetname);
//sh.getRange("A2:I").sort(3);
SpreadsheetApp.flush();
var data = sh.getDataRange().getValues();
var thStyle = 'vertical-align:top; border:1px #ffffff solid; background-color:#4CAF50; color:white;'
var tdStyle = 'vertical-align:top; border:1px #AAAAAA solid; '
var date = new Date();
var htmlBody = objSettings.strBodyPrefA +
'<table style="border-left: 2px #999999 solid;border-right: 2px #999999 solid; border-top: 2px #999999 solid;border-bottom: 2px #999999 solid;width: 100%; border-collapse: collapse;">' +
'<tr style="1px solid black;"><th style="' + thStyle + '">Data</th>' +
'<th style="' + thStyle + '">Ora</th><th style="' + thStyle + '">Sku</th><th style="' + thStyle + '">Nome</th><th style="' + thStyle + '">Qty</th><th style="' + thStyle + '">Price</th><th style="' + thStyle + '">Tot</th>'
for (var i = 1; i < data.length; i++) {
if (data[i][0] >= 0) {
{
htmlBody = htmlBody +
'<tr><td style="' + tdStyle + '">' +
data[i][0] + '</td><td style="' + tdStyle + '">' +
data[i][1] + '</td><td style="' + tdStyle + '">' +
data[i][2] + '</td><td style="' + tdStyle + '">' +
data[i][3] + '</td><td style="' + tdStyle + '">' +
data[i][5] + '</td><td style="' + tdStyle + '">' +
data[i][6] + '</td><td style="' + tdStyle + '">' +
data[i][8] + '</td><td style="' + tdStyle + '">' + '</td></tr>'
}
}
}
htmlBody = htmlBody + '</table>' + objSettings.strBodySufA
GmailApp.sendEmail(objSettings.strEmailA, objSettings.strSubjectA, objSettings.strSubjectA, {
htmlBody : htmlBody,
});
//Logger.log(htmlBody);
}
The goal it's to fix the format date (and hour) indicated in the mail that i'm getting, this is what i'm getting
Data Ora Sku Nome Qty Price Tot
Tue Oct 25 2022 00:00:00 GMT+0200 (Central European Summer Time) Sat Dec 30 1899 08:45:21 GMT+0009 (Central European Standard Time) 68 Semola Rimacinata Di Grano Duro 5kg 1 11.85
I need a simple date like this
dd/mm/yyyy and hh:mm:ss
I have this script that working good but i'm getting an error
function BorgoAlert() {
var objSettings = {
strSheetname: 'Borgo',
strEmailA :'test @ test.it',
strSubjectA : 'Vendite a Borgo',
strBodyPrefA : '<div>Ciao,</div><div>Ecco la situazione vendite aggiornata</div><br>',
strBodySufA : '<br><div>Buon lavoro</div>',
}
SpreadsheetApp.flush();
var sh = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(objSettings.strSheetname);
//sh.getRange("A2:I").sort(3);
SpreadsheetApp.flush();
var data = sh.getDataRange().getValues();
var thStyle = 'vertical-align:top; border:1px #ffffff solid; background-color:#4CAF50; color:white;'
var tdStyle = 'vertical-align:top; border:1px #AAAAAA solid; '
var date = new Date();
var htmlBody = objSettings.strBodyPrefA +
'<table style="border-left: 2px #999999 solid;border-right: 2px #999999 solid; border-top: 2px #999999 solid;border-bottom: 2px #999999 solid;width: 100%; border-collapse: collapse;">' +
'<tr style="1px solid black;"><th style="' + thStyle + '">Data</th>' +
'<th style="' + thStyle + '">Ora</th><th style="' + thStyle + '">Sku</th><th style="' + thStyle + '">Nome</th><th style="' + thStyle + '">Qty</th><th style="' + thStyle + '">Price</th><th style="' + thStyle + '">Tot</th>'
for (var i = 1; i < data.length; i++) {
if (data[i][0] >= 0) {
{
htmlBody = htmlBody +
'<tr><td style="' + tdStyle + '">' +
data[i][0] + '</td><td style="' + tdStyle + '">' +
data[i][1] + '</td><td style="' + tdStyle + '">' +
data[i][2] + '</td><td style="' + tdStyle + '">' +
data[i][3] + '</td><td style="' + tdStyle + '">' +
data[i][5] + '</td><td style="' + tdStyle + '">' +
data[i][6] + '</td><td style="' + tdStyle + '">' +
data[i][8] + '</td><td style="' + tdStyle + '">' + '</td></tr>'
}
}
}
htmlBody = htmlBody + '</table>' + objSettings.strBodySufA
GmailApp.sendEmail(objSettings.strEmailA, objSettings.strSubjectA, objSettings.strSubjectA, {
htmlBody : htmlBody,
});
//Logger.log(htmlBody);
}
The goal it's to fix the format date (and hour) indicated in the mail that i'm getting, this is what i'm getting
Data Ora Sku Nome Qty Price Tot
Tue Oct 25 2022 00:00:00 GMT+0200 (Central European Summer Time) Sat Dec 30 1899 08:45:21 GMT+0009 (Central European Standard Time) 68 Semola Rimacinata Di Grano Duro 5kg 1 11.85
I need a simple date like this
dd/mm/yyyy and hh:mm:ss