Update Google Apps Script Code on Google Sheet

I need a minor update in my Google apps script code. I wrote the original code and can do it but am extremely busy. Should only take 15 minutes.

Current Code looks like:

function myFunction() {

//1Yec2Y3FTsJGl1-y4GmTV-27TzBd4xOhx (alternate test folder with limited files is 11FitAFQ5v-2COHI_TkF0SgJaHC9LxYx7)

//[login to view URL]

var folder=[login to view URL]("11FitAFQ5v-2COHI_TkF0SgJaHC9LxYx7")

var filesIterator= [login to view URL]();

var file;

var fileType;

var ssID;

var combinedData=[];

var data;

while([login to view URL]()){

file= [login to view URL]();

fileType= [login to view URL]();

if(fileType==="application/[login to view URL]"){

ssID=[login to view URL]();

data=getDataFromSpreadsheet(ssID);

data=[login to view URL](function(r){return [login to view URL]([[login to view URL]()]);}); //adds the filename as new column

data=[login to view URL](function(r){return [login to view URL]([getDataFromSpreadsheet(ssID)]);}); //adds the invoice total again as a new column

combinedData= [login to view URL](data);

} //if ends here

} //while loop ends here

var ws=[login to view URL]().getSheetByName("combined");

[login to view URL]("A2:G").clearContent();

[login to view URL](2, 1, [login to view URL], combinedData[0].length).setValues(combinedData);

}

function getDataFromSpreadsheet(ssID){

var ss= [login to view URL](ssID);

var ws = [login to view URL]("Invoice");

var data= [[login to view URL]("Q44").getValues(),[login to view URL]("Q47").getValues()]; //When you have " var data= [[login to view URL]("Q44").getValues(),[login to view URL]("Q47").getValues()]" in this line, it adds the invoice balance as a new row, figure out how to make it a new column instead. When you have " var data= [[login to view URL]("Q44").getValues()]" then it just returns one row and one value (either the balance or the total. You should create a new tab, then run a function with one piece of data (Ex: the total) then put the blance on another tab, then join them together. Either that OR just apply some conditional formatting to rows where the total and balance rows DONT match. The goal is to batch import to pipedrive so the first option is better)

return data;

}

Just need to make a few tweaks so that the output data is formatted differently. Will send the google sheets over upon acceptance.

Google App Engine

Ταυτότητα Εργασίας: #31987306

Σχετικά με την εργασία