Cannot read properties of undefined (reading 'Email')

37 views
Skip to first unread message

T P

unread,
Mar 28, 2024, 8:05:19 AM3/28/24
to Google Apps Script Community
I have created a form, and the script generates an error saying "Cannot read properties of undefined (reading 'Email')". I have checked that the content of the form and the script are consistent, but it still doesn't work.
function onFormSubmit(e) {
  var email = e.namedValues['Email'][0]; // 确保这与您的表单字段匹配
  var fileIds = e.namedValues['Upload File']; // 这假设您的文件上传字段名称是'Upload File'

  // 生成7位随机ID和当前日期
  var id = generateId(7);
  var date = Utilities.formatDate(new Date(), Session.getScriptTimeZone(), "yyyyMMdd");
  var folderName = id + '_' + date; // 组合ID和日期来创建文件夹名称

  // 创建或获取文件夹
  var folder = getOrCreateFolder(folderName);
 
  // 如果有上传的文件,则将其移动到该文件夹
  if (fileIds) {
    fileIds.forEach(function(fileId) {
      try {
        var file = DriveApp.getFileById(fileId);
        file.moveTo(folder);
      } catch(error) {
        Logger.log('Error moving file: ' + error.toString());
      }
    });
  }
}

function generateId(length) {
  var id = '';
  var characters = '0123456789';
  var charactersLength = characters.length;
  for (var i = 0; i < length; i++) {
    id += characters.charAt(Math.floor(Math.random() * charactersLength));
  }
  return id;
}

function getOrCreateFolder(folderName) {
  var folders = DriveApp.getFoldersByName(folderName);
  var folder;
  if (folders.hasNext()) {
    folder = folders.next();
  } else {
    folder = DriveApp.createFolder(folderName);
  }
  return folder;
}
Reply all
Reply to author
Forward
0 new messages