Only writes one row of permissions

[bingaman]

You're overwriting the permissions row on each loop so it just ends up showing one permission per shared drive

appscript-google-shared-drive-inventory/Code.gs

Line 150 in 6041c5e

newRow = [this_audit_date, this_drive_id, this_drive_name, value.emailAddress, value.type, value.role];

[mjoyosa]

Here's what I did to make it write all permissions:

1. Replace:

   appscript-google-shared-drive-inventory/Code.gs

   Line 111 in c32fbc3

   var lastRow = rangeData.getLastRow();

   with:
   var lastRow = rangeData.getNumRows();
   var driveCount = lastRow - 1;

2. Use driveCount instead of the this constant:
   

   appscript-google-shared-drive-inventory/Code.gs

   Line 12 in c32fbc3

   const NUMBER_OF_ROWS_TO_LOOKUP_PERMISSIONS_PER_LOOP = 100;

   in:

   appscript-google-shared-drive-inventory/Code.gs

   Line 112 in c32fbc3

   var searchRange = drives_sheet.getRange(2,1, NUMBER_OF_ROWS_TO_LOOKUP_PERMISSIONS_PER_LOOP, lastColumn);

   and in:

   appscript-google-shared-drive-inventory/Code.gs

   Line 119 in c32fbc3

   for ( i = 0; i < NUMBER_OF_ROWS_TO_LOOKUP_PERMISSIONS_PER_LOOP; i++) {

This is will prevent the script from using a blank Drive ID for the permissions query if your Shared Drive list is fewer than the value of NUMBER_OF_ROWS_TO_LOOKUP_PERMISSIONS_PER_LOOP.

3. This should be included in the loop at line 148 to be able to write all the permissions in the array.

appscript-google-shared-drive-inventory/Code.gs

Line 159 in c32fbc3

rowsToWrite.push(newRow);

[usaussie]

Thanks for the heads up on this issue. -- if you want to add this as a pull request, i'll review again and accept/merge it.