## Monday 28 October 2019

### Array - sort 2-D items each with a value

The following Google Apps Script builds on this previous blog post by introducing sorting for a 2-D array that contains items with a numerical value. As before we want to sort the array in ascending order based on the numerical value, but also keep the text associated with it (which in this example is part of a larger script that counts the frequency of words in a piece of text).
var myArray = [["means", 5.0], ["you’ve", 3.0], ["help", 19.0], ["they", 17.0]];
All we ultimately need to do in the sortNumbers function is define which part of the array the 'sort' needs to look at. As an array starts at zero that would give us the text value which is not what we want, so instead we specify that a and b should use position one for the numerical value. In this example we have logged the value to verify the correct element of the array is being called.
function sortNumbers(a, b) {
Logger.log(a[1]);
Logger.log(b[1]);
return a[1] - b[1];
}
So in this example we end up with the result.
[[you’ve, 3.0], [means, 5.0], [they, 17.0], [help, 19.0]]

## Sunday 27 October 2019

### Array - sort simple numerical values

The following Google Apps Script is designed to take an array of numerical items and sort them in ascending order (from lowest to highest).

We begin with an array of values and call a function named sortNumbers.
var myArray = [40, 100, 1, 5, 25, 10];
myArray.sort(sortNumbers);
The sortNumbers function takes 2 values as input parameters and sorts them according to the returned (negative, zero, positive) value. If the result is negative a is sorted before b. If the result is positive b is sorted before a. If the result is 0 no changes are done with the sort order of the two values.
function sortNumbers(a, b) {
return a - b;
}
So in this example we end up with the result.
[1.0, 5.0, 10.0, 25.0, 40.0, 100.0]
Here is a link to a version with a 2-D array of items each with a value.

## Monday 7 October 2019

The following Google Apps Script is designed to add some hyperlink text to an existing Google Doc - the BBC news website in this example.

It makes use of 'setLinkUrl' when appending a paragraph of text.

## Saturday 5 October 2019

### While loop with a Sleep and Toast

The following Google Apps Script is a simple 'while' loop that pops up a 'toast' message every 5 seconds by making use of 'Utilities.sleep' to pause the script.

This was created as part of some testing for another script designed to bulk move files between Google Drive folders. Without the toast notification it was difficult to determine the progress being made, so adding it in allowed for the name of the file last copied to be displayed to the user. This script removes all of the extra features and shows the basic while loop and toast.

## Friday 4 October 2019

### Web app - capture information and add an apps script dropdown

Continuing with the web app project from here there are now some further additions that have been introduced:
• More fields for capturing information - dropdown list, textarea;