for loop to assign values to multiple variables

Question

I'm wondering if there is a way to create a for loop that will assign values to a variables that would look something like this: ('preview' is a variable assigned earlier in my code that provides access to the spreadsheet).

     <? 
          var i;
          for (i=0;i<20;i++){
            var values = preview.getRange('B5:B24').getValues(); //list of values to be assigned to variables
            var bills = //code that creates a variable "Bill" + i as array (result: "Bill1", "Bill2", "Bill3", etc)
            for (let bill of bills){ //my attempt at assigning values to bills
               bill == values[i] //"bill" here would be the variable that refers to "Bill1", "Bill2", "Bill3", etc). values would refer to my array, and [i] would be for the corresponding order

     ?>

Here is a small example: Let's just say I'm using 3 bills, and the values will be "$100", "$75", and "$240" respectively. The result of the function would do the equivalent of typing this:

            var Bill1 = 100;
            var Bill2 = 75;
            var Bill3 = 240;

These variables would then later be called upon as <?= Bill1 ?>

EDIT (CLARITY): The first challenge for me is to create an array of all the bills, something like this:

  ```
     var i;
     var bills = { //attempt to create array of all results ("Bill1", etc)
     for (i=0;i<20;i++){ //THIS IS THE PART MOSTLY IN QUESTION
      "Bill" + i + 1 //to result in "Bill1", "Bill2", etc
     };}


     //then loop through bill of bills to assign values[i]
     for (let bill of bills) {
       bill == value[i];
       i++;
     }

What's wrong with just using values as it is, as a array? The flow of thought or logic here is redundant and bad. — TheMaster
– TheMaster, Commented Mar 29, 2020 at 18:51
I would like to keep values here, my question is more so about how to create the loop for creating variables named "Bill1", "Bill2", "Bill3" and then assign them to the values[i]. There will be a lot (about 80) different variables and it would would very clutter-y to write them all out individually. So I was hoping to find a way to do it through a loop. — jrob11
– jrob11, Commented Mar 29, 2020 at 19:01

TheMaster · Accepted Answer · 2020-03-29 19:08:40Z

2

A array is a collection of values and is the recommended way to store multiple related values instead of creating a variable name for each value.

These variables would then later be called upon as <?= Bill1 ?>

It is also possible to call each value in a array as:

<?= Bill[1]?>

To list all values,

<? 
        const values = preview.getRange('B5:B24').getValues(); //list of values to be assigned to variabl
        for (let [bill] of values){ 
?>
         <ul><?=bill?></ul>

<?      }     ?>

References:

Html templates#Index.html

answered Mar 29, 2020 at 19:08

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

for loop to assign values to multiple variables

1 Answer 1

References:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

References:

Comments

Your Answer

Sign up or log in

Post as a guest

Related