Refresh Card (sidebar) when new Sheet is added or deleted (Workspace Add-on)

[N A]

Hi,

This is a Workspace Add-on which is using a card to build the sidebar.

Is it possible to refresh the sidebar card when a new sheet is added or deleted? My script run without error except it doesn't update the sidebar card.

The sample code below does the following:

1. Create an Installable Event-trigger onChange

2. Display 'hello' text in sidebar card

3. When new sheet is created

4. It executes the myOnChange() function but does not refresh the sidebar.

Expected output should display "hi" text in the sidebar card.

function onHomepage() {
  createOnChangeTrigger();

  return greetCard('hello');        
}

function createOnChangeTrigger() {
  const triggers = ScriptApp.getUserTriggers(SpreadsheetApp.getActiveSpreadsheet());

  if (triggers.length > 0) {
    return;
  }

  ScriptApp.newTrigger('myOnChange')
    .forSpreadsheet(SpreadsheetApp.getActive())
    .onChange()
    .create();
}

function myOnChange() {
  const card = greetCard('hi');
 
  const newcard = CardService.newNavigation()
    .popToRoot()
    .pushCard(card))

  return CardService.newActionResponseBuilder()
    .setNavigation(newcard)
    .build();
}

function greetCard(text) {
  Logger.log('greet: %s', text)

  let content = CardService.newDecoratedText().setText(text);
  let section = CardService.newCardSection().addWidget(content);

  return CardService.newCardBuilder()
      .addSection(section)
      .build();
}

Does Installable triggers run on a different context that's why it can't update the card?

Thanks

[Clark Lind]

What happens if you reverse the order in which you run the functions? 

Also, there is an extraneous ")"  after  .pushCard(card)   see if that is causing any problems.

[N A]

Yeah! I forgot to remove the extra ")" I tried to edit my previous post but I can't do that, but anyway, I'm sorry but what do you mean by reverse the order...?

[Clark Lind]

Disregard what I said about reversing the order.

Does each function work independently? try making it an async function:

async function onHomepage() {
  await createOnChangeTrigger();

  return greetCard('hello');        
}

[N A]

Thank you, will test this one.

[Jason Cobble]

I don't know who's added me or using my account to write you but it isn't me. I can be contacted at jas...@cobbletechnologies.com

In regards to this. 

Jason

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f4d2f696-358a-4da5-a567-afae52ee0742n%40googlegroups.com.

[N A]

Hi,

I'm sorry I've just tried this but this doesn't work.

Thanks

On Wednesday, October 26, 2022 at 9:32:50 PM UTC+8 cwl...@gmail.com wrote:

[N A]

I conclude that I cannot refresh or update the Google Workspace Add-on card from a Trigger function because it looks like the trigger function is running from server.

[Clark Lind]

Have you thought about adding an html doGet() function to your script? I don't know if it will work, but here is the concept:

When Spreadsheet is changed, and onChange trigger fires. 
The onChange trigger calls the URLFetch method. 
The URLFetch method calls the published url of the DoGet function.
The doGet function calls the script's onHomePage() function (or other refresh function). 

This is just a concept and I have not tested it. But in theory, you should be able to talk the the cardservice if the cardservice script contains a doGet function.