OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Error while running app script to store responses in multiple spreadsheets [duplicate]

  • Thread starter Thread starter Taher Rajkotwala
  • Start date Start date
T

Taher Rajkotwala

Guest
I am trying to run a appscript code for storing google form responses into multiple spreadsheets. This code is executed through on submit form trigger. I am getting the below error in the execution log.

Error Screenshot


Here is the code:

Code:
function copyFormResponses(e)
{
  let ss = SpreadsheetApp.openByUrl("Sheet_URL").getSheetByName("SheetName");
  let range = e.range;
  let values = e.values;
  let lastRow = ss.getLastRow();
  for(let i=1; i<=values.length; i++)
  {
      ss.getRange(lastRow+1,i).setValue(values[i-1]);
  }
}

Tried to run this script trough a trigger, but getting an error. Expectation was to store google form responses into multiple spreadsheets

Code:
type here

Continue reading...
 

Latest posts

B
Replies
0
Views
1
Blundering Ecologist
B
Top