javascript - Defining globals in Google Apps Script that can be used across multiple projects - Stack Overflow

admin管理员组

文章数量:1333706

I have about 15-20 Google Apps Script projects which all use the same list of global variables.

What I've done is defined all of the globals at the top of the first script file in the project, and then copied and pasted the block of code to the same spot in each project. So if I make a change in one, I copy and paste the entire thing from that one to the rest of them. It gets time-consuming.

Is there a better way to do this? Is it using Libraries? Does anyone use Libraries for defining globals across projects?

I have about 15-20 Google Apps Script projects which all use the same list of global variables.

What I've done is defined all of the globals at the top of the first script file in the project, and then copied and pasted the block of code to the same spot in each project. So if I make a change in one, I copy and paste the entire thing from that one to the rest of them. It gets time-consuming.

Is there a better way to do this? Is it using Libraries? Does anyone use Libraries for defining globals across projects?

• javascript
• google-apps-script
• global-variables
• libraries

Share Improve this question Follow edited Sep 8, 2017 at 0:06 Employee asked Oct 8, 2014 at 23:18 EmployeeEmployee 2,41133 gold badges3737 silver badges6565 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 8

Using a library for shared constants is the most effective way to share constant objects between Google Apps Scripts. Some caveats:

• All scripts using the ConstLib will need to do so with "Development Mode" ON, otherwise you'll still need to update each of them manually. (Risk: save a buggy version of ConstLib and all your scripts will immediately break.)

• The constants are attributes of the library, so will need to be referenced using the library name, e.g.

  var log = SpreadsheetApp.openById( ConstLib.auditLogId );
  

  In your existing scripts, you may find it convenient to change your block of existing constants into references to the ConstLib, so you won't need to touch the remaining code. e.g.

  var auditLogId = ConstLib.auditLogId;
     . . .
  var log = SpreadsheetApp.openById( auditLogId );
  

Example

ConstLib

var roses = "Red", violets = "Blue";

Use Constlib

function myFunction() {
  Logger.log(ConstLib.roses);
  Logger.log(ConstLib.violets);
}

Logging Output

[14-10-09 14:51:47:258 EDT] Red
[14-10-09 14:51:47:259 EDT] Blue

本文标签： javascriptDefining globals in Google Apps Script that can be used across multiple projectsStack Overflow