Search
 
SCRIPT & CODE EXAMPLE
 

JAVASCRIPT

Google Web App Script Unknown Parameter Error on Load

//From
function getData(){
  var spreadSheetId = "###"; //CHANGE
  var dataRange     = "Base Stats!A2:L"; //CHANGE
 
  var range   = Sheets.Spreadsheets.Values.get(spreadSheetId,dataRange);
  var values  = range.values;
 
  return values;
}

//To

function getData(){
  var spreadSheetId = "###"; // Please set your Spreadsheet ID.
  var sheet = SpreadsheetApp.openById(spreadSheetId).getSheetByName("Base Stats");
  var values = sheet.getRange("A2:L" + sheet.getLastRow()).getDisplayValues();
  return values;
}
Comment

PREVIOUS NEXT
Code Example
Javascript :: javascrript Wrap all individual words in a span tag based on their first letter 
Javascript :: javascript axios response.data.pipe not a function 
Javascript :: Angular /Javascript- How can I shrink Sticky header on scroll functionality 
Javascript :: Passing JSON to Javascript in Laravel – but JS is converting the JSON to HTML Entities 
Javascript :: Ant Media Filter Plugin for Text 
Javascript :: count object based on status and shop using javascript 
Javascript :: Display name instead ID modal dropdown in angularjs 
Javascript :: AngularJs: How to interpolate an interpolated string 
Javascript :: directive with ng-if not rendering in Angular.js 
Javascript :: angularjs How do I show all indicators for carousel in an ng-repeat 
Javascript :: set default value in dynamic dropdown angularjs 
Javascript :: I am getting an error "createSpyObj requires a non-empty array" with running unit tests, which were executed perfectly before 
Javascript :: How to add the items from a array of JSON objects to an array in Reducer 
Javascript :: wrapping a span tag with an a tag with a href target same as the text of the span 
Javascript :: on veiwport reveal javascript 
Javascript :: JavaScript delete atray item 
Javascript :: Transfer file to server using rsync 
Javascript :: open 2 links with one click html jquery 
Javascript :: javascript loop through collection of objects 
Javascript :: set of these properties: in js 
Javascript :: phaser asteroid movement 
Javascript :: string to date with ist javascript 
Javascript :: ngx chart how to use in angular 
Javascript :: confirming the end javascript 
Javascript :: 20 most common question in javascript 
Javascript :: Hardhat deploy sample js code 
Javascript :: json to dart dummy api 
Javascript :: js filter out html 
Javascript :: verify if user input is equal to javascript 
Javascript :: how to change array elements position in array in javascript 
ADD CONTENT
Topic
Content
Source link
Name
5+2 =