google.script.run.function not working with Chrome V8

Question

Here is my code for show a sidebar. When click at OK button, I will insert a new record to my sheet. It works well when I disable V8 by Run->Disable new App Script .. V8. When I enable V8, onClicked in Code.gs not fired anymore. I have checked the V8 Runtime Overview but I didn't find anything.

Index.html

<!DOCTYPE html>
<html>
  <head>
    <base target="_top">
  </head>
  <body>
    <button onclick="okClicked()"> OK </button>
    <button onclick="close()">Close </button>
    <script>
      function okClicked(){
          window.alert("A");
          google.script.run.okClicked();
      }
      
      function close(){
          google.script.host.close();
      }
    </script>
  </body>
</html>

Code.gs

function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('Index')
      .setTitle('My custom sidebar')
      .setWidth(300);
  SpreadsheetApp.getUi().showSidebar(html);
}

function okClicked(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Data");
  sheet.appendRow(["A", "B"]);
}

Any help or suggestion would be great appreciated.

Read minimal reproducible example- specifically describe the problem/error and not your inference of the error/problem. Like: "when I click the button , nothing happens. I added console.log("Triggered") inside code.gs, but nothing is logged on the "server console". On the client side, The following error is shown on the "browser console", when I click the button: .... " — TheMaster
– TheMaster, Commented Feb 28, 2020 at 10:31
Unfortunaty, the code works for me great! Please, check that the book contains the 'Data' sheet. — oshliaer
– oshliaer, Commented Feb 28, 2020 at 11:56
What does the execution log show? Does it show a call to okClicked? If so, any error? — IMTheNachoMan
– IMTheNachoMan, Commented Feb 28, 2020 at 15:14
@contributorpw yes, I have 'Data' sheet, when I disable v8, everything working well — Linh
– Linh, Commented Mar 2, 2020 at 1:21

Kessy · Accepted Answer · 2020-03-02 12:13:51Z

3

+50

Someone posted an issue similar to createHtmlOutputFromFile and V8 on Google's Issue Tracker. You can check if this issue is adequate for your case and hit the Star to let them know you have the same issue.

If you believe that this issue does not correspond with yours, you can also create a new issue with your case there.

answered Mar 2, 2020 at 12:13

Kessy

2,0141 gold badge10 silver badges16 bronze badges

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

2 Comments

TheMaster Over a year ago

This might be more related to the issue you already linked here stackoverflow.com/q/60412319 issuetracker.google.com/issues/150247026

Linh Over a year ago

Thank you. I will follow the issue tracker

Dharman · Accepted Answer · 2021-05-05 21:16:49Z

0

2021 Answer

FWIW, I found that Google Apps Script was erroring out like this when my partner and I were both logged into the same Google account.

We also found that this can happen when new features have been built into your Google Apps Script / Sheets backend code that require updated permissions that haven't been granted yet. It's a bit hacky, but I fixed this by:

Sharing the sheet with another account I own
Logging into that account, then trying to run the function
Agreeing to grant the permissions asked by Google Auth / Scopes in the dialog that follows

edited May 5, 2021 at 21:16

Dharman♦

33.9k27 gold badges105 silver badges157 bronze badges

answered May 5, 2021 at 21:10

Davis Jones

1,9424 gold badges21 silver badges30 bronze badges

Collectives™ on Stack Overflow

google.script.run.function not working with Chrome V8

2 Answers 2

2 Comments

2021 Answer

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2021 Answer

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related