Append range values in Google Sheets with Extra Column Data - Apps Script
Getting 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.
In this tutorial we will provide
1. An EASY approach to this using the JavaScript `reverse()` and `findIndex()` methods
2. A FAST approach using a binary search.
To the Starter Sheet!: https://docs.google.com/spreadsheets/...
00:00 What's we're building
01:31 Retrieving the data
04:54 EASY submit data
12:05 FAST binary search
24:43 Up next
** 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
Watch video Append range values in Google Sheets with Extra Column Data - Apps Script online, duration hours minute second in high quality that is uploaded to the channel Yagisanatode -Scott- 01 January 1970. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 541 times and liked it 13 visitors.
