-
Notifications
You must be signed in to change notification settings - Fork 0
/
Config.js
43 lines (31 loc) · 1.05 KB
/
Config.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
var ConfigScript = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
var Dept = "Afdeling";
var Post = "Package";
var Cost = "Cost Center";
var Fam = "Families";
var Script;
var FORM_LIST = ["req_NameBox",
"req_PhoneNumb",
"req_Dept",
"req_Pack",
"req_Charge2NANA",
"req_CostC",
"Opt_TxtArea",
"fam_NameBox",
"fam_PhoneNumb",
"fam_List"];
function OpenScript(){
Script = SpreadsheetApp.openById(ConfigScript);
}
function GetScriptDept(){
return(Script.getSheetByName(Dept).getDataRange().getValues());
}
function GetScriptPackages(){
return(Script.getSheetByName(Post).getDataRange().getValues());
}
function GetScriptCost(){
return(Script.getSheetByName(Cost).getDataRange().getValues());
}
function GetScriptFamilies(){
return(Script.getSheetByName(Fam).getDataRange().getValues());
}