Lengkap

Google Script fix

Hello,

i have this script

function NegativeAlert() {

var objSettings = {

strSheetname: 'Negativi',

strEmailA :'test@[login to view URL]',

strSubjectA : 'Margini negativi',

strBodyPrefA : '<div>Ciao,</div><div>Ecco gli articoli a marginalità bassa</div><br>',

strBodySufA : '<br><div>Buon lavoro</div>',

}

[login to view URL]();

var sh = [login to view URL]().getSheetByName([login to view URL]);

//[login to view URL]("g2:g").setFormat('%');

[login to view URL]();

var data = [login to view URL]().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 = [login to view URL] +

'<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 + '">Codice</th>' +

'<th style="' + thStyle + '">Nome</th><th style="' + thStyle + '">Margine</th>'

for (var i = 1; i < [login to view URL]; i++) {

if (data[i][0] >= 0) {

//data[i][6].setValue('%');

if (data[i][3] > 0 || data[i][6] <= '0%') {

htmlBody = htmlBody +

'<tr><td style="' + tdStyle + '">' +

data[i][1] + '</td><td style="' + tdStyle + '">' +

data[i][2] + '</td><td style="' + tdStyle + '">' +

data[i][6] + '%' + '</td><td style="' + tdStyle + '">' + '</td></tr>'

}

}

}

htmlBody = htmlBody + '</table>' + [login to view URL]

[login to view URL]([login to view URL], [login to view URL], [login to view URL], {

htmlBody : htmlBody,

});

//[login to view URL](htmlBody);

}

That send this data [login to view URL] to email, the goal is

. Send only row where Margine < = 10%

What i did in the code doesnt' working as expected, i nedd a fix

Kemahiran: Google Sheets, Javascript, Enjin App Google

Lihat lagi: ie6 css script fix, detection script fix flash player, joomla google script, google chrome fix bugs, script fix pages, translatephp google script, will google chrome fix gif, google script result count, script fix companies, opencart 2.3 extension compatibility fix, 2-3-4 tree vs red black tree, convert 2-3-4 tree to red black java, 1+2+3+4+5 to 100 answer, google script hello world, magento 2.3 upgrade script, google api php client 2.2 3

Tentang Majikan:
( 191 ulasan ) Villanova Mondovì, Italy

ID Projek: #23857571

Dianugerahkan kepada:

abdullahahmeda

Greetings I have read your job description that your code is not working properly. I am a fullstack developer specialist in js and I can fix this issue. I will add "if" block to control when to send email (when Margine Lagi

€19 EUR dalam sehari
(1 Ulasan)
0.0

2 pekerja bebas membida secara purata €25 untuk pekerjaan ini

writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Lagi

€30 EUR dalam sehari
(1 Ulasan)
0.4