-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCode.gs
More file actions
23 lines (21 loc) · 763 Bytes
/
Code.gs
File metadata and controls
23 lines (21 loc) · 763 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
function doGet() {
return HtmlService.createTemplateFromFile('index').evaluate()
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
}
function processForm(formObject){
var ss= SpreadsheetApp.openById('154BLDK46dlyBfdub-6KsuXR53m1aVlbHPibrFWDBuMg');
var ws=ss.getSheets()[0]
ws.appendRow([
new Date(),
formObject.television,
formObject.radio,
formObject.newspaper,
formObject.sale,
formObject.name,
"'"+formObject.phone,
]);
var token = 'MCyjbEMZitgVE6aqoZoeWI7agLiYhXQsDxV4HLDsSpg'
var msg = 'Paithoon Financial Analyzer 2022 '+formObject.Sale +' '+formObject.name+'\n Tel Number '+formObject.phone
NotifyApp.sendNotify(token,msg)
}