LoginSignup
0
0

More than 1 year has passed since last update.

たくさん複製したスプレッドシートを、日付をトリガーにして削除する

Posted at

3日経ったら、フォルダ郡を削除しちゃおっと。

function deleteFolder() {
  let pFolderID;
  pFolderID = "1irNZkuQ9WhalUdZj78wLmss3Kguw9muW"; //指定フォルダのID…可変

  let name = "";

  //今日を基準に3日前、4日前、5日前を取得
  let date = new Date();
  date.setDate(date.getDate() - 3); //3日前を取得
  let dAgo3 = Utilities.formatDate(date, 'JST', 'yyyy/MM/dd');

  date = new Date();
  date.setDate(date.getDate() - 4); //4日前を取得
  let dAgo4 = Utilities.formatDate(date, 'JST', 'yyyy/MM/dd');

  date = new Date();
  date.setDate(date.getDate() - 5); //5日前を取得
  let dAgo5 = Utilities.formatDate(date, 'JST', 'yyyy/MM/dd');

  //フォルダ一覧を取得
  let folders = DriveApp.searchFolders("'" + pFolderID + "' in parents");

  //フォルダ一覧からフォルダを順に取り出し、処理
  while (folders.hasNext()) {
    var folder = folders.next();
    name = folder.getName();

    if (name.indexOf(dAgo3) != -1) {
      console.log(name + "を削除");
      folder.setTrashed(true)
    } else if (name.indexOf(dAgo4) != -1) {
      console.log(name + "を削除");
      folder.setTrashed(true)
    } else if (name.indexOf(dAgo5) != -1) {
      console.log(name + "を削除");
      folder.setTrashed(true)
    } else {
      console.log(name + "は削除しない");
    }
  }

}
0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0