skyline mods

skylineMods.js

function getDriveFiles() {
  const folderToUpdate = DriveApp.getFolderById('1L_AWb4RbnpTj2NS5G7kbxIRuxtProCvb');
  const files = folderToUpdate.getFiles();
  let arr = [];
  while (files.hasNext()) {
    file = files.next();
    arr.push(({id: file.getId(), name: file.getName()}));
  }
  return arr;
}

const getIds = () => getDriveFiles().map(sheet => sheet.id);

// function renameSheet(currentName, newName) {
//  // Get a reference to the sheet using its existing name
//  // and then rename it using the setName() method.
//  SpreadsheetApp.getActive().getSheetByName(currentName).setName(newName);
// }
const sheetsArray = sheetList.filter(sheet => !sheet.complete);

const doItProperly = async ()  => {
  const spreadsheet = SpreadsheetApp.openById('1KND3ndf2bSpNI9R9OeKoAniEhUUn-iFHMMvlcAIvNMU');
  let sheet = spreadsheet.getSheetByName('people');
  const data = getDataFromSheet('1KND3ndf2bSpNI9R9OeKoAniEhUUn-iFHMMvlcAIvNMU', 'people');
  let leadName = data.map(person => parseName(person.contact_name));
  let nameHeaders = ['First Name', 'Last Name', 'Primary Contact Name'];
  let arrayForSheet = leadName.map(lead => [lead.first, lead.last, `${lead.first} ${lead.last}`]);
  arrayForSheet = [[...nameHeaders], ...arrayForSheet];
  let range = sheet.getRange(1, 1, arrayForSheet.length, arrayForSheet[0].length);
  range.setValues(arrayForSheet);
  //peoplesheet.setName('old_people');
  //return await SpreadsheetApp.openById(id).then(currentSheet => currentSheet.getSheetByName('people').setName('old_People'));
}


function getSheetMap() {
  console.log(getDriveFiles());
}
function grabDataFrom(sheetId) {
  let spreadsheet = SpreadsheetApp.openById(sheetId);
  let sheet = spreadsheet.getSheetByName('Sheet1');
  let [headers, ...data] = sheet.getDataRange().getValues();
  console.log(data);
}

function getCityCountyData(sheetId = '1KND3ndf2bSpNI9R9OeKoAniEhUUn-iFHMMvlcAIvNMU', sheetName = 'household') {
  const citiesAndCounties = getDataFromSheet('1LneKw4vVF_O5dRaX8dKbbw_3uy3ofK8mqUL5elpnQ6E','cities/counties').reduce(
  (obj, item) => Object.assign(obj, { [item.Name.toLowerCase()]: item.County.toLowerCase() }), {});
  const citiesInSheet = getDataFromSheet(sheetId, sheetName).map(household => household.address_city.toLowerCase());
  console.log(citiesAndCounties)
  console.log(citiesInSheet)
  //const matchedCounties = citiesInSheet.map(city => titleCase(citiesAndCounties[city]))
  //console.log(matchedCounties);
}
const grabThisSheet = () => grabDataFrom('1bACygSZJ7zACNhk0Sk2MQotiFN3Llipc_arxTzf1BJI')

// function getSheetIds() {
//   let ids = sheetsWithOnlyNameUpdates.map(sheet => ({id:sheet.id, name: sheet.name}));
//   console.log(ids);
// }


// function getCurrentHeaders() {
//   var files = getDriveFiles();
//   console.log(files);
//   const sheetMap = files.map(file => SpreadsheetApp.openById(file.id).getSheets().map(sheet => {
//     let sheetName = sheet.getName();
//     let ss = SpreadsheetApp.getActive();
//     console.log(ss)
//     if (sheetName !== 'Sheet1') {
//       console.log(ss.getSheetByName(sheetName))
//     }
//   }));
//   console.log(sheetMap)
//   //files.forEach(file => SpreadsheetApp.openById(file.id).getSheets().map(sheet => file.sheets = sheet.getName()));
//   //let filesInSheet = files.map(file => SpreadsheetApp.openById(file.id).getSheets().map(sheet => sheet.getName()));

//  // let demoSheet = SpreadsheetApp.openById('1s5OISgEpOOVvwjOvFjpLmQCNhxAJL6CSieNPRAqtkCo');
//   // console.log(demoSheet.getSheets().map(sheet => sheet.getName()))
// }