Running Multiple Functions in Google Apps Script

Question

I am right now working on a project with a sheet with multiple tabs in it. I am trying to get multiple functions to run, one of which I found here at stackexchange.

Here is the function:

    function addFirstRow() {
    var firstRow = 1;
    var sh = ss.getActiveSheet();
    var lCol = sh.getLastColumn();
    var range = sh.getRange(firstRow, 1, 1, lCol);
    var formulas = range.getFormulas();
    sh.insertRowsAfter(1, 1);
    newRange = sh.getRange(firstRow, 1, 1, lCol);
    newRange.setFormulas(formulas);
}

I want to call this function from a separate tab in which it's going to run. I intend to create another function to do this. I want to have this run when I enter information into a cell on this other tab, and then have this function create the row on my target tab. What would it look like to call this function from another one?

So you just want to call one function from another?

ross
– ross

2020-02-21 16:48:50 +00:00
Commented Feb 21, 2020 at 16:48 — ross
– ross, Commented Feb 21, 2020 at 16:48
Yes, exactly! I just don't know how.

Stephen Foltz
– Stephen Foltz

2020-02-21 18:09:32 +00:00
Commented Feb 21, 2020 at 18:09 — Stephen Foltz
– Stephen Foltz, Commented Feb 21, 2020 at 18:09

Cooper · Accepted Answer · 2020-02-21 19:34:23Z

1

function newFunction() {
  addFirstRow();//Just called another function
  addSecondRow();//And another
  var r=getSomeData();//call another function that returns data
}

Here try this:

function newFunction() {
  var ss=SpreadsheetApp.getActive();
  var sh=ss.getActiveSheet();
  var name=sh.getName();
  SpreadsheetApp.getUi().alert(Utilities.formatString('Sheet Name: %s',name));//modal dialog
  sh.getRange('A1').setValue('I am ' + name);
  var ui=HtmlService.createHtmlOutput(sh.getRange('A1').getValue());
  SpreadsheetApp.getUi().showModelessDialog(ui, 'Sheet Name');//Modeless dialog
}

Documentation Reference

Check the help references in the script editor:

edited Feb 21, 2020 at 19:34

answered Feb 21, 2020 at 19:04

Cooper

64.2k7 gold badges29 silver badges65 bronze badges

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

1 Comment

Stephen Foltz Over a year ago

So I could do something like... var name=getName() while having the function called in the variable pulling data from specific cells however I designate (such as with getActiveCell().getValue())???

Collectives™ on Stack Overflow

Running Multiple Functions in Google Apps Script

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related