Retrieve Rows from Google Sheets with Google Apps Script

[@rayvera4720]

You saved me so much time, thank you!

[@jeffeverhart]

You're welcome!

[@JJGilbert]

Finally, a Google Apps Script Tutorial I can follow, and that actually covered exactly what I wanted to do with my sheets! Very nice job on this. Thank you.

[@jeffeverhart]

Thanks for watching!

[@bumpersmith]

Very good explanations. I do wish you would have applied these to real practical applications that could be used in the real world.

[@jeffeverhart]

Thanks for the feedback

[@teukurama3569]

Firstly, thank you so much for the tutorial. May I ask you how to make the trigger event is not "submit click" but certain multiple choices are chosen on the form? Thank you

[@poojajain9833]

Hey, thanks for your help. Can you please suggest me How can use the already made script with minor changes in another spread sheet

[@alexandergonzalojimenezcas3984]

Excelent, how cam I do to get a specific result acording ID and putting into anycell

[@mohauaugustinemaimela7029]

how can i read all the values google sheet values and print them out on the google docs

[@alexandervendrov7654]

I have google sheets table, each row will have its unique ID, and each row has about 15 columns. I need to print out the information from the row and give it to a worker. How to transfer the information from the row into readable information for a person?

[@jeffeverhart]

This should help you use the data in the sheet to generate Google Docs based on a template: jeffreyeverhart.com/2020/09/29/auto-fill-a-google-doc-template-from-google-sheet-data/

[@hananjaqilan]

I have a google sheet: I created functions using google script, and I am trying to read this data from an excel file, but it gives me "#NAME" for the columns that call the google script function, how can I fix this?

[@jeffeverhart]

Good question, you might try using getDisplayValues instead of getValues on the data range. This method will include additional data formatting options, so it might process the formula: developers.google.com/apps-script/reference/spreadsheet/range#getDisplayValues()

[@singhalmonica]

Pls help me to know vlookup function by scripts, dynamically....

[@jeffeverhart]

I'm not sure what you mean. Could you give me an example of what you want to do with vlookup so that I can suggest how it might be done in apps script. Thanks for watching.

[@singhalmonica]

@@jeffeverhart sir, i have my two sheets, 1 and 2. In sheet1 i have raw data, in sheet2, i use drop down and getting all data as per the bill no. From sheet1.now i want to input CHECKED against perticular bill and want to update same value in sheet1, against same bill no. Lastly i want to CLEAR that column when drop down refresh. I hope u understand it, and provide me solution for same.

[@jeffeverhart]

@@singhalmonica I'm less familiar with Google Sheets native functionality than Google App Script, so I'd suggest taking a look at the resources from Ben Collins as he does an awesome job of going through spreadsheet fundamentals: www.benlcollins.com/spreadsheets/vlookup-wildcard/

[@smartsolution8244]

How to get all selected rows and do each loop?

[@emziemz]

Excellent guide! Thank you so much.

[@sandeephanda7453]

Very good explanation Jeff. Explanations are crisp and yet detailed.

[@chervindavasol4704]

more videos like this, thank you keep it up

[@jeffeverhart]

Thanks, will do!

[@radybmcs6516]

How can we get it to HTML Sir?

[@mohammedabas3377]

I really want to thank you for your help! that exactly what I wanted to do with my scrpit! you helped a noob programer to help all his collage friends! thank you very match

[@jeffeverhart]

Thanks for watching. I'm glad it was useful to you!

[@zakpak6691]

Very good Information...good work ... and Thank you

[@jeffeverhart]

Thanks for the kind words! Cheers, JE

[@senju31]

Great video. However, do you have any tutorials and or suggestions on how to use this with triggers? I've been trying to use what you have with onOpen simple trigger and it never shows any values in the log. It only shows values when I run your function directly.

[@jeffeverhart]

Check out this article and look at the section about the stackdriver logger, as that will show executions of script functions outside of the development environment: jeffreyeverhart.com/2020/01/24/debugging-in-google-apps-script/

[@senju31]

@@jeffeverhart Thank you.

[@jeffeverhart]

@@senju31 Sure thing. Sorry I took so long to comment back. KZbin doesn't do a good job of sending notifications.