问谷歌应用脚本:创建唯一的RefNo，不能从受保护的工作表中正确写入递增的新refno，无法向RefNo添加前导零

EN

 function onSelect(event) {
 //This function creates a unique reference number
 //When a new support item is logged
 //It then stores the newest reference number on a locked sheet
 
  //Initialising Googlesheet
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  var s = event.source.getActiveSheet(); 
  var r = event.source.getActiveRange(); 
  var ws = ss.getSheetByName("Ticket");
  var wt = ss.getSheetByName("Ref");
  
  //Retrieves the row number that is being edited
  var rownum = r.getRow();
  //Initializing the first cell in the row to return its value 
  var data = ws.getRange(rownum,1).getValues();
  //Checks if the data in the cell is empty
  if(data == ""){
  //When the cell is empty it gets the latest Reference Number
  //Execute the GetLatest() Function
  var gl = GetLatest();
  // Increment the latest Reference Number by 1
  var newgl = gl + 1;
  //The new Reference number is now stored
  wt.getRange(1,1).setValue(newgl);
  // Creates the Reference Number that will be written in the Reference column on the Support Log
  // Execute NewRef() function
  var nr = NewRef();
  //Writes the new Reference number in the designated cell
  ws.getRange(rownum,1).setValue(nr);
  }
}

function GetLatest(){
// This function fetches the latest reference number stored
  
 //Initialising Googlesheet and cell with the value
var ss = SpreadsheetApp.getActive();
var ws = ss.getSheetByName("Ref");
var row = 1;
var col = 1;
// fetches the value
var value = ws.getRange(row, col).getValue();
return value;
}

function NewRef(){
 //This function creates the Reference number that the user sees on the Support Log
  
  //Initialising Googlesheet 
  var ss = SpreadsheetApp.getActive();
  var ws = ss.getSheetByName("Ref");
  //Fetches latest Reference number
  var lr = GetLatest();
  //Creates support log reference number
  var cnr =  "T" + lr;
  return cnr;
}