Installable trigger is just keep getting disabled

2021-02-22 22:32 JKC imported from Stackoverflow

I have been trying to install an installable trigger for a googlesheet workspace addon when a button is clicked. The trigger is meant to get fired whenever a cell is modified.

Unfortunately when a cell is modified, the trigger keeps getting disabled. The "disabled reason" (in Apps Script > Triggers > Last run column in the list) says: This trigger has been disabled for an unknown reason. I have tried calling from onHomepage() also.

Here is the code:

function createWidgetDemoCard() {
  return CardService
     .newCardBuilder()
     .setHeader(...)
     .addSection(
          CardService.newCardSection()
              .setHeader('Simple widgets')  // optional
              .addWidget(CardService.newTextParagraph().setText('Some text'))
              .addWidget(CardService.newImage().setImageUrl('.../trees-autumn-colors-lake-picutre-600w-1827312116.jpg'))
              .addWidget(CardService.newButtonSet().addButton(CardService.newTextButton()
                                                  .setText('Create trigger')
                                                  .setTextButtonStyle(CardService.TextButtonStyle.FILLED)
                                                  .setOnClickAction(CardService.newAction().setFunctionName('createSpreadsheetOpenTrigger'))
                                                  .setDisabled(false))))
     .build();
} 

function createSpreadsheetOpenTrigger() {
  var ss = SpreadsheetApp.getActive();
  ScriptApp.newTrigger('TestMe')
      .forSpreadsheet(ss)
      .onEdit()    //onChange() not working`enter code here`
      .create();
}

function TestMe(e) {
  var range = e.range;
  range.setNote('Last modified: ' + new Date());
}

The authscopes are:

"oauthScopes": [
    "https://www.googleapis.com/auth/spreadsheets.currentonly",
    "https://www.googleapis.com/auth/spreadsheets"
    ]

The code from the TestMe() function works perfectly in a container-bound script. But because I am developing a Workspace addon, I want in a standalone script.

I can't really find a comprehensive documentation about developing an workspace addon. Thanks!

See also questions close to this topic

Batch setting file permissions from gsheet script to drive (I can't set folder permissions)

I'm trying to change the permissions of 1000s of files. I can't set the folder permissions because I'm a "contributor" and not a manager, or a content manager. (which would've been much easier)

I have written this code to iterate through each file one by one and set it's permission.

function grantaccesstoprivateids(){
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("PictureIDs");
//var sheet = SpreadsheetApp.getActiveSheet();
var lastRow = sheet.getLastRow();

// Skip the header row
for (var i = 2; i <= lastRow; i++) {
  Logger.log(sheet.getRange(i, 6));
  if (sheet.getRange(i, 6).getValue() == "PRIVATE") {
    var fileID = sheet.getRange(i, 4).getValue();

    var file = DriveApp.getFileById(fileID);
    try {
      file.setSharing(DriveApp.Access.ANYONE_WITH_LINK,DriveApp.Permission.VIEW);
      sheet.getRange(i, 6).setValue("Code ran to share with all");
    }
    catch (err) {
      sheet.getRange(i, 6).setValue(err);
    }
  }
}
}

The issue is this is slow... (about 1 per second) I would love to make an array of each ID and then tell google, these 1000s of IDS? Please share them all to ANYONE_WITH_LINK.

How to embed an identity management on in my google site

I tried to install firebase on my google script in order to include the authentication in my webapp, but I could'nt find the library anywhere to install it. I followed all the steps described in the tutorials but firebase is not recognized.

Does anybody knows how to install firebase in g-script ? Does anybody knows if google sites can become a site with authentified users... ?

cheers
Google App Script to export chat history from a specific chat room

I cannot find the way to filter the chat threads for a specific Virtual Room Google Chat.
How to check if a column contains only empty / NA values?

Which g-sheet formula can I use to check if a column has only empty or NA values?
google sheets,yahoo finance,price and dividend data

i created my own international portfolio tracker / dividend tracker through google sheets & yahoo finance. The problem with international stocks is that you often cannot simply use the integrated data from google finance. KO (coca cola) is easy, CCC3.DE (also coca cola) cannot be found on google finance. suddenly some formulas stop working for some of the tickers. for Example AD.AS does work but ccc3.de does not work. i am clueless. plz help!

for price is use; A1 = "CCC3.DE" or "AD.AS"

=IFNA(VALUE(IMPORTXML("https://finance.yahoo.com/quote/" &A1, "//*[@class=""D(ib) Mend(20px)""]/span[1]")))

For dividend amount i use; =split(IMPORTXML(concatenate("http://finance.yahoo.com/quote/",index(split((E9&F9&G9),":"),0,2)),$F$22),"()"))/K9)))

Related questions

Installable trigger is just keep getting disabled

See also questions close to this topic