Web App Development with Google Apps Script/exercises
Jump to navigation Jump to search
Arrays[edit | edit source]
|Could probably fit on one line of code|
If you have an array of
Assuming you have a 2D array (like the rows and columns of a spreadsheet), how would you produce a variable with just the third column?
|every other row|
How could you grab every other row of a 2D array?
How would you get only rows where column A is bigger than column B and column C is one of the following:
|Gracefully find a row|
How would you look to see if a row has your email in any of the cells and return either your row or a note saying it couldn't be found?
|Count rows that match|
Write code that allows the rows to be searched and returns the number of rows that match
|Produce table row from two sheets|
Assume you have a data sheet that lists the user's email. You also have a user sheet that gives more detail about each user. Return the html table syntax for each row where the data values are listed along with the full name of the user in the same row.
Objects[edit | edit source]
|Array to object|
Given an array like
Given this object:
GAS exercises[edit | edit source]
Regex exercises[edit | edit source]
Data structure exercises[edit | edit source]
What structure would you need for a blog that has allowed users, some who can post, and all who can comment?