Append Range Values to Messy Ranges with Gaps in Google Sheets - Apps Script
In our previous tutorial, we learned how to get the last row with the `getLastRow()` method of Google Apps Script's SpreadsheetApp and setting values can cause problems when appending a range to data that has running formulas or other data running down the sheet.
However, there is a problem.
When we have messy data in the range we wish to append to, our super-fast binary search fails. So we need another approach.
In this tutorial, we cover this edge case.
To the Starter Sheet!: https://docs.google.com/spreadsheets/...
Contents:
00:00 What we're building
01:47 appendData_v3()
04:41 getFirstEmptyRow_withGaps()
09:49 test the code
** More alternatives to Getting the last row in a range **
https://yagisanatode.com/google-apps-...
** My Site **
https://yagisanatode.com/
** More on Google Apps Script **
https://yagisanatode.com/google-apps-...
** Products **
Courses *
https://yagisanatode.com/products-cat...
Google Workspace Tools *
https://yagisanatode.com/products-cat...
Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#GoogleSheets #googleworkspace #GoogleAppsScript #AppsScript #businessautomation #businessadministration
