Gg / Google Drive 移動副本文件到特定資料夾 3

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

function getDatafromSheet() {
  //https://docs.google.com/spreadsheets/d/***************************************/
  //113-修訂版學習扶助師資研習課程講師培訓課程-課後作業 (回覆)
  var ss = SpreadsheetApp.openById("***************************************");

  var sOne = ss.getSheets()[2];//工作表-作業處理
  //Logger.log(sOne.getName());

  var r = sOne.getLastRow();
  //var r = 3
  //Logger.log(r);

  for (var i = 2; i <= r; i++) {
    //Logger.log(i);
    var checkDo = sOne.getRange(i, 9).getValue();
    if (checkDo === "") {
      var rName = sOne.getRange(i, 3).getValue();//姓名
      //Logger.log(rName);
      var rCity = sOne.getRange(i, 5).getValue();//服務縣市
      //Logger.log(rCity);
      var rSub = sOne.getRange(i, 6).getValue();//繳交作業科目
      //Logger.log(rSub);
      var rFiles = sOne.getRange(i, 7).getValue();//課後作業上傳
      var rFilesArr = rFiles.toString().split(",");
      //Logger.log(rFilesArr.length);
      var rDriUrl = sOne.getRange(i, 8).getValue();//雲端資料夾網址
      //Logger.log(rDriUrl);

      //var resultMoveFile = test();
      //Logger.log(resultMoveFile);
      if (rFiles == "" && rDriUrl != "") {
        var reustMg = copyDriUrl(i, rName, rCity, rSub, rDriUrl);
      } else {
        var reustMg = copyFileToFolder(i, rName, rCity, rSub, rFilesArr);
      }

      //Logger.log(reustMg);

      if (reustMg[0] === "good") {
        sOne.getRange(i, 9).setValue("◎");
        sOne.getRange(i, 10).setValue("https://drive.google.com/drive/folders/" + reustMg[1]);
      } else if (reustMg[0] === "bad") {
        sOne.getRange(i, 11).setValue(reustMg[1]);
      } 
      //if reustMg
    } else {
      Logger.log("已執行過");
    }
    // if checkDo
  }
  //for i
}