Question

这是记录非营利性住房开支的基本理论。形式和目标领域列于下文。我试图这样做,以便在提交材料时,将上载的档案从表格本身改用田地。我想使用的田地是日期pi,两处是缩小面积的,一个包括数量在内的短处。如今,google在结尾处用“上载名称”来重新命名档案。我也想删除这一点。

我找到了一些答案,可以追溯地重新命名所有上载体触发器,但不会自动这样做。

外地细节

submissionDate - a datepicker
personName - Dropdown of names
expenseType - Dropdown with strings like food, supplies, and so forth
expenseAmount - Number, usually in ##.## form.

目标档案名称:提交文件

非常感谢你们的帮助!

这是不完整的,我不知道有正确的途径去找田。

function onFormSubmit(e) {
    var form=FormApp.getActiveForm();
    // returns the total number of form submissions
    var length=form.getResponses().length;
    //replace QUESTION NUMBER through the index of the question prompting the file upload - keep in mind that the first question has the index 0
    var id=form.getResponses()[length-1].getItemResponses()[QUESTION NUMBER].getResponse();
    //getResponses()[length-1] retrieves the last form response, accounting for the fact that the first index is zero and hte last length-1
    var file=DriveApp.getFileById(id);
    // store filename in variable
    name = file.getName();
    //Removes the built in Name added by google
    var originalname = name.split(  -  )[0]
    // !! Missing, get responses from specific fields, including converting date picker into yyyymmdd format
    var newname = datefield+namefield+typefield+originalname
    file.setName(name);
}

example电子表格增加了两栏,显示原始档案名称和我想要改名的,这只字不须在纸面上显示,只是改在角角上。

Answer 1

You want to change the file name of a file uploaded from a Google Form.

以下答案的一些显著方面是:

based on a script bound to a spreadsheet linked to the form.
function is triggered by an installable event trigger: onFormSubmit
function uses Event Objects to access the form response items.

function updateFileName(e) {
  Logger.log(JSON.stringify(e)) // DEBUG

  var values = e.values
  //get the file details
  var fileURL = values[5]
  Logger.log("DEBUG: the file url = "+fileURL)
  var id = fileURL.split("=")[1]
  Logger.log("DEBUG: the file ID = "+id)
  var file = DriveApp.getFileById(id)
  var uploadFileName = file.getName()
  Logger.log("DEBUG: the existing file name = "+uploadFileName)

  // get the file name variables
  var submittedDate = values[2].toString()
  var yyyy = submittedDate.split("/")[2]
  var mm = submittedDate.split("/")[0]
  // ensure leading zero
  if (mm.length == 1){
    mm = "0"+mm 
  } 
  var dd = submittedDate.split("/")[1]
  // ensure leading zero
  if (dd.length == 1){
    dd = "0"+dd 
  } 
  var personName = values[1]
  var expenseType = values[3]
  var expenseAmount = values[6]
  var newName = yyyy+mm+dd+"_"+personName+"_"+expenseType+"_"+expenseAmount
  Logger.log("DEBUG: the new name = "+newName)

  // save the new file name
  file.setName(newName)

  // include this lines if you want to confirm the file name chnage
  
  var newfile = DriveApp.getFileById(id)
  var revisedFileName = file.getName()
  Logger.log("DEBUG: the updated file name = "+revisedFileName)
  
}

页: 1 - 相联的Sheet

页: 1 - 执行记录

友情链接