I'm following a tuturial on how to automatically change filenames on files uploaded through a Google Form. Upon running the script I get the following error:
TypeError: Cannot read property 'getResponse' of undefined
RenameResponses @ Kode.gs:19
This is the script:
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);
}
}
}
}
Line 19 is this one:
var photoID = itemResponsePhoto.getResponse();
Any ideas as to what the issue is?
I'm a total noob btw, so spoon feed me if you can :P
Cheers