Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
322 views
in Technique[技术] by (71.8m points)

javascript - Cannot read property 'getResponse' of undefined file_name

function renameFile(e) {
  var itemResponses=e.response.getItemResponses();   
 var email_id= itemResponses[3].getResponse();

      var url="https://docs.google.com/spreadsheets/d/1wuSWstYCk8DuAPGu1EU_nvm5-8_0xsG4ZT0PUyaWP8g/edit#gid=0";
  var ss =SpreadsheetApp.openByUrl(url);
  var ws=ss.getSheetByName("mentors");
 // var count=0;
  var assigned_mentor;
  var grpdepth=ws.getColumnGroupDepth(1);
  for(var i=0;i<4;i++)
    {
      for( var j=0;j<grpdepth;j++)
       { 
         var mentees =ws.getColumnGroup(1,grpdepth);
         if(mentees[j]==i)
          {
            assigned_mentor=ws.getColumnGroup(0,grpdepth)[j];
           ++mentees[j];
      
          }
  break;
      }
   
  }
   MailApp.sendEmail(email_id,"MENTOR ASSIGNED","you have been assigned "+assigned_mentor+" as your mentor");
  }
question from:https://stackoverflow.com/questions/65617498/cannot-read-property-getresponse-of-undefined-file-name

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...