GAS have too many bugs with run scripts

Question

I have many problems with run of scripts. It sometimes skip some rows of code (that result of code unexpected)
If it skip it, it won`t call about error in run archive

GAS do it in any of my script ever.

That example of my code:

function onOpen() {

  var ui = SpreadsheetApp.getUi();  // Or DocumentApp or FormApp.

   ui.createMenu('Create new list from template')

      .addItem('template 1', 'menuItem1')

      .addItem('template 2', 'menuItem2')

      .addToUi();

}

function menuItem1() {
 var spreadsheet = SpreadsheetApp.getActive();
 spreadsheet.setActiveSheet(spreadsheet.getSheetByName('emplate 1'), true);
 spreadsheet.duplicateActiveSheet(); // it can skip it (script will brake my template list)
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var sheet = ss.getSheets().length;
 spreadsheet.moveActiveSheet(sheet);
 spreadsheet.getActiveSheet().setName("yyyy-MM-dd "+(sheet)); // it can skip it (name won`t set)
 spreadsheet.setActiveSheet(spreadsheet.getSheetByName('template 1'), true);  // it can skip it (next code row will used on wrong list)
 spreadsheet.getActiveSheet().hideSheet(); // it can skip it (it won`t hided)
} 
...

I have an idea, that this trouble is appear of JS async working. I met that problem in another code and language with no promise system. It was a problem, that script don't wait self previous row. Its cool that JS is async, but I dont how it work in GAS.

there is In script GAS`s IDE "asyinc ... await" schema instructed "unnecessary". Another my try:screen of message from GAS IDE

Please, help me to stabilize my scripts

Thank you very match! An another errors: is it "emplate 1"? or another? — Daniil Levitskiy, Jul 06 '22 at 14:15
`var sheet = ss.getSheets().length;`. `sheet` is a number not a sheet. `var numberOfSheets = ss.getSheets().length;` — TheMaster, Jul 06 '22 at 14:17
O, thank you. It my naming mystake. I'm only one who work with it, but you are right that it bednaming. It my first question in Stackoverlow. I didnt expect, that I will get answer so fast! Thank you another time. ) — Daniil Levitskiy, Jul 06 '22 at 14:32

GAS have too many bugs with run scripts

0 Answers0