Each of those arrays contains 4 values (first name, last name, age and grade). Logger output (an array containing 5 array values): Then, we're going to create another array called students using the five arrays we just created. First, we are going to create an array per student to store their information. We are going to create an array that stores all of this information. There are 5 rows in the table and each one contains information about a student. Logger.log(colors.length) Using arrays to store tabular dataДЄn array can also contain other array values. The property length will tell you the number of values in the array. Try it out.ДЄll arrays in Apps Script have certain properties and methods to help you do more with the values stored in them. So, Logger.log(colors) will return undefined. In the above example, there are only six colors in the array colors. If you try accessing a value that does not exist in the array, Apps Script will return the value undefined. You can access the value at a specific index by using the brackets notation. Since the indexing system starts at 0, the last value in the array will have the index N - 1, where N is the number of values in the array.

The color at index 0 is 'red', 1 is 'blue' and so on. The indexing system starts at 0 and not 1. Logger.log(colors) //ДЄrrays have an indexing system to help you access values stored at specific positions. You list a number of values within square brackets ( ). Here is how you declare and initialize an array called colors. You will use arrays extensively while working with Google Sheets using Apps Script. An array is a special type of object that is used to store a list of values.

Array vs arraylist notation