-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathlibrary.js
More file actions
66 lines (62 loc) · 1.94 KB
/
library.js
File metadata and controls
66 lines (62 loc) · 1.94 KB
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
/**
* Set language.
*
* ex. ```library___setLanguage("en");```
*
* @params {string} Language code.
*/
function library__setLanguage(lang) {
setLanguage(lang);
}
/**
* Make new 'Form List' sheet into current spreadsheet, which can manage forms.
* (User needs edit permission to the spreadsheet)
*
* ex. ```library__registerFormListSheet_asCurrentSpreadsheet(name);```
*
* @params {string} Name of sheet
*/
function library__registerFormListSheet_asActiveSpreadsheet() {
setup(SpreadsheetApp.getActiveSpreadsheet());
}
/**
* Register spreadsheet to write system logs.
* Current spreadsheet will be automatically detected and registered.
* (User needs edit permission to the spreadsheet)
*
* ex. ```library__registerLogSheet_asActiveSpreadsheet();```
*
* Note. You may register external spreadsheet with `library__registerLogSheet_byUrl`.
*/
function library__registerLogSheet_asActiveSpreadsheet() {
setLogSheet(SpreadsheetApp.getActiveSpreadsheet());
}
/**
* Register spreadsheet to write system logs.
* Spreadsheet of written url will be used as log sheet.
* (User needs edit permission to the spreadsheet)
*
* ex. ```library__registerLogSheet_byUrl("https://docs.google.com/spreadsheets/d/1q2w3e4r/edit");```
*
* Note. You may automatically detect and register current spreadsheet with `library__registerLogSheet_asActiveSpreadsheet`.
*
* @param {string} url The url of spreadsheet
* @param {string} name The name of log sheet
*/
function library__registerLogSheet_byUrl(url) {
try {
setLogSheet(SpreadsheetApp.openByUrl(url));
} catch (err) {
throw new Error(getTranslation('library.invalidLogsheetUrl', err));
}
}
/**
* Delete all responses from every registered forms.
* Useful when you use with time-based trigger, if you need to reset the responses per period.
* (User needs edit permission to every forms)
*
* ex. ```library__resetAllResponses();```
*/
function library__resetAllResponses() {
reset();
}