Library GAS SCRIPT [Energy]

Function RefreshBsurvey [Energy > Library.gs]

Function calls refreshBsurvey function [Survey Component]

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

• Energy > Survey Component > RefreshBsurvey function()

Function clearTaskHistory [Energy > Library.gs]

Function calls clearTaskHistory function [GENERAL Component]

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

• Energy > GENERAL Component > CLEARHISTORY function()

Function CLEARLOGHISTORY [Energy > Library.gs]

Function calls CLEARLOGHISTORY function [GENERAL Component]

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

• Energy > GENERAL Component > CLEARLOGHISTORY function()

Function updateEmailAddress [Energy > Library.gs]

Function calls updateEmailAddress function [FOLLOWUP Component]

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

• Energy > FOLLOWUP Component > updateEmailAddress function()

Function getListEmail [Energy > Library.gs]

Function calls getListEmail function [FOLLOWUP Component]

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

• Energy > FOLLOWUP Component > getListEmail function()

Function sendReminder [Energy > Library.gs]

Function calls sendReminder function [FOLLOWUP Component]

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

• Energy > FOLLOWUP Component > sendReminder function()

Function deleteDataDupDetectorSheet [Energy > Library.gs]

Function calls deleteDataDupDetectorSheet function [KOBOUP Component]

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

• Energy > KOBOUP Component > deleteDataDupDetectorSheet function()

Function findDuplication [Energy > Library.gs]

Function calls findDuplication function [KOBOUP Component]

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

• Energy > KOBOUP Component > findDuplication function()

Function queryDataDupSheet [Energy > Library.gs]

Function calls queryDataDupSheet function [KOBOUP Component]

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

• Energy > KOBOUP Component > queryDataDupSheet function()

Function clearDupDetectorSheet [Energy > Library.gs]

Function calls clearDupDetectorSheet function [KOBOUP Component]

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

• Energy > KOBOUP Component > clearDupDetectorSheet function()

Function deleteDataKoboupSheet [Energy > Library.gs]

Function calls deleteDataKoboupSheet function [KOBOUP Component]

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

• Energy > KOBOUP Component > deleteDataKoboupSheet function()

Function createXML [Energy > Library.gs]

Function calls createXML function [KOBOUP Component]

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

Function queryDataKoboupSheet [Energy > Library.gs]

Function calls queryDataKoboupSheet function [KOBOUP Component]

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

• Energy > KOBOUP Component > queryDataKoboupSheet function()

Function clearKoboupSheet [Energy > Library.gs]

Function calls clearKoboupSheet function [KOBOUP Component]

}

function clearKoboSheet() {

• Energy > KOBOUP Component > clearKoboupSheet function()

Function DELETEALLKEY [Energy > Library.gs]

Function deletes all the properties

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

Function setApiSettings [Energy > Library.gs]

Function calls setApiSettings function [PARAMETORS Component]

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

• Livelihoods > PARAMETORS Component > setApiSettings function()

Function displayKeyListing [Energy > Library.gs]

Function calls displayKeyListing function [PARAMETORS Component]

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

• Livelihoods > PARAMETORS Component > displayKeyListing function()

Function setKey [Energy > Library.gs]

Function calls setKey function [PARAMETORS Component]

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

• setKey function()

Function deleteKey [Energy > 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 [Energy > Library.gs]

Function calls displayEmailQuota function [PARAMETORS Component]

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

• displayEmailQuota function()

Function DELETETRIGGER [Energy > Library.gs]

Function calls DELETETRIGGER function [TRIGGERS Component]

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

• DELETETRIGGER function()

Function changeEmailConfig [Energy > Library.gs]

Function calls changeEmailConfig function [GENERAL Component]

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

• changeEmailConfig function()

Function triggerAction4Hours [Energy > 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 [Energy > 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 [Energy > Library.gs]

Function calls triggerActionDaily function [TRIGGERS Component]

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

• triggerActionDaily function()

Function scheduleReminder [Energy > Library.gs]

Function calls scheduleReminder function [GENERAL Component]

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

• scheduleReminder function()

Function Resetemail [Energy > 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 [Energy > 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 [Energy > 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."); }
}