Issue using forEach on google script

Question

Hi I have a syntax error on a GoogleScript. this is my first script ever so I'm not really sure why is not working. The idea is to pick up information from a google sheet and create a label from a doc template and storage it in a folder

function readSheet() {

const labelFolder = DriveApp.getFolderById("1NTnJgjCewcFcrtMsl5DtRgrvFUNCdsvt"); 

const docFile = DriveApp.getFileById("1pRy9BLDuDka7-9PKnHGgO1AtgpoWIY45t7ypVhXXM8I");

const sheet = SpreadsheetApp.gettActiveSpreadSheet().getSheetByName("test");

const data = sheet.getRange(2,1,sheet.getLastRow()-1,10).getValues();

  data.forEach(row => {

      shippinglabels(row [5],row [6],row [8],docFile,labelFolder);
});

}

function shippinglabels(user,address,package,docFile,labelFolder) {
   
  
  const labelFile = docFile.makeCopy(labelFolder);

  const tempDocFile = DocumentApp.openById(labelFile.getId());

  const body = tempDocFile.getBody();

  body.replaceText("{user}", user);

  body.replaceText("{address}", address);

  body.replaceText("{package}", package);

  tempDocFile.setName(user);

  tempDocFile.saveAndClose(); 
  

     
    }

Thanks

How do I ask a good question?

Andreas
– Andreas

2020-07-17 07:22:14 +00:00
Commented Jul 17, 2020 at 7:22 — Andreas
– Andreas, Commented Jul 17, 2020 at 7:22
Where is the syntax error?

VLAZ
– VLAZ

2020-07-17 07:22:48 +00:00
Commented Jul 17, 2020 at 7:22 — VLAZ
– VLAZ, Commented Jul 17, 2020 at 7:22
Are you using v8 runtime? It's defaulted to stable

Thum Choon Tat
– Thum Choon Tat

2020-07-17 07:37:42 +00:00
Commented Jul 17, 2020 at 7:37 — Thum Choon Tat
– Thum Choon Tat, Commented Jul 17, 2020 at 7:37

Tanaike · Accepted Answer · 2020-07-17 07:38:25Z

1

Please modify as follows and test it again.

From:

const sheet = SpreadsheetApp.gettActiveSpreadSheet().getSheetByName("test");

To:

const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("test");

In this case, gettActiveSpreadSheet() is getActiveSpreadsheet().
I think that after above modification was reflected to your script, when the folder ID, Google Document ID and the values from Google Spreadsheet are correct, no error occurs. When other error occurred, can you provide the detail information about it? I would like to confirm it.

Reference:

getActiveSpreadsheet()

answered Jul 17, 2020 at 7:38

Tanaike

203k12 gold badges126 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aloe Francisco Over a year ago

Thanks for the comment, modify what you said but still the same error as before. When I try to save the script , doesn't save and highlight "data.forEach(row => {" and said as error Syntax error. (line 14, file "Test"). That is the line for the forEach.

Tanaike Over a year ago

@Aloe Francisco Thank you for replying. In your case, in addition of above modification, I think that you doesn't enable V8 runtime as Thum Choon Tat have already said. So how about enabling V8 runtime at the script editor and test it again?

Aloe Francisco · Accepted Answer · 2020-07-17 10:39:46Z

1

I change the forEach form this:

data.forEach(row => {
    
          shippinglabels(row [5],row [6],row [8],docFile,labelFolder);
    });

To this:

    data.forEach(function(row) {
      shippinglabels(row [5],row [6],row [8],docFile,labelFolder);
});

and did the job.

Thanks for the help

answered Jul 17, 2020 at 10:39

Aloe Francisco

112 bronze badges

Collectives™ on Stack Overflow

Issue using forEach on google script

2 Answers 2

From:

To:

Reference:

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

From:

To:

Reference:

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related