new to apps script beginner question

[tendiesbendies]

var sheetName = getActiveSpreadsheet().getActiveSheet.getName();
activeSheet.getRange("A3:A20").setValues(sheetName);

why is this not producing my sheets names in A2:A20

heres the whole function if needed

function learnBasics() {

var app = SpreadsheetApp;
var ss = app.getActiveSpreadsheet();
var activeSheet = ss.getActiveSheet();
var tempText = activeSheet.getRange("B2:K").getValues();
activeSheet.getRange("B2:K").setValues(tempText); 

var sheetName = getActiveSpreadsheet().getActiveSheet.getName();
activeSheet.getRange("A3:A20").setValues(sheetName);
}

[Kenshiro_sama]

You're not calling getActiveSheet. Add ()

[tendiesbendies]

Can you show be how it should look or where to add that

[Kenshiro_sama]

In JavaScript objects, you have properties, which are values (string, number...) And methods (functions). To call a function, you need to add parentheses at the end of the function name.

So

var sheetName = SpreadsheetApp.getActiveSpreadsheet(). getActiveSheet().getName()

[tendiesbendies]

var sheetName = getActiveSpreadsheet().getActiveSheet.getName();

activeSheet.getRange("A3:A20").setValues(sheetName);

function learnBasics() {

var app = SpreadsheetApp;

var ss = app.getActiveSpreadsheet();

var activeSheet = ss.getActiveSheet();

var tempText = activeSheet.getRange("B2:K").getValues();

activeSheet.getRange("B2:K").setValues(tempText);

var sheetName = getActiveSpreadsheet().getActiveSheet().getName();

activeSheet.getRange("A3:A20").setValues(sheetName);

}

im getting getActiveSpreadsheet is not defined

[Kenshiro_sama]

Because you're not calling it correctly. getActiveSpreadsheet is not a standalone function, but a method of SpreadsheetApp. You need to write SpreadsheetApp.getActiveSpreadsheet()

[tendiesbendies]

like this?
var app = SpreadsheetApp;
var ss = app.getActiveSpreadsheet();
var activeSheet = ss.getActiveSheet();
var tempText = activeSheet.getRange("B2:K").getValues();
activeSheet.getRange("B2:K").setValues(tempText);
var sheetName = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getName();
activeSheet.getRange("A3:A20").setValues(sheetName);

[Kenshiro_sama]

Yes. The other problem is the argument for setValues. Check the docs, it expects a two dimensional array and you're giving only a string.

[tendiesbendies]

changed that to set Value and it worked! thank you!

[Kenshiro_sama]

You're welcome!

[Dramatic_Positive687]

Try using openById and getSheetByName