for loop on Text + number on Apps Script

Question

https://i.sstatic.net/9CRFd.png I'm trying to use loop to set value "Hello1" in cell F11, "Hello2" in cell F12, "Hello3" in cell F13, then continue until "Hello10". The Cell F10 already has the word "Hello" on it. So far I only managed to show the value "1" on everything

.

Here's how I wrote the script:

  function Exercise2() {

  var exercise2 = SpreadsheetApp;
  var activeSheet = exercise2.getActiveSpreadsheet().getActiveSheet();
  var helloCell = activeSheet.getRange(10, 6).getValue();

  activeSheet.getRange(1, 1).moveTo(activeSheet.getRange("F10"));

  for(var x=10;x<21;x++){
  var helloCell = activeSheet.getRange(x, 6).getValue();
  helloCell = helloCell+1;
  activeSheet.getRange(x, 6).setValue(helloCell);
    }

  }

Martin · Accepted Answer · 2021-07-06 12:52:22Z

1

The for loop can be greatly simplified to somthing like this:

for(var x = 1; x < 11; x++) {
    activeSheet.getRange(x + 9, 6).setValue("Hello" + x);
}

This will:

Create a loop that runs from 1 to 11 stored in x.
Set the value of the cell at x + 9 to the value "Hello" & x.

edited Jul 6, 2021 at 12:52

answered Jul 6, 2021 at 12:32

Martin

16.5k1 gold badge33 silver badges51 bronze badges

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

2 Comments

t-max Over a year ago

Thanks for taking the time to look into it however, by following this I only got zero on everything. Basically, what I'm trying to get at is this i.sstatic.net/9CRFd.png.

Martin Over a year ago

I think I made a mistake in using the VBA-style syntax for string concatenation which is why you are getting 0 instead of text. I'll edit the question, but "Hello " & x should be "Hello" + x (note the + instead of &).

Collectives™ on Stack Overflow

for loop on Text + number on Apps Script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related