Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save phillypb/1d227a23a7aaf799149a049d6edabb5b to your computer and use it in GitHub Desktop.
Save phillypb/1d227a23a7aaf799149a049d6edabb5b to your computer and use it in GitHub Desktop.
function getSaveLocation() {
// get spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();
// get Config sheet
var configSheet = ss.getSheetByName('Config');
// get Red Google Drive folder Id
var redFolderId = configSheet.getRange(3, 2).getValue();
// get Blue Google Drive folder Id
var blueFolderId = configSheet.getRange(5, 2).getValue();
// get Green Google Drive folder Id
var greenFolderId = configSheet.getRange(7, 2).getValue();
// get data from the Form *****************************************
var formValues = e.namedValues;
var colour = formValues['Select a colour'];
Logger.log('Colour is: ' + colour);
// get data from the Form *****************************************
// use a 'switch' to determine appropriate Drive folder to use
var parentFolderId = '';
switch (colour[0]) {
case 'Red':
parentFolderId = redFolderId;
break;
case 'Blue':
parentFolderId = blueFolderId;
break;
case 'Green':
parentFolderId = greenFolderId;
break;
}
Logger.log('Switch result is: ' + parentFolderId);
// get Google Drive folder
var parentFolder = DriveApp.getFolderById(parentFolderId);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment