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; }
@CodeWithCurt
3 жыл бұрын
HTML File FilterWhole Code Below: Web App Filter Whole
@CodeWithCurt
3 жыл бұрын
HTML File FilterHeaders Code Below: Web App Filter Headers
@martinaguilar9661
3 жыл бұрын
Curt, how can I make the table not to show before the search? Thanks!
@muhammedaadhil5645
3 жыл бұрын
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.
@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.
@johnwysham5725
2 жыл бұрын
Your work is just what I need at the moment. A big gift. Much obliged.
@jayasri-ft8040
3 жыл бұрын
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
3 жыл бұрын
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?
@johnwysham5725
2 жыл бұрын
Thanks!
@maricelaustria1733
2 жыл бұрын
how do you make the list hidden and just display data which is being searched?
@pini141
2 жыл бұрын
hi, i am also need to know that (hidden data before search). did you find the answer?
@gauravpaithane
2 жыл бұрын
MAKE A EMPTY WORKSHEET PULL WORKSHEET INTO GS CODE..... DECLARE IT AS VERIABLE ...... IN FINAL ELSE STATEMENT output_array = that variable tabel ....
@abisheklaxmanan7726
3 жыл бұрын
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
@user-nx6xz6pv3z
2 жыл бұрын
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.
@ike6795
3 жыл бұрын
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
3 жыл бұрын
Just change your htmloutput at doGet function. Instead of '' to 'something_else'
@carlarrowsmith
2 жыл бұрын
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 :)
@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.
@martinaguilar9661
3 жыл бұрын
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?
@DienNuocBaoLan
2 жыл бұрын
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 !
@johnnybegood948
3 жыл бұрын
its possible to increment more than one workbook (spreadsheets) to search them all?
@jearningworld7084
3 жыл бұрын
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 ?
@serhener5662
Жыл бұрын
Please answer my query, how to not enable other parts of the table and only searchable data will reflect
@wirot125
3 жыл бұрын
Could you please advice how to hide the table before seaching? Thank you.
@datclarinet303
3 жыл бұрын
Thank you very much Could you please instruct more how to embed code to google sites
@csptechinspiration
2 жыл бұрын
how to change the search column ? this video showing color amd miles. but how to search by other header..?
@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
@thebossismael1511
3 жыл бұрын
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 💪🏻😎👏🏻👏🏻👏🏻
@heyzain123
2 жыл бұрын
Can we also edit the data displayed on web app? If yes, how is that possible? Thanks!
@wilfredocaja1454
2 жыл бұрын
I adopted your code , but I need formula on table total each filtered sheet in web app, could you help me
@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)
@rightangle1946
3 жыл бұрын
date not fetch in web app
@curious5972
3 жыл бұрын
Thanks for the knowledge
@jfresh2054
3 жыл бұрын
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.
@bestleads5831
7 ай бұрын
How would i be able to.print or download results
@cspautomech5557
2 жыл бұрын
How to search by other column head?
@CanCan-dr8lv
3 жыл бұрын
Sir, how to add 2 more filter option please send the coding
@ashish5563
Жыл бұрын
this does an exact match serach how do we check partial matches
@pichit.raetai
3 жыл бұрын
Thank you very much
@nirutsoncha6763
3 жыл бұрын
Thank you.
@panuwatkpp2633
3 жыл бұрын
I can set it to 2 conditions and then display it? Can I use &&? thankyou.
@CodeWithCurt
3 жыл бұрын
That won't work in this example. Are you looking to do a range between 2 numbers? Or look for 2 different Strings.
Пікірлер: 48