Filter Google Sheet in Web App

[@CodeWithCurt]

Google Apps Script Code Used In Video Below: //function doGet(e) { // var htmlOutput = HtmlService.createTemplateFromFile('FilterWhole'); // htmlOutput.search = ''; // return htmlOutput.evaluate(); //} function doGet(e) { var htmlOutput = HtmlService.createTemplateFromFile('FilterHeaders'); htmlOutput.miles = ''; htmlOutput.color = ''; return htmlOutput.evaluate(); } //function doPost(e) { // // Logger.log(JSON.stringify(e)); // // var search = e.parameter.search; // // var htmlOutput = HtmlService.createTemplateFromFile('FilterWhole'); // htmlOutput.search = search; // return htmlOutput.evaluate(); // //} function doPost(e) { Logger.log(JSON.stringify(e)); var htmlOutput = HtmlService.createTemplateFromFile('FilterHeaders'); htmlOutput.miles = e.parameter.miles; htmlOutput.color = e.parameter.color; return htmlOutput.evaluate(); } function getSheetData() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var dataSheet = ss.getSheetByName('Data'); var dataRange = dataSheet.getDataRange(); var dataValues = dataRange.getValues(); return dataValues; } function getUrl() { var url = ScriptApp.getService().getUrl(); return url; }

[@johnwysham5725]

Thanks!

[@CodeWithCurt]

HTML File FilterWhole Code Below: Web App Filter Whole

[@CodeWithCurt]

HTML File FilterHeaders Code Below: Web App Filter Headers

[@martinaguilar9661]

Curt, how can I make the table not to show before the search? Thanks!

[@csptechinspiration]

how to change the search column ? this video showing color amd miles. but how to search by other header..?

[@abisheklaxmanan7726]

For the Filter Whole any string name given searches out which is a good thing. But for filter headers only exactly matching string is returned. Anything more is not displayed. Is it possible to get even if the entry is part of the string? Thanks

[@johnnybegood948]

its possible to increment more than one workbook (spreadsheets) to search them all?

[@maricelaustria1733]

how do you make the list hidden and just display data which is being searched?

[@pini141]

hi, i am also need to know that (hidden data before search). did you find the answer?

[@gauravpaithane]

MAKE A EMPTY WORKSHEET PULL WORKSHEET INTO GS CODE..... DECLARE IT AS VERIABLE ...... IN FINAL ELSE STATEMENT output_array = that variable tabel ....

[@juliejones5395]

This is helpful. I'm wondering if there is a way to specific the google sheet that the data is pulled from without having it open. I want people to be able to search, but not be required to open the google sheet.

[@serhener5662]

Please answer my query, how to not enable other parts of the table and only searchable data will reflect

[@wirot125]

Could you please advice how to hide the table before seaching? Thank you.

[@muhammedaadhil5645]

Very useful and most would love this. You are a great coder understand client side needs. ❤ My personal request is, if there would be an add data and edit data options within the rows to this table; It will be a wonderful and complete work front for office colleagues. There won't we a requirement to visit the sheet. Just get things done at one place. Thanks for all your valuable videos. I'm a big fan of this channel. I've benefited alot.

[@Aniruddha759]

How can we add dynamic text box along with each row of data and adding text to textbox will add in google form in another column

[@bestleads5831]

How would i be able to.print or download results

[@waltermollaret816]

hi i wanna ask its possible filter and show just 3 columns (for example search RED and show colums color, year and model name)

[@wilfredocaja1454]

I adopted your code , but I need formula on table total each filtered sheet in web app, could you help me

[@heyzain123]

Can we also edit the data displayed on web app? If yes, how is that possible? Thanks!

[@jearningworld7084]

Thanks for such a great video. It helps me a lot. But one thing i want to do it , is that search result appears on form submission but i want it on input DOM method without form submission, is that possible ?

[@ashish5563]

this does an exact match serach how do we check partial matches

[@CanCanBuddy]

Sir, how to add 2 more filter option please send the coding

[@jayasri-ft8040]

Yes bro, it's really useful to us. Only thing need to check is all other's secreat data also displayed initially in search. So, avoid whole data disply at initial search screen. Keep your enthusiastic video's. Good day.

[@ike6795]

Yes it really be lovely if the whole data in the spreadsheet is hidden from the screen initially and only return or display values as search result. Also is it possible to have an image column within the spreadsheet and hv an image returned as part of the search result within a row?

[@Jfresh55]

How do you make this look more appealing? I want to add a background color, a clear and submit button, maybe center everything on the page, a logo. Lol.

[@cspautomech5557]

How to search by other column head?

[@johnwysham5725]

Your work is just what I need at the moment. A big gift. Much obliged.

[@어마차우위야터헨]

Good tutorial thank you for sharing. I assume the purpose of this project is to hide the rest and show only the data that is equal to the search query. I hope the creator or other coders will answer those questions below on how to hide the data prior on searching.

[@socialmediaisaweboflies]

One knows the algorithm but the syntax and tricks offered by a particular tool or technology makes the whole difference. This demo gives me the exact syntax I needed but was struggling due to just a week in this technology. Great stuff. Thank you for such patient explanation.

[@carlarrowsmith]

Hey Curt loving your videos, long time Google user and still so much to learn from you. The link doesn't work to the code, just takes you to the front page of your site, any chance of a fix. Thanks for all the work :)

[@martinaguilar9661]

Very useful ideas and very well explained. Thanks! Is it possible to make a web app to search for a code (like a coupon code) and get information about it from Sheets?

[@rightangle1946]

date not fetch in web app

[@panuwatkpp2633]

I can set it to 2 conditions and then display it? Can I use &&? thankyou.

[@CodeWithCurt]

That won't work in this example. Are you looking to do a range between 2 numbers? Or look for 2 different Strings.

[@ike6795]

This is an awesome video and I really love it. Thanks for this. However I have 2 questions? 1. Is there a way to make the whole list not show in the first place and only display or return search values on the screen? 2. Also can you make a video where an image can be part of the data values within a row and hv the image display as part of a search result alongside the other values within a row.

[@Enrique-dTraveller]

Just change your htmloutput at doGet function. Instead of '' to 'something_else'

[@harmindersingh4711]

I am getting error in dopost script

[@RajakumaranRavi]

how to create google script code

[@thebossismael1511]

Cómo traigo los datos al input de nombre después de buscar por Miles y que se auto complete la información?. Gracias y muy buenos tus vídeos 💪🏻😎👏🏻👏🏻👏🏻

[@datclarinet303]

Thank you very much Could you please instruct more how to embed code to google sites

[@DienNuocBaoLan]

Cảm ơn Bạn rất nhiều, tôi đã thực hiện theo các bước bạn hướng dẫn và đã thành công !

[@curious5972]

Thanks for the knowledge

[@pichit.raetai]

Thank you very much

[@ka9z191]

Thank you for your share

[@nirutsoncha6763]

Thank you.

[@udhayasankar2459]

Tamil language ley teaching please