Help with function

[Gustavo]

Hello,

I'd need some help with this function as it is not working and I cannot find the error...

This function was supposed to bring data from a specific row of Google Sheet to a webpage. The problem is that it is bringing random and unknown information.

Thank you,

var url = "xxxxxxxxxx"

var nomeguia = "Dados";

var linhainicial = 2;

var colunainicial = 1;

var linhacabecalho = 1;

// coluna array

var colunaID = 0;

function PesquisarDados(criteriopesquisa){

var planilha = SpreadsheetApp.openByUrl(url);

var guiadados = planilha.getSheetByName(nomeguia);

var dados = guiadados.getRange(linhainicial, colunainicial, guiadados.getLastRow()-linhacabecalho,22).getValues();

for(var linha = 0; linha<dados.length; linha++){

if(dados[linha][colunaID] == criteriopesquisa){

var Carregar={};

Carregar.Campo1 = dados[linha][colunaID]

Carregar.Campo2 = dados[linha][1];

Carregar.Campo3 = dados[linha][2];

Carregar.Campo4 = dados[linha][3];

Carregar.Campo5 = dados[linha][4];

Carregar.Campo6 = dados[linha][5];

Carregar.Campo7 = dados[linha][6];

Carregar.Campo8 = dados[linha][7];

Carregar.Campo9 = dados[linha][8];

Carregar.Campo10 = dados[linha][9];

Carregar.Campo11 = dados[linha][10];

Carregar.Campo12 = dados[linha][11];

Carregar.Campo13 = dados[linha][12];

Carregar.Campo14 = dados[linha][13];

Carregar.Campo15 = dados[linha][14];

Carregar.Campo16 = dados[linha][15];

Carregar.Campo17 = dados[linha][16];

Carregar.Campo18 = dados[linha][17];

Carregar.Campo19 = dados[linha][18];

Carregar.Campo20 = dados[linha][19];

Carregar.Campo21 = dados[linha][20];

Carregar.Campo22 = dados[linha][21];

return ([Carregar.Campo1, Carregar.Campo2, Carregar.Campo3, Carregar.Campo4, Carregar.Campo5, Carregar.Campo6, Carregar.Campo7, Carregar.Campo8, Carregar.Campo9, Carregar.Campo10, Carregar.Campo11, Carregar.Campo12,Carregar.Campo13, Carregar.Campo14, Carregar.Campo15, Carregar.Campo16, Carregar.Campo17, Carregar.Campo18, Carregar.Campo19, Carregar.Campo20, Carregar.Campo21, Carregar.Campo22])

}

}

return "Não encontrado!";

}

[Alan Wells]

Are you familiar with Apps Script troubleshooting capabilities? See:

https://developers.google.com/apps-script/guides/support/troubleshooting

Without seeing what the code is actually generating for variable values it's hard to know what the problem is.

[Andrew Roberts]

The return of the Carregar object, as an array, needs to be outside the for loop. And regardless, would it not be easier to just return dados?

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/005986f7-a8ac-4463-8519-78e59ddb4896n%40googlegroups.com.