Google sheet + Web app search specific column and return all matching rows

Question

Anybody knows how can I amend the code below to only search from a specific column in Google sheet e.g. column J?

The code below works great and returns the entire row that matches the searchtext, but the search is across the entire range within the google sheet. https://www.bpwebs.com/create-web-forms-to-get-data-from-google-sheets/comment-page-1/#comments

idfurw · Accepted Answer · 2021-08-01 11:11:51Z

0

  const colIndex = 9; // Column J
  data.forEach(function(f) {
    if (f[colIndex] == searchtext) {
      ar.push(f);
    }
  });

edited Aug 1, 2021 at 11:11

answered Aug 1, 2021 at 10:03

idfurw

5,8482 gold badges7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Vanny Over a year ago

When i change it to this, it only returns column J. I need it to return column A:N, but only search column J.

idfurw Over a year ago

Updated. Please check

Vanny Over a year ago

Thanks, it works perfect. :) Would you happen to know if its possible to sum up column N and display it below or something? In column N each row has a $$ value.

idfurw Over a year ago

What do you mean by 'display it below' and a '$$' value? Please create a new question and elaborate.

Collectives™ on Stack Overflow

Google sheet + Web app search specific column and return all matching rows

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related