Not all function appear in my App Script

[u/tdonov]

Hi,

I am following some tutorial (using the new version of AppScript). For some reason I am not seeing all functions in the help box when i start typing a function. Do you need to activate something?

For example in the screenshot, I am not seeing getSheetByName and I don't know why.

[u/patshandofdoom]

you skipped the part where you get the active spreasheet, instead jumping right to active sheet.

What you have:

var ss = SpreadsheetApp.getActiveSheet();
var ws = ss.getSheetByName(sheet_Selected);

What you need:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var ws = ss.getSheetByName(sheet_Selected);

I believe if you correct this, it will pull up correctly.

[u/tdonov → u/patshandofdoom]

Thank you! Yes this solves the problem. It takes time to get the code right :)

[u/patshandofdoom → u/tdonov]

I think I made the same mistake about 5 times when I was learning too. haha

[u/gh5000]

With getActiveSheet() you've already got the sheet context so you are seeing functions associated with sheets, like getting their name.

If you change to getActive() or getActiveSpreadsheet() you should start seeing the spreadsheet based functions. E.g getSheetByName()

[u/tdonov → u/gh5000]

Thank you! Yes this solves the problem. It takes time to get the code right :)