OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Running multiple functions in only one file

  • Thread starter Thread starter Niamh Joyce
  • Start date Start date
N

Niamh Joyce

Guest
I have a sheet with 3 tabs, and a total of 9 'set formula' app script functions across those sheets, each with a daily trigger.

As this sheet powers a looker studio dash, I also need to have 9 'set value' functions to keep the columns headings consistent and stop the looker studio from breaking. I'd like to avoid having 18 separate files/triggers, and have one for each sheet each containing 6 (differently named) functions

When I try running a file with more than one function (see below) it only runs the top function - though they both work when run from separate files.

If love to know if there's a way to do this all together.

Example functions below

Code:
Function levelheading(){

   var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName('Source');

var cell = sheet.getRange("AB1");

cell.SetValue('Level');

}





Function level(){

   var ss = SpreadsheetApp.getActiveSpreadsheet();

var sheet = ss.getSheetByName('Source');

var cell = sheet.getRange("AB12:AB");

cell.setFormula("VLookup(B2,'Reference'!A:E,5, False");

}

Continue reading...
 
Top