Find and filter the values in the range.getValues() array that correspond to the first element in apps script

Question

Find and filter the values in the range.getValues() array that correspond to the first element in apps script

In the spreadsheet provided, I have compiled a list of cities in different states of my country. This information will be utilized in a form; however, it is not feasible for users to sift through an extensive list of all cities listed. Therefore, I am looking to implement a filter system based on the state.

Due to the large logging output, it has been truncated. [[AC, Acrelândia], [AC, Assis Brasil], 
[AC, Brasiléia]...

The initial element in each entry signifies the state, and I intend to refine this array so that only values belonging to the chosen state are displayed. For instance, if the selected state is AC, the result would be:

[[AC, Acrelândia], [AC, Assis Brasil], [AC, Brasiléia]...

javascript arrays google-apps-script filter

Answer 1

Answer №1

Explanation

If you want to retrieve all the cities located in a specific state, you can easily achieve this by using Array.filter(). In this example, "AC" is hardcoded into the filter function, but you could substitute it with a variable for flexibility. The dataset has been purposely shuffled to demonstrate that only the cities in AC are being extracted.

Code Snippet

function test() {
  try {
    let data = [["AC", "Acrelândia"], ["AC", "Assis Brasil"], ["AC", "Brasiléia"], [...]
    let ac = data.filter( row => row[0] === "AC" );
    console.log(ac); 
  }
  catch(err) {
    console.log(err);
  }
}

Output of Console.log

7:56:24 AM  Notice  Execution started
7:56:26 AM  Info    [ [ 'AC', 'Acrelândia' ], [...]
7:56:25 AM  Notice  Execution completed

Additional Resources

Learn more about how Array.filter() works

Answer 2

Explanation

If you want to retrieve all the cities located in a specific state, you can easily achieve this by using Array.filter(). In this example, "AC" is hardcoded into the filter function, but you could substitute it with a variable for flexibility. The dataset has been purposely shuffled to demonstrate that only the cities in AC are being extracted.

Code Snippet

function test() {
  try {
    let data = [["AC", "Acrelândia"], ["AC", "Assis Brasil"], ["AC", "Brasiléia"], [...]
    let ac = data.filter( row => row[0] === "AC" );
    console.log(ac); 
  }
  catch(err) {
    console.log(err);
  }
}

Output of Console.log

7:56:24 AM  Notice  Execution started
7:56:26 AM  Info    [ [ 'AC', 'Acrelândia' ], [...]
7:56:25 AM  Notice  Execution completed

Additional Resources

Learn more about how Array.filter() works

Answer 3

Answer №2

Best Cities to Visit in Each State

function findTopCitiesForState(state = "CA") {
  const cities = [[],[]];//add your favorite cities here
  Logger.log(cities.filter(e => e[0] == state).map(r => r[1]));
  return cities.filter(e => e[0] == state).map(r => r[1]);
}

Answer 4

Best Cities to Visit in Each State

function findTopCitiesForState(state = "CA") {
  const cities = [[],[]];//add your favorite cities here
  Logger.log(cities.filter(e => e[0] == state).map(r => r[1]));
  return cities.filter(e => e[0] == state).map(r => r[1]);
}

Find and filter the values in the range.getValues() array that correspond to the first element in apps script

Answer №1

Answer №2

Best Cities to Visit in Each State

Similar questions

Determine total number of covid-19 cases with JavaScript

Leveraging Async/Await to track error counts across three distinct loops, each invoking an asynchronous function in every iteration

How can I accommodate pushState routes from Backbone.js on a node.js express server?

Disregard Cloudflare's Automatic RocketLoader feature for certain JavaScript scripts

sending an alert via a function's return statement

Is it possible to delete an element from both local storage and HTML by referencing its ID?

(Processing) Eliminating Previously Utilized Element from Array

Manipulate md-select options with Angular using setValue

Is there a way to prevent the background color from filling the entire container?

Trouble with data binding in AngularJS when using the input element

I am currently working on a project using ar.js

Calculate the product of a JavaScript variable and a PHP variable, then show the result on the

Error: The variable "Set" cannot be found in the react.js code, specifically in Safari browser

Creating a hierarchical list structure from a one-dimensional list using parent and child relationships in JavaScript

Display the names of files depending on the selection made in the drop-down menu

The jQuery functions seem to be malfunctioning when trying to retrieve elements by their ids

What is the method for adding a prefix to every line in JavaScript?

What is the most effective way to showcase a list of image URLs in HTML with Vue?

Transform the file format from .casa-model to .obj

Exploring Next.js' dynamic routes with an alternative URL approach