How to do automatic sorting in Google Sheets?

Question

Google Apps Script

In my table, the entry form is at the top, and at the bottom is what a person fills out in this form. Now I have sorting through the "on change" trigger and it doesn't work very well. How can I make it so that when I enter a new order, sorting is enabled for me?

function sort(){
  
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var as2 = ss.getSheetByName("02") //лист 2
  
  var editedCell = ss.getActiveRange().getValue();
  var cell2 = as2.getRange("B7:B").getValues()

  if(editedCell!=cell2  ){ //лист 2
  as2.getRange('A7:P').sort([{column: 2, ascending: true}]); 
  }
}

Answer 1

Issue resolved
var ss = SpreadsheetApp.getActiveSpreadsheet();- replace with

var ss = SpreadsheetApp.openById( "тут ваш id таблицы");