Library GAS SCRIPT

Function RefreshBsurvey [Library.gs]

Function calls refreshBsurvey function [Survey Component]

function refreshBsurvey() {
    LM.refreshBsurvey(key);
}

• RefreshBsurvey function()

Function clearTaskHistory [Library.gs]

Function calls clearTaskHistory function [GENERAL Component]

function clearTaskHistory() {
    LM.clearTaskHistory();
}

• clearTaskHistory function()

Function CLEARLOGHISTORY [Library.gs]

Function calls CLEARLOGHISTORY function [GENERAL Component]

function clearLogHistory() {
    LM.clearLogHistory();
}

• CLEARLOGHISTORY function()

Function updateEmailAddress [Library.gs]

Function calls updateEmailAddress function [COMMON Component]

function updateEmailAddress() {
    Keys.setProperties(LM.updateEmailAddress(key));
}

• updateEmailAddress function()

Function getListEmail [Library.gs]

Function calls getListEmail function [COMMON Component]

function getListEmail() {
    Keys.setProperties(LM.getListEmail(key));
}

• getListEmail function()

Function sendReminder [Library.gs]

Function calls sendReminder function [FOLLOWUP Component]

function sendReminder() {
    Keys.setProperties(LM.sendReminder(key));
}

• sendReminder function()

Function deleteDataDupDetectorSheet [Library.gs]

Function calls deleteDataDupDetectorSheet function [KOBOUP Component]

    LM.deleteDataDupDetectorSheet(key);
}

• deleteDataDupDetectorSheet function()

Function findDuplication [Library.gs]

Function calls findDuplication function [KOBOUP Component]

    LM.findDuplication();
}

• findDuplication function()

Function queryDataDupSheet [Library.gs]

Function calls queryDataDupSheet function [KOBOUP Component]

function queryDataDupSheet() {
    LM.queryDataDupSheet(key);
}

• queryDataDupSheet function()

Function clearDupDetectorSheet [Library.gs]

Function calls clearDupDetectorSheet function [KOBOUP Component]

function clearDupDetectorSheet() {
    LM.clearDupDetectorSheet();
}

• clearDupDetectorSheet function()

Function deleteDataKoboupSheet [Library.gs]

Function calls deleteDataKoboupSheet function [KOBOUP Component]

function deleteDataKoboupSheet() {
    LM.deleteDataKoboupSheet(key);
}

• deleteDataKoboupSheet function()

Function createXML [Library.gs]

Function calls createXML function [KOBOUP Component]

function createXML() {
    LM.createXML(key);
}

Function queryDataKoboupSheet [Library.gs]

Function calls queryDataKoboupSheet function [KOBOUP Component]

function queryDataKoboupSheet() {
    LM.queryDataKoboupSheet(key);
}

Function clearKoboSheet [Library.gs]

Function calls clearKoboSheet function [KOBOUP Component]

function clearKoboSheet() {
    LM.clearKoboSheet();
}

Function deleteDataDupDetectorSheet2018 [Library.gs]

Function calls deleteDataDupDetectorSheet2018 function [KOBOUP Component]

    function deleteDataDupDetectorSheet2018() {
        LM.deleteDataDupDetectorSheet2018(key);
    }

Function createXML_2018 [Library.gs]

Function calls createXML_2018 function [KOBOUP Component]

    function createXML_2018() {
        LM.createXML_2018(key);
    }

Function queryDataKoboupSheet_2018 [Library.gs]

Function calls queryDataKoboupSheet_2018 function [KOBOUP Component]

    function queryDataKoboupSheet2018() {
        LM.queryDataKoboupSheet2018(key);
    }

Function clearKoboupSheet2018 [Library.gs]

Function calls clearKoboupSheet2018 function [KOBOUP Component]

    function clearKoboupSheet2018() {
        LM.clearKoboupSheet2018();
    }

Function DELETEALLKEY [Library.gs]

Function deletes all the properties

function DELETEALLKEY() {    
    Keys.deleteAllProperties();
}

Function setApiSettings [Library.gs]

Function calls setApiSettings function [PARAMETORS Component]

function setApiSettings() {
    Keys.setProperties(LM.setApiSettings(key));
}

• setApiSettings function()

Function displayKeyListing [Library.gs]

Function calls displayKeyListing function [PARAMETORS Component]

function displayKeyListing() {
    var k = Keys.getKeys();
    Keys.setProperties(LM.displayKeyListing(key, k));
}

• displayKeyListing function()

Function setKey [Library.gs]

Function calls setKey function [PARAMETORS Component]

function setKey() {
    Keys.setProperties(LM.setKey(key));
}

• setKey function()

Function deleteKey [Library.gs]

Function calls deleteKey function [PARAMETORS Component]

function deleteKey() {
    var data = LM.deleteKey();
    for (i = 0; i < data.length; i++) {
        if (data[i][0] != "") {
            Keys.deleteProperty([data[i][0]]);
        }
    }
}

• deleteKey function()

Function displayEmailQuota [Library.gs]

Function calls displayEmailQuota function [PARAMETORS Component]

function displayEmailQuota() {
    LM.displayEmailQuota();
}

• displayEmailQuota function()

Function DELETETRIGGER [Library.gs]

Function calls DELETETRIGGER function [TRIGGERS Component]

function DELETETRIGGER() {
    Keys.setProperties(LM.DELETETRIGGER(key));
}

• DELETETRIGGER function()

Function changeEmailConfig [Library.gs]

Function calls changeEmailConfig function [GENERAL Component]

function changeEmailConfig() {
    Keys.setProperties(LM.changeEmailConfig(key));
}

• changeEmailConfig function()

Function triggerAction4Hours [Library.gs]

Function calls triggerAction4Hours function [TRIGGERS Component]

function triggerAction4Hours() {
    var verify = LM.getData("TASKS");
    if (verify[verify.length - 1][0] == "") {
        Browser.msgBox("To refresh, currently pending tasks must be completed first. Try again later.");
        return;
    }
    Keys.setProperties(LM.synchronizeAllForms(key));
    Keys.setProperties(LM.updateOnCustomisation(null, key));
  
}

• triggerAction4Hours function()

Function triggerExecuteTask5Minutes [Library.gs]

Function calls triggerExecuteTask5Minutes function [TRIGGERS Component]

function triggerExecuteTask5Minutes() {
    var sheet = ss.getSheetByName("CONTROL");
    var tasknumber = sheet.getRange(5, 1).getValue();
    if (tasknumber > 0) {
        var keyinputs2 = LM.excuteAllTask(key);
        if (keyinputs2 != "NA") {
            Keys.setProperties(keyinputs2);
        }
    }
}

• triggerExecuteTask5Minutes function()

Function triggerActionDaily [Library.gs]

Function calls triggerActionDaily function [TRIGGERS Component]

function triggerActionDaily() {
    Keys.setProperties(LM.updateDataHarmonizeDatabridge(key));
    Keys.setProperties(LM.createPdfTemplateAll(key));
}

• triggerActionDaily function()

Function scheduleReminder [Library.gs]

Function calls scheduleReminder function [GENERAL Component]

function scheduleReminder() {
    LM.scheduleTask("REMINDER");
}

• scheduleReminder function()

Function Resetemail [Library.gs]

Function calls Resetemail function [TRIGGERS Component]

function showSidebar() {
    var html = HtmlService.createHtmlOutputFromFile('PAGE')
        .setTitle('MANUAL TASK MENU');
    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
        .showSidebar(html);
}

• Resetemail function()

Function showSidebar [Library.gs]

Function opens the sidebar

}

function scheduleReminder() {
    LM.scheduleTask("REMINDER");
}

function Resetemail() {
    LM.Resetemail();
}

function showSidebar() {
    var html = HtmlService.createHtmlOutputFromFile('PAGE')
        .setTitle('MANUAL TASK MENU');
    SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
        .showSidebar(html);
}

Function updateScriptChild [Library.gs]

Function updats the background script

function updateScriptChild() {
    var r = Browser.msgBox("This will make the background script up to date. Please make sure that this spreadsheet is shared for editing while taking this action. You want to proceed?", Browser.Buttons.YES_NO);
    if (r == "no") { return; }
    var id = ScriptApp.getScriptId();
    Logger.log(id); return;
    var result = LM.updateScriptChild(id);
    if (result == 1) { Browser.msgBox("Update completed. Please reload the spreadsheet."); } else { Browser.msgBox("It failed the update. Please check the access permission and contact the administrator."); }
}