Google Apps Scripting Running a Script Based on a Variable

Question

Okay, I've been a coding for a little while and have had the chance to do a number of things.

One issue I'd like to find a more elegant way is running scripts based on the value of a variable.

At the moment I'm doing it like this.

    if (ScriptName == 'overnightRun' ) {
      overnightRun();
    } 
    if (ScriptName == 'resetAnalysisSheets' ) {
      resetAnalysisSheets();
    } 
    if (ScriptName == 'resetActiveSheetFormulae' ) {
      resetActiveSheetFormulae();
    } 
    if (ScriptName == 'saveRemainingContractSheets' ) {
      saveRemainingContractSheets();
    } 
    if (ScriptName == 'saveAllContractSheets' ) {
      saveAllContractSheets();
    } 
    if (ScriptName == 'saveCurrentContractSheet' ) {
      saveCurrentContractSheet();
    } 
    if (ScriptName == 'clearDataSheets' ) {
      clearDataSheets();
    }

Surely there must be a better way. Something more like this.

    run.script(ScriptName);

Anyone any ideas? Thanks for reading!

ADW · Accepted Answer · 2020-01-14 12:42:28Z

2

You could try this:

function testFunction() {
  var ScriptName = "Alibaba";
  var p = "Open sesame!"
  this[ScriptName](p);
}

function Alibaba(p) {
  Logger.log(p);
}

Leave the parameter p blank if nothing is to be passed.

answered Jan 14, 2020 at 12:42

ADW

4,2471 gold badge17 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ADW Over a year ago

Super! You may want to accept the anwer

Rad Wagon Over a year ago

Thanks, I've just done that. Working out my way around Stack Overflow as well ;-)

Collectives™ on Stack Overflow

Google Apps Scripting Running a Script Based on a Variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related