{"id":274,"date":"2025-12-08T11:14:53","date_gmt":"2025-12-08T09:14:53","guid":{"rendered":"https:\/\/maratsaukans23.thkit.ee\/vp\/?page_id=274"},"modified":"2025-12-09T09:31:59","modified_gmt":"2025-12-09T07:31:59","slug":"google-apps-scripts","status":"publish","type":"page","link":"https:\/\/maratsaukans23.thkit.ee\/vp\/google-apps-scripts\/","title":{"rendered":"Google Apps Scripts"},"content":{"rendered":"\n
    \n
  1. Loo Google’i vorm koodi abil<\/strong><\/li>\n<\/ol>\n\n\n\n

    Google Apps Scripti abil saate luua Google’i vormi, mille saate kohe avaldada. Koodi sees saate kirjutada k\u00fcsimusi v\u00f5i vastuseid, mis kuvatakse vormil.
    Siin on n\u00e4ide sellest, mida saab luua:
    <\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n

    function createAndPublishForm() {
    \n const form = FormApp.create(‘\u0410\u043d\u043a\u0435\u0442\u0430 \u043e\u0431\u0440\u0430\u0442\u043d\u043e\u0439 \u0441\u0432\u044f\u0437\u0438’);<\/p>\n

    form.addMultipleChoiceItem()
    \n .setTitle(‘\u041d\u0430\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u044b \u0434\u043e\u0432\u043e\u043b\u044c\u043d\u044b \u0441\u0435\u0440\u0432\u0438\u0441\u043e\u043c?’)
    \n .setChoiceValues([‘\u041e\u0447\u0435\u043d\u044c \u0434\u043e\u0432\u043e\u043b\u0435\u043d’, ‘\u0414\u043e\u0432\u043e\u043b\u0435\u043d’, ‘\u041d\u0435\u0439\u0442\u0440\u0430\u043b\u044c\u043d\u043e’, ‘\u041d\u0435\u0434\u043e\u0432\u043e\u043b\u0435\u043d’, ‘\u041e\u0447\u0435\u043d\u044c \u043d\u0435\u0434\u043e\u0432\u043e\u043b\u0435\u043d’])
    \n .setRequired(true);<\/p>\n

    form.addParagraphTextItem()
    \n .setTitle(‘\u0412\u0430\u0448\u0438 \u043a\u043e\u043c\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0438 (\u043d\u0435\u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e)’);<\/p>\n

    form.setPublished(true);<\/p>\n

    Logger.log(‘URL \u0434\u043b\u044f \u0440\u0435\u0434\u0430\u043a\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f: ‘ + form.getEditUrl());
    \n Logger.log(‘\u041f\u0443\u0431\u043b\u0438\u0447\u043d\u044b\u0439 URL \u0444\u043e\u0440\u043c\u044b: ‘ + form.getPublishedUrl());
    \n}<\/p>\n\n\n\n

    2. Kalendris\u00fcndmuste s\u00fcnkroonimine<\/strong><\/p>\n\n\n\n

    Selle funktsiooniga saate luua tabeli, mis koostatakse Google Calendari abil ja vaatab teie plaanitut ning sellisel funktsioonil v\u00f5ib olla palju \u00fclesandeid.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n

    function syncCalendarEvents() {
    \n const calendar = CalendarApp.getDefaultCalendar();
    \n const now = new Date();
    \n const nextMonth = new Date(now.getFullYear(), now.getMonth() + 1, now.getDate());
    \n const events = calendar.getEvents(now, nextMonth);<\/p>\n

    const ss = SpreadsheetApp.getActiveSpreadsheet();
    \n let sheet = ss.getSheetByName(‘Events’);
    \n if (!sheet) {
    \n sheet = ss.insertSheet(‘Events’);
    \n }
    \n sheet.clearContents();
    \n sheet.appendRow([‘\u041d\u0430\u0437\u0432\u0430\u043d\u0438\u0435’, ‘\u041d\u0430\u0447\u0430\u043b\u043e’, ‘\u041a\u043e\u043d\u0435\u0446’, ‘\u0422\u0438\u043f’]);<\/p>\n

    events.forEach(evt => {
    \n const type = evt.getEventType();
    \n if (type === CalendarApp.EventType.DEFAULT) {
    \n sheet.appendRow([evt.getTitle(), evt.getStartTime(), evt.getEndTime(), type]);
    \n }
    \n });<\/p>\n\n\n\n

    3. S\u00f5numi saatmine rakenduste skripti kaudu<\/strong><\/p>\n\n\n\n

    Selle funktsiooni abil saate luua e-kirja ja lisada sinna k\u00f5ike, mida soovite.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n

    function sendEmailWithButton() {
    \n const html = HtmlService.createHtmlOutput(
    \n ‘<\/p>\n

    \u041f\u0440\u0438\u0432\u0435\u0442!<\/h3>\n

    \u041d\u0430\u0436\u043c\u0438 \u043d\u0430 \u043a\u043d\u043e\u043f\u043a\u0443 \u043d\u0438\u0436\u0435:<\/p>\n

    ‘ +
    \n ‘