Great vid. Instead inserting a row below train (as a predefined row in the script) how do you insert behind a row number selected when you activate the script? Like a pop up box to ask for the row number when the script is run?
hi may I ask I been follow all your typing But when I run it I get " TypeError: Cannot read property 'getLastRow' of null (line 6, file "Code") " How can I solve it..?
Doesn't work for many rows to be deleted, because the loop "eats" itself. When you delete a row the value locations below it change. Imagine doing this when you are iterating through the rows and columns from the top to the bottom. After you delete the first row and loop through to the next row, your row-to-delete will be positioned one point below where it is meant to be, deleting the wrong row.
in that case during deleting row you can decrement the value of i eg "i = i -1 ". it will actully repeat the deleted row no which is acutally a new one.
Thanks for this. Easy. Straightforward. Clear. Nothing hidden behind the scenes. A bit slow for big sheets, but QUICK for understanding.
The only example that worked for me seamlessly, thanks a bunch!
Thank you so much, god bless you...🙏
Very useful functions in a small, compact video. Nice!
Thanks you. Great lesson.
Nice work man! Thank you so much
Thank you, I just modified and Could you make tutorial for double responses and scripts to delete the old data by timestamp and an id?
Simply Fabulous! Thank you!
Great vid. Instead inserting a row below train (as a predefined row in the script) how do you insert behind a row number selected when you activate the script? Like a pop up box to ask for the row number when the script is run?
Great!
Is there a way to delete cells then automaticly shift up?
Thanks for this!!
Thanks a lot!
And what about replacing the values with information from cells A34, B34 and C34 instead of values set via setValues([['AIRPLANE', 'ORANGE', 30]]); ?
hi may I ask
I been follow all your typing
But when I run it I get " TypeError: Cannot read property 'getLastRow' of null (line 6, file "Code") "
How can I solve it..?
How delete row for multiple sheet
How about replacing multiple rows?
how can ido the same from other spread sheet
Wish most examples were as detailed as this.
The delete function is executing without any error but not deleting the row in the sheet...plz help!
How i will data on top row,
Doesn't work for many rows to be deleted, because the loop "eats" itself. When you delete a row the value locations below it change. Imagine doing this when you are iterating through the rows and columns from the top to the bottom. After you delete the first row and loop through to the next row, your row-to-delete will be positioned one point below where it is meant to be, deleting the wrong row.
in that case during deleting row you can decrement the value of i eg "i = i -1 ". it will actully repeat the deleted row no which is acutally a new one.
Tx, how to edit text
How to delete row using keyword in sentence?
Good
Sir, How to add record at the end of record
you can use sheet.appendRow() function
How to Remove duplicate row from Google sheet
Good
how to auto replace caracter in cell?