How to Get The Last Row - Google Sheets Apps Scripts - Array Methods Part 10

In this tutorial learn how to get the last row of data in Google Sheets using Apps Script. We'll go over several methods of getting the last row, including array version using .every() array method in JavaScript.
Array Methods Series Part 10
#javascript #appsscript

[@PawelGrabiec]

Great guide. But one question - should overwrite the existing function names? Like getLastRow?

[@dwaynedsouza]

Hi, so when I tried to get the last row, along with adding multiple data separate rows and columns (leaving a few blank columns in between), it skipped blanked rows and when to the last row that had data. I did the following; function myFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lr = ss.getLastRow(); Logger.log(lr); } And it somehow gave the last row (skipping blank rows in between).

[@SPA_developer]

The best explanations google tables! Keep up the good work!

[@haihuynhthanh3078]

Thanks very much. A teacher is really great!

[@ExcelGoogleSheets]

Thank you! 😃

[@testaccount6075]

Thank you so, so much for this intermediate series!

[@oxpey4473]

Doesnt work for me, it said "Cant getRange property of undefined.

[@tuberats99]

just what a novice needs :)

[@RoseLK]

It works for me. Thank you so much for the lessons!

[@pichit.raetai]

Thank you, you are my teacher.

[@carmencastro5512]

mil gracias, buen video, buena explicacion, sigue haciendo videos asi.......

[@SilverfoxTOAO]

Why not set lrIndex inside your if statement? Why set it on every iteration of the for loop? You already have i tracking. Just set it when you find what you're looking for. Or am I missing something?

[@vanessagarcia5258]

Super helpfull...Tysm!!!

[@ExcelGoogleSheets]

👍

[@tonmoyahmed1985]

wow! it's very helpful, Thank you

[@yasmeenkarachiwala3766]

Hello Sir, Thank you so much for the great content. I want to create an audit function to pick up random rows based on certain criteria. Could you please provide some help? Thank you!

[@nhule8442]

Fantastic thanks ☺️

[@jaesonboque3888]

This helps alot wow

[@Blackdocks]

THANK YOU !

[@securecircle4031]

I have a result set that I push in one array and I want to paste it from the last blank row. Do you have any method using appscript to obtain the last blank row and paste all my array from this blank row? I want to paste all array instead of row by row in spreadsheet. Thanks!

[@dohatransmission4760]

Hi there you have so much content on KZbin I'm having trouble finding the videos in the right order, have you? or can you ? put up a playlist somewhere of all the videos in the correct order? It would be much appreciated as I go through them all. Many thanks and tanks again for all this work it's really a fantastic resource.

[@ExcelGoogleSheets]

It's already done here kzbin.infoplaylists

[@bulbulahmed3098]

❤❤❤❤

[@Adanknaw]

Thank you bro

[@patrickm9953]

Great job, easy to follow guide.. I was just wondering how to do this. Thx

[@kachler67]

Very nice tutorial, thanks mate. So I'm trying to create a button, that sets the next checkbox (they are in G11:G and auto timestamp with your onEdit(e) approach in H11:H) right after the last row to TRUE when pressed, so that I have a "LOG IN" button at the top without the need of scrolling down and toggling the respective box myself. How can I use the "lr" variable to set the value, can you help me on that one maybe?

[@wilbertsembiring2209]

Hi, can you help me for this : No logs found. Use Logger API to add logs to your project. Thank you before..

[@paulloup5210]

Thank you very much !

[@ZX-uh2mw]

quick question: how do you create a script to delete the last row? similar to this script: function row() { var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('3:3').activate(); spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows()); };

[@emersonpan]

I might encounter a tiny bug. If the last row is 0. Then the every(function(c){ return c == ""; }) would return true instead of false. But every(function(c){ return c === ""; }) fix it.

[@ExcelGoogleSheets]

good catch!

[@emersonpan]

Good tutorial~ thank you for the great work.

[@eiger67]

Thank you for this

[@jaedonbigbrain8700]

how can i do to send data from one spread sheet to another spread sheet please

[@marcelcharest7662]

Merci!

[@phoenixempire8886]

🙏🏻

[@strativaryus]

Thanks for sharing. Great content as usual! Could you give us a light, please? I explain my point bellow. That method is witchy... I'm not as much familiar to JS as I should be, I guess... At 18:30, you take all 5 first columns in a range (rng = "A1:E"), than you feed one line at a time doing 'row = rng[i]'. Later, you instruct that every cell in that row should run a function that returns a logical result, testing its content against null (""). So, every cell is going to test equality to 'null' and the variable receives them all, actually as an array containing TRUEs and FALSEs, five of them at most. Is that right? In the most common situation, we have 'row=[,,,,]' -- so we get 'isBlank=[TRUE,TRUE,TRUE,TRUE,TRUE]' But when 'row=[,,blah,,] -- we instead get 'isBlank=[TRUE,TRUE,FALSE,TRUE,TRUE]'. Listen, Your code is not ANDing all those cells, even though a simple 'if(!isBlank)' does the magic!! Why is that??! Dawn, I hate those smoothly typeless languages... Can you provide a documentation where I can read all those implicit routines in JS, please?

[@ExcelGoogleSheets]

isBlank is not an array, it's just one value, true or false. Watch this video to understand how every method works kzbin.info/www/bejne/nZKmY2xmjd-DjpY

[@ExcelGoogleSheets]

Also !true will make it false, !false will make it true. Just watch the video I linked, I cover all of that.

[@strativaryus]

That makes it clear! Wow, you already get it in another video. I'm sorry for my lack of attention. I should watch all your videos before asking. Good job!

[@Dfjjiii8btrdcvvbbhhhhhhhhh]

How to get headers or first row?

[@khemrajrana7322]

Nice sir but sir how to selected all column in one time in Google sheet plz rply

[@ExcelGoogleSheets]

Unfortunately, I'm not sure what you're asking.

[@khemrajrana7322]

Sir how to Selected All column Name range one time in Google sheet

[@elabinnovations]

*Thank you sir* How to get last row into JSON map format?

[@ExcelGoogleSheets]

You would have to grab the labels row and your last row, then loop through it to make a JavaScript object, then JSON stringify it.

[@elabinnovations]

@@ExcelGoogleSheets any video tutorial?

[@elabinnovations]

@@ExcelGoogleSheets Can you make a video?

[@Tom-fm2us]

No logs found. Use Logger API???? Documentation does not match my experience.

[@Malally2]

its telling me "getlastrow is not defined" ........

[@ExcelGoogleSheets]

CaseSensitive