Google Apps Script for Spreadsheet - Keep getting the function () { [native code] } error

user_16694557 0
Viewed 147

I execute my function, and it returns a function () { [native code] } error alongside the proper outputs. Example: Input Output

My code:

function SubmitInput() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var inputS = ss.getSheetByName("FORM");
  var outputS = ss.getSheetByName("ARCHIVE")

  var values = [[inputS.getRange("C7").getValue,
                inputS.getRange("C9").getValue(),
                inputS.getRange("C11").getValue(),
                inputS.getRange("F7").getValue(),
                inputS.getRange("F9").getValue(),
                inputS.getRange("F11").getValue(),
                inputS.getRange("I7").getValue(),
                inputS.getRange("I9").getValue()]];
 outputS.getRange(outputS.getLastRow()+1, 1, 1, 8).setValues(values);
 ClearCell();
}

google-apps-script google-sheets javascript
1 Answers

you have a typo in your code

inputS.getRange("C7").getValue,¸

should be

inputS.getRange("C7").getValue(),¸
user_4315020
Related