-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathCode.gs
More file actions
80 lines (65 loc) · 2.06 KB
/
Copy pathCode.gs
File metadata and controls
80 lines (65 loc) · 2.06 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
67
68
69
70
71
72
73
74
75
76
77
78
79
/**
* @OnlyCurrentDoc
*/
// [START apps_script_forms_telegram_bot_notifications]
function onOpen(e) {
FormApp.getUi()
.createAddonMenu()
.addItem('Configure notifications', 'showSidebar')
.addToUi();
}
function onInstall(e) {
onOpen(e);
}
function showSidebar() {
var ui = HtmlService.createHtmlOutputFromFile('Sidebar')
.setTitle('Telegram Bot Notifications');
FormApp.getUi().showSidebar(ui);
}
function saveSettings(settings) {
PropertiesService.getDocumentProperties().setProperties(settings);
adjustFormSubmitTrigger();
}
function getSettings() {
return PropertiesService.getDocumentProperties().getProperties();
}
function adjustFormSubmitTrigger() {
var form = FormApp.getActiveForm();
var triggers = ScriptApp.getUserTriggers(form);
var existingTrigger = null;
for (var i = 0; i < triggers.length; i++) {
if (triggers[i].getEventType() == ScriptApp.EventType.ON_FORM_SUBMIT) {
existingTrigger = triggers[i];
break;
}
}
if (!existingTrigger) {
var trigger = ScriptApp.newTrigger('respondToFormSubmit')
.forForm(form)
.onFormSubmit()
.create();
}
}
function respondToFormSubmit(e) {
var settings = PropertiesService.getDocumentProperties();
var form = FormApp.getActiveForm();
var responses = e.response.getItemResponses();
var message = settings.getProperty('message');
var botApiToken = settings.getProperty('botApiToken');
var chatId = settings.getProperty('chatId');
if (botApiToken === '' || chatId === '') {
return;
}
for (var i = 0; i < responses.length; i++) {
var response = responses[i];
var name = response.getItem().getTitle();
var value = response.getResponse();
var search = ('{' + name + '}').replace(/[.*+?^${}()|[\]\\]/g, '\\$&');
message = message.replace(new RegExp(search, 'g'), value);
}
var url = 'https://api.telegram.org/bot' + botApiToken
+ '/sendMessage?chat_id=' + chatId
+ '&text=' + encodeURIComponent(message)
UrlFetchApp.fetch(url);
}
// [END apps_script_forms_telegram_bot_notifications]