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;
}