Web App - Search a Match in Spreadsheet - Google Apps Script Web App Tutorial - Part 5

In this Web App tutorial learn how to request data from the server and fire a callback function on success. We'll search Google Sheets spreadsheet with Apps Script JavaScript code for a zip-code and retrieve matching value from another column.

#webapp #appsscript

[aJayBoulder]

You teach this stuff at the perfect level of complexity - moving through concepts effectively without getting bogged down in meaningless details.

[awardjunction]

I never seen such a good person in youtube, never ask for subscribe or like/share. Only focus is on teaching & use very simple method to be understand. Great Sir... salute.

[rv-powerwall]

When I need help this is my first stop. Thanks so much.

[hermancoutinho]

This is a work of art... keep it up. You just made the entire process easy.

[catnop]

You have no idea how much I am grateful for you !!!!

[ronellabuguen]

Super Thanks to your vids, so clear and help me understand js application more as an starter. Please continue to create more tutorials... I love to watch all of them... Thanks... I can only thank you in return by watching your vids without skipping all ads in it.

[micuenta]

This is amazing! You make something complex look simple. Congrats!

[tinkershukla]

You have no idea how much I am grateful for you !! you just sucker punched the wannabe developers on various paid portals

[gergelykovacs]

There with the best tutors on youtube!

[thinhse]

Pretty awesome. I am able to make a search form for students based on their registration numbers. Updating on googlesheet is more pleasant than using mysql.

[Anzeljaeg]

i cant thank you enought, i will comment and like the entire serie thank you so much

[mask]

Yes u r the best! please go more complex on webapps series.

[josepino]

Excellent channel !!, The best video i've ever seen from Google Script, sincere thanks for your help.

[angelahahn]

Love the videos!! I am trying to input data from a dropdown list rather than an input to return a search from another column in the sheet and am getting hung up on how to do that?

[Benji-Hello-World]

Awesome Awesome stuff this is going to be so useful.

[uni]

Thanks for a very nice video.
In case it happens for somebody else, indexOf, kept returning, Unavailable, until I changed the data format in column A and B in the sheet to identical. Setting on Plain Text preserved the currency format as well.
Before that the Data format was set on automatic and the numbers were adding .0, without showing it, and therefore the error.

[mohanapriya]

you are the man1000%% who witnesses to once in the blue moon is real..

[joaopaulosoares]

Excellent video, keep creating content aimed at Google Script, you help me a lot.


a question!
How would the function stay if it had two criteria to be able to bring the name?

in my case I the conditions are as follows
column "A" = company
column "B" = Registration code
Column "C" = Name


function getCost(zipCode){

var ss =
var ws =
var data = ws.getRange(1, 1, ws.getLastRow(), 2).getValues();

var zipCodesList = data.map(function(r){ return r[0]; });
var costList = data.map(function(r){ return r[1]; });


var position =
if(position > -1){
return costList[position]; //"R$ " + cola R$ e coloca casas apos a virgula ou ponto

} else {
return 'Nome não encontrado verique se a matricula esta correta';

}
}

[nickieoakwood]

Am getting all way up to the duplicate text and the label raising, but after that just getting errors on TypeError: postcodesList is not a function. What has me confused at 19:35 you have:


function getCost(zipCode) then at line 33 you call it var zipCodesList. Also you swap zipcode for zipCode. Does that capital bear any relevance or is it just ease of reading words wroteTogether? like that?


Your videos are most excellent but I must admit that a bit of uniformity with naming or perhaps a quick break down and perhaps some notes in the video description would be easier for me to understand. On a positive note userform/menu/macro are now fully working (what takes you like 20 minutes took me three days!)


Thanks for the help so far.


Regards from the UK
Nickie


*UPDATE - managed to get past the errors. Had indexof instead of indexOf. Now can only get unavailable to pop up even though sheet is there. url is correct in the var url at the top. I have renamed everything zipcode to be uniform with you. Is now 2:32 in the AM so off to bed. Hopefully you can impart a bit of wisdom upon me. Am also puzzled on the difference between cost and "est in this bit:


function updateEstimate(cost){
= cost;
M.updateTextFields();


I understand the get by id "est" that being the identifier in here: <input disabled id="est" type="text" class="validate">
<label for="est" but where is the word cost appearing from? Is it the column in your g sheet but you didn't name it in the G Sheet?


Once again, many thanks

[azeezek]

Hello,

Me Azeez from India, Kerala

Thanks for your great effort in creating a wonderful youtube channel to teach us almost everything....

I am a subscriber of your Youtube channel and learning a lot through your videos. As a part of learning, I was trying to create a web App using Google sheet & App scripts.

During the development, I faced a requirement where I need to create a dependent dropdown list. The dropdown lists "A" and "B" are dependent. when a user selects an item (eg. "Cat") in DD list "A", "B" should show some options say "1, 2, 3, 4, 5". and When the user select item "Dog" in DD List "A", DD list "B" should show some options like "6, 7, 8, 9". How can I do that?. I was doing this by learning through the video series "Google Apps Script Web App Tutorial - Part 1 - Part 5" and I have watched the videos and done the code part up to Video Part 5.

Please help me to do that.