问Google脚本-以编程方式从文件ID访问脚本ID

EN

function MyScriptID(){return ScriptApp.getScriptId()}

function FindScriptID() {


// Insert the ID of the sheet you want to retrieve the script Id from
    var sheet = SpreadsheetApp.openByUrl('your ID')

    // name the sheet where you want to insert the formula

    var destination = sheet.getSheetByName("mysheet");

    // Choose a cell to insert the formula - example: (4,2)

    destination.getRange(4, 2).setFormula('=MyScriptID()');

    SpreadsheetApp.flush();

    // get the displayed ID from the formula, which is actually the ID of the attached script

    var myscriptID = destination.getRange(4, 2).getDisplayValue();

    Logger.log(myscriptID)


// You can now write the ID of your script within the sheet you've ran the above function, choose a sheet where you wan to write the ID - e.g. Sheet1

   var currentsheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Sheet1');

//Choose a cell to write the link of you your script or just the ID

currentsheet.getRange(2, 2).setValue('https://script.google.com/a/ais.sch.sa/d/' + myscriptID + '/edit')


}