Showing posts with label GAS. Show all posts
Showing posts with label GAS. Show all posts

Programming Alerts in Google Apps Script

Following codes (JavaScript) show how to write various types of alerts in Google Apps Script (GAS). It also shows the usage of the alias for function in JavaScript.

GAS Function to get the Count of a Specified Item in an 1D Array

A JavaScript function, specially meant for Google Apps Script or GAS, to get the count of a specified item (case sensitive) in an one dimensional (1D) array. It takes the parameters such as "array" which is the one dimensional array on which the search needs to be done. And the other parameters and return value are explained in the function below itself in JSDoc format.

GAS Function to search a value in a Multidimensional Array

A JavaScript function, specially meant for Google Apps Script or GAS, to get the vertical (column-wise) lookup value from a multi-dimensional array. It takes the parameters such as "searchValue" which is the value to search for the lookup. And the other parameters and return value are explained in the function below itself in JSDoc format.