Timeline for Need help with Google moving rows on open for Google Sheets Script
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 31, 2020 at 8:52 | comment | added | Tedinoz | You were right - deleting the rows does reduce the total number of rows on the sheet. | |
| Aug 31, 2020 at 8:50 | comment | added | SystemWorks | Answer accepted. Got the general idea, just still not sure about Logger.log functions but will look into them. Always good to learn. Thank you. | |
| Aug 31, 2020 at 8:48 | vote | accept | SystemWorks | ||
| Aug 31, 2020 at 7:52 | comment | added | Tedinoz |
I've edited the answer. Just four lines of code at the very end of the script, immediately prior to return;. If this answer was helpful, you might consider "accepting" it.
|
|
| Aug 31, 2020 at 7:51 | history | edited | Tedinoz | CC BY-SA 4.0 |
add script to insert new rows to replace the deleted rows.
|
| Aug 31, 2020 at 2:32 | comment | added | SystemWorks | By looking at the script, it copies the rows and then it deletes the rows it moved. I'd like to add for the script to insert the same number of deleted rows back into the sheet after deleting to avoid the sheet running out of rows. Or does it do that already? Not sure, but I think it does not. | |
| Aug 31, 2020 at 2:28 | comment | added | SystemWorks | I have used the code and it works. Exactly what I was looking for. Now, I just need to analyze it so that I get full understanding of it. Thank you. | |
| Aug 29, 2020 at 3:34 | history | answered | Tedinoz | CC BY-SA 4.0 |