2019-06-03
Note that Office2019 DO NOT support activate via simple copy/paste plist license file which is the simplest way to activate Office 2016. Fortunately, you can also use the VL Serializer tool, just install Office 2019 and Serializer, then run Serializer to activate.
| function main() { | |
| var groupName = "YOUR_UNIQUE_GROUP_NAME_HERE"; // TODO: Specify the name of the group | |
| var message = "Guys, lets party tonight!"; // TODO: Specify the content of your message | |
| sendTelegramGroup(groupName, message); | |
| } | |
| function sendTelegramGroup(groupName, message) { | |
| var instanceId = "YOUR_INSTANCE_ID_HERE"; // TODO: Replace it with your gateway instance ID here | |
| var clientId = "YOUR_CLIENT_ID_HERE"; // TODO: Replace it with your Premium client ID here |
| function doGet(e){ | |
| Logger.log(e); | |
| var op = e.parameter.action; | |
| var ss=SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1UUBGKGvm4b9LOhqbdh0UDG6vYz9Phr1DqGyg8DvCiUc/edit?usp=sharing"); | |
| var sheet = ss.getSheetByName("Sheet1"); | |
| if(op=="insert") | |
| return insert_value(e,sheet); |
| function sync() { | |
| var id="XXXXXXXXXX"; // CHANGE - id of the secondary calendar to pull events from | |
| var today=new Date(); | |
| var enddate=new Date(); | |
| enddate.setDate(today.getDate()+7); // how many days in advance to monitor and block off time | |
| var secondaryCal=CalendarApp.getCalendarById(id); | |
| var secondaryEvents=secondaryCal.getEvents(today,enddate); |
| // Room Reservation System Video | |
| // Kurt Kaiser, 2018 | |
| // All rights reserved | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var sheet = ss.getSheets()[0]; | |
| var lastRow = sheet.getLastRow(); | |
| var lastColumn = sheet.getLastColumn(); | |
| // Calendars to output appointments to |
| //********************************************************************************************************* | |
| //makeTodo: Call other functions to make the daily Todo | |
| //********************************************************************************************************* | |
| function makeTodo(){ | |
| //Populate Header | |
| grabHeader("B1") | |
| //Populate Task List |
| /** Returns a PDF object based on the contents of the 'invoicing' sheet */ | |
| function invoiceToPDF(invDetails) | |
| { | |
| var spreadsheet = SpreadsheetApp.getActiveSpreadsheet(); | |
| ssID = spreadsheet.getId(); | |
| var sheet = spreadsheet.getSheetByName(INVOICES_SHEETNAME); | |
| var gid = sheet.getSheetId(); | |
| // &gid=x at the end of above url if you only want a particular sheet | |
| var url2 = "http://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=" + ssID + |
| /* | |
| - send an email with a PDF invoice generated from a google spreadsheet | |
| - spreadsheet "inputs" : list all your customers/sells by row | |
| - spreadsheet "facture" : the invoice model | |
| It just read and write cells ranges or named cells | |
| Finally it generates a PDF link but i didnt manage to remove the cells borders | |
| */ |
| <div style="font-family: sans-serif;"> | |
| <? var data = valid(); ?> | |
| <form id="form" name="form"> | |
| <? if(Object.prototype.toString.call(data) === '[object Array]') { ?> | |
| <? for (var i = 0; i < data.length; i++) { ?> | |
| <? for (var j = 0; j < data[i].length; j++) { ?> | |
| <input type="checkbox" id="ch<?= '' + i + j ?>" name="ch<?= '' + i + j ?>" value="<?= data[i][j] ?>"><?= data[i][j] ?><br> | |
| <? } ?> | |
| <? } ?> | |
| <? } else { ?> |
Head over to developer.facebook.com and create an App
On your server, create a facebook webhook that will handle facebook calls. Then create a "leadgen" webhook on you App: https://developers.facebook.com/docs/graph-api/webhooks/v2.5