Introducing a fresh counter variable inside a for loop

Question

Introducing a fresh counter variable inside a for loop

I'm currently working on a project with google-apps-script. My goal is to copy a row multiple times based on the number specified in a certain cell within a spreadsheet. For example, if B2 contains the number 6, I want to duplicate that row 6 times. I've been successful in replicating the row, but I'm encountering issues when trying to manipulate the data further.

Here's the initial data:

Col1   Col2       Col3
Name   6          07/14/2019

This is the desired outcome:

Col1   Col2       Col3
Name   Count 1    07/14/2019
Name   Count 2    07/14/2019
Name   Count 3    07/14/2019
Name   Count 4    07/14/2019
Name   Count 5    07/14/2019
Name   Count 6    07/14/2019

However, this is what I keep getting:

Col1   Col2       Col3
Name   Count 6    07/14/2019
Name   Count 6    07/14/2019
Name   Count 6    07/14/2019
Name   Count 6    07/14/2019
Name   Count 6    07/14/2019
Name   Count 6    07/14/2019

Below is my current code snippet:

function sample(data){

  var returnData = [];

  var col1 = data[0];
  var col2 = data[1];
  var col3 = new Date(data[2]);
  var count = 0;

  if (col2 > 1){
    var tempData = [];
    for(var i = 0; i < col2; i++){
      tempData[0] = col1;
      tempData[1] = "Count" + count;
      tempData[2] = col3;
      
      returnData.push(tempData);
    }
    count++;
  }
  return returnData;
};

I've experimented with moving the count variable around within the code, but I continue to encounter the same issue where only the last count value is being implemented. Can you point out where I may be going wrong?

javascript typescript google-apps-script

Answer 1

Answer №1

To optimize the code, consider declaring var tempData = []; inside the for loop.

Take a look at the modified code below:

// Revised code snippet
function sample(data){

  var returnData = [];

  var col1 = data[0];
  var col2 = data[1];
  var col3 = new Date(data[2]);

  if (col2 > 1){
    
    for(var i = 1; i <= col2; i++){
      var tempData = [];
      tempData[0] = col1;
      tempData[1] = "Count " + i;
      tempData[2] = col3;
      
      returnData.push(tempData); 
    }
  }
  return returnData; 
};

function test()
{
  var returnData = sample(['Name',6,'07/14/2019']);
  for(var i = 0; i < returnData.length; i++){
    console.log(returnData[i][0] + ' ' + returnData[i][1] + ' ' + returnData[i][2])
  }
}

test();

Answer 2

To optimize the code, consider declaring var tempData = []; inside the for loop.

Take a look at the modified code below:

// Revised code snippet
function sample(data){

  var returnData = [];

  var col1 = data[0];
  var col2 = data[1];
  var col3 = new Date(data[2]);

  if (col2 > 1){
    
    for(var i = 1; i <= col2; i++){
      var tempData = [];
      tempData[0] = col1;
      tempData[1] = "Count " + i;
      tempData[2] = col3;
      
      returnData.push(tempData); 
    }
  }
  return returnData; 
};

function test()
{
  var returnData = sample(['Name',6,'07/14/2019']);
  for(var i = 0; i < returnData.length; i++){
    console.log(returnData[i][0] + ' ' + returnData[i][1] + ' ' + returnData[i][2])
  }
}

test();

Answer 3

Answer №2

Placing count++ within the for loop can help resolve the problem

Answer 4

Placing count++ within the for loop can help resolve the problem

Answer 5

Answer №3

Greetings my friend, if you already possess the variable i, what purpose does the variable count serve?


function processData(input){

  var outputData = [];

  var column1 = input[0];
  var column2 = input[1];
  var column3 = new Date(input[2]);
 

  if (column2 > 1){
    var tempData = [];
    for(let i = 1; i <= column2; i++){
      tempData[0] = column1;
      tempData[1] = "Count" + i;
      tempData[2] = column3;
      
      outputData.push(tempData);
    }
  }
  return outputData;
};

Answer 6

Greetings my friend, if you already possess the variable i, what purpose does the variable count serve?


function processData(input){

  var outputData = [];

  var column1 = input[0];
  var column2 = input[1];
  var column3 = new Date(input[2]);
 

  if (column2 > 1){
    var tempData = [];
    for(let i = 1; i <= column2; i++){
      tempData[0] = column1;
      tempData[1] = "Count" + i;
      tempData[2] = column3;
      
      outputData.push(tempData);
    }
  }
  return outputData;
};

Answer 7

Answer №4

function generateSampleData([value1, value2, value3] = []) {
  let outputData = [];

  if (value2 > 0)
    for (var index = 1; index <= value2; index++) {
      outputData.push([value1, "Count " + index, value3]);
    }

  return outputData;
};

Answer 8

function generateSampleData([value1, value2, value3] = []) {
  let outputData = [];

  if (value2 > 0)
    for (var index = 1; index <= value2; index++) {
      outputData.push([value1, "Count " + index, value3]);
    }

  return outputData;
};

Answer 9

Answer №5

The most recent correct answer came from Bharat, who provided a solution but did not post it, so I will do so here. The resolution to this particular issue involved moving the tempData[] array within the for loop and ensuring that the count++ increment statement also remained inside the for loop after pushing the tempData.

function processData(input){

  var outputData = [];

  var category = input[0];
  var quantity = input[1];
  var dateCreated = new Date(input[2]);
  

  if (quantity > 1){
    var counter = 1;
    for(var j = 0; j < quantity; j++){
      var temporaryData = [];

      temporaryData[0] = category;
      temporaryData[1] = "Item" + counter;
      temporaryData[2] = dateCreated;
      
      outputData.push(temporaryData);
      counter++;
    }
  }
  return outputData;
};

Answer 10

The most recent correct answer came from Bharat, who provided a solution but did not post it, so I will do so here. The resolution to this particular issue involved moving the tempData[] array within the for loop and ensuring that the count++ increment statement also remained inside the for loop after pushing the tempData.

function processData(input){

  var outputData = [];

  var category = input[0];
  var quantity = input[1];
  var dateCreated = new Date(input[2]);
  

  if (quantity > 1){
    var counter = 1;
    for(var j = 0; j < quantity; j++){
      var temporaryData = [];

      temporaryData[0] = category;
      temporaryData[1] = "Item" + counter;
      temporaryData[2] = dateCreated;
      
      outputData.push(temporaryData);
      counter++;
    }
  }
  return outputData;
};

Introducing a fresh counter variable inside a for loop

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

Utilizing Locale to Rewrite URLs in Next.js Version 13

Formulate a Generic Type using an Enum

When utilizing Express File Upload, only the initial file is uploaded during a multiple file upload process

Utilize jQuery's addClass Method when Submitting a Form Using Ajax

Using jQuery to update the parent element from within an iframe

Error encountered when extending Typography variant in TypeScript with Material UI v5: "No overload matches this call"

Choose up to three elements using jQuery

Stop the context menu from popping up when the element is right-clicked

Having trouble accessing the initial two elements of an array while generating a Fibonacci series in JavaScript

What is the best way to run asynchronous Mocha tests (NodeJS) sequentially?

`The function of clicking on a jQuery video is not functioning properly`

Strategies for managing null JSON responses from the server

Getting the ID name from a select tag with JavaScript - A quick guide!

Are Windows Gadgets the Next Big Testing Ground?

How to access the result without using subscribe in Angular?

What is the best way to transfer an id from JavaScript to Rails while utilizing ajax?

Implement a ClickEvent on a button through JavaScript, JQuery, or Bootstrap

Guide to automating the versioning of static assets (css, js, images) in a Java-based web application

Standardizing URLs with ExpressJS router

Querying the children of an element using jQuery