首页 > 解决方案 > Google App Script - TypeError:无法读取未定义的属性“getResponse”

问题描述

我正在关注如何自动更改通过 Google 表单上传的文件的文件名的教程。运行脚本时,我收到以下错误:

TypeError: Cannot read property 'getResponse' of undefined
RenameResponses @ Kode.gs:19

这是脚本:

function RenameResponses() {
var form = FormApp.openById('MyFormID'); //DDD
var formResponses = form.getResponses();
var baseString = 'https://drive.google.com/file/d/';
var endString = '/view?usp=drivesdk';
  
var folder = DriveApp.getFolderById('MyFolderID');
var files = folder.getFiles();
 
  while (files.hasNext()) {
    var file = files.next();
    for (var i = 0; i < formResponses.length; i++) {
      var formResponse = formResponses[i];
      var itemResponses = formResponse.getItemResponses();
      var itemResponseTimestamp = itemResponses[0];
      var itemResponseName = itemResponses[1];
      var itemResponsePhoto = itemResponses[2];
      
      var photoID = itemResponsePhoto.getResponse();
      var newName = itemResponseName.getResponse() + " - " + itemResponseTimestamp.getResponse();
      var url = baseString + photoID + endString;
      var urlCheck = file.getUrl();
      if ( url == urlCheck) {
        var modName = newName + ".jpg";
        file.setName(modName);
      }
    }
  }
}

第 19 行是这一行:

var photoID = itemResponsePhoto.getResponse();

关于问题是什么的任何想法?

顺便说一句,我是个菜鸟,所以如果可以的话,请用勺子喂我:P

干杯

标签: google-apps-scriptgoogle-sheetsg-code

解决方案


推荐阅读