I'm having an issue. Whenever I create a new spreadsheet, I'm not able to add a script I've already created. The list for recent projects or scripts is always blank. Anyone have a resolution or do I always have to copy the script code and insert it into the spreadsheet?
1 Answer
You can add your script as a library in the new spreadsheet. Lets start from the beginning. This sample code will add a string to the active cell:
function libTest(text) {
var sh = SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet().getActiveCell();
sh.setValue(text);
}
Save the script, by creating a version:
Next, copy the Project Key from the script editor:
Publish the script as a web app (execute only you):
In the new spreadsheet, open the script editor. Chose Manage Libraries from the resources option and enter and select the key/library:
In the script editor you can now add the following code:
function test(){
libTest.libTest("jacobjan");
}
-
1