google.script.run.withSuccessHandler is not working

[Pravalika Salla]

Hi ,

The app is created with Google AppScript & Sheets, it has been used for several years now but went down, the issue found is google.script.run.withSuccessHandler is not working, it shows an error Uncaught TypeError: Cannot read properties of undefined (reading 'run').

We needed some help 

Thanks & Regards,

S.Pravalika

[Damien GOACOLOU]

Hi, 

Do you use google.script.run.withSuccesshandler function ?

[Pravalika Salla]

hi, 

Yes i use, google.script.run.withSuccessHandler function

S.Pravalika

"Ce message et toutes les pièces jointes (ci-après le "message") sont établis à l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le détruire et d'en avertir immédiatement l’expéditeur. Toute utilisation de ce message non conforme à sa destination, toute diffusion 

ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'intégrité de ce message, nous déclinons toute responsabilité au titre de ce message, dans l’hypothèse où il aurait été modifié."

--
You received this message because you are subscribed to a topic in the Google Groups "Google Apps Script Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-apps-script-community/AeFPgvizP1o/unsubscribe.
To unsubscribe from this group and all its topics, 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/cb79636c-4dbe-4cb4-8210-d7529b76547an%40googlegroups.com.

[Damien GOACOLOU]

It's difficult to help you without to show your code.

[Pravalika Salla]

Sample code:

 $(document).ready(function ()

    { 

   var saveField = $('#save').val;

     $('#savereport').on('click', function(){

   if( !$('#save').val().trim().length)

    {

    //alert("No NAME entered to SAVE");

      document.getElementById('errorMsgs').innerHTML="No Report NAME provided to SAVE!";

      $( "#emailDialog3" ).dialog('open');

 }

    else

    {

    var formValues = $("#save").serializeArray();

    var newValues = {};

    formValues.forEach(function(x){

    newValues[x.name] = x;  

    console.log('newvalues'+ newValues[x.name])      

    });

    

   var parameterList=params();

   console.log("PL"+ parameterList)

   var filterList=params1();

   console.log('FL'+ filterList);

   var filterList1=params2();

   console.log('FL1'+ filterList1);

   var filterList2=params3();

   console.log('FL2'+ filterList2);

    var filterList3=params4();

   if(parameterList=="")

   {

   //alert("No Columns selected to SAVE!");

      document.getElementById('errorMsgs').innerHTML="No Columns selected to SAVE!";

      $( "#emailDialog3" ).dialog('open');

  return;

   }

   if(filterList=="")

   filterList=null;

    if(filterList2=="")

   filterList2=null;

    if(filterList1=="")

   filterList1=null;

    if(filterList3=="")

   filterList3=null;

   google.script.run

        .withSuccessHandler(function(){

           google.script.run.withSuccessHandler(showMenu)

                .getMenuListFromSheet();   

           $( "#save" ).val("");

           }).addRowToSpreadsheet(newValues,parameterList,filterList,filterList1,filterList2,filterList3); 

 

 }

        });

      

           

    })

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/d969e221-d9c4-4074-abff-35d3d503f7c3n%40googlegroups.com.

[Damien GOACOLOU]

What's the code of the  getMenuListFromSheet's function ?

You don't change name of tab or something like that ?

[Pravalika Salla]

no, we didn't change any name of Tab

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/1eedbe85-87c4-447b-9095-7b1236c62490n%40googlegroups.com.

[cbmserv...@gmail.com]

You will need to show us the server side code of this. That is where the failure is.

 

The function: getMenuListFromSheet specifically.

 

Most likely the cause is some data element in that spreadsheet has been deleted.

Sample code:

 

 

 

--
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/CAMHuw2vzSBvV%2BZgLYJTKg_B-fVHqOwEGe3pgCvN_wBGwKmmNKQ%40mail.gmail.com.

[Pravalika Salla]

Hi,

folders in a drive everything checked, google.script.run.withSuccessHandler is not working for this several years code only, for others it's working fine

/*TO GET THE REPORT NAMES*/

function getMenuListFromSheet() {

  var ss = SpreadsheetApp.openByUrl('https://docs.google.com/spreadsheets/d/1nqwdlImUZAtczWDLXQCXDtoedCgriCTT1zRXMrunO0s/edit#gid=0').getSheets()[0];

  var lc = ss.getLastRow();

  return ss.getRange(2, 1, lc - 1, 1).getValues();

}

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/007001d946ea%240ab81cb0%2420285610%24%40gmail.com.

[CBMServices Web]

Ok the server side function looks good.

Having a second look at your client side code and I don't see that you provided the code for function showMenu.

Where is the code for that function?

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAMHuw2vWBHdvxXCTSWuCBJHb_3QnQ%2BbMCFE6nRqgYrb7W%2BB%2BVg%40mail.gmail.com.

[Edouard Rossignol]

Hello,

Same problem here. The issue appears when trying to pass a hash table through google.script.run.withSuccessHandler

Here is a minimal example to highlight the issue

Code.gs

function doGet() {

return HtmlService.createHtmlOutputFromFile('Index');

}

function returnValueifTrue_arrayIfFalse(myBool) {

if(myBool){

return 667

}

else{

return {'a' : 667};

}

}

Index.html

<!DOCTYPE html>

<html>

<head>

<base target="_top">

<script>

function onSuccess1(numUnread) {

var div = document.getElementById('output1');

div.innerHTML = 'Result is ' + numUnread;

}

function onSuccess2(numUnread) {

var div = document.getElementById('output2');

div.innerHTML = 'Result is ' + numUnread;

}

google.script.run.withSuccessHandler(onSuccess1)

.returnValueifTrue_arrayIfFalse(true);

google.script.run.withSuccessHandler(onSuccess2)

.returnValueifTrue_arrayIfFalse(false);

</script>

</head>

<body>

<div id="output1"></div>

<div id="output2"></div>

</body>

</html>

Expected result (used to work)

Result is 667

Result is {'a' : 667}

Actual result

Result is 667

Result is [object Object]

Same issue happens with CacheService

Please escalate !!

Regards,

ER

[Edouard Rossignol]

Ignore my previous post. I do have the issue, but it is not properly reproduced in the previous examples. Cheers

[cbmserv...@gmail.com]

Eduoard,

 

First, please note that there are no Google employees on this discussion group. This is merely a discussion group for developers who work on Google AppsScript. If you need to open a ticket with Google, then use this website to create a ticket or search for a ticket if you think one was opened: https://issuetracker.google.com/

 

Second, the display you are showing is actually correct. Your server function returnValueifTrue_arrayIfFalse

Is returning an object and the html code is showing it is an object.

    return “{'a' : 667}”;

 

 

If you want to display the text instead, then either change code in your function to return a string or do a stringfy in the HTML side to convert object to string.

 

      function onSuccess2(numUnread) {

        numUnread = JSON.stringfy(numUnread);

        var div = document.getElementById('output2');

        div.innerHTML = 'Result is ' + numUnread;

      }

 

Hope this helps.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/fbda50c2-eece-420e-bfba-b5be360bb8f9n%40googlegroups.com.

[Edouard Rossignol]

Hello,

Thank you for your reply. As I wrote in my own response, the issue I have noted is not properly described in my post, and in the end unrelated to the OP's post. Sorry for that.

The issue does exist with google.script.run.withSuccessHandler used in the context of google.charts.load('upcoming', {'packages': ['vegachart']});  which is currently broken.

If anyone ends up on this post for this reason, 

google.charts.load('50', {'packages': ['vegachart']}) works

Cheers,

ER

[Brett Grear]

Is there time or date columns in your spreadsheet data. You can't pass these back into client side without stringifying then first. 
Try .getDisplayValues() instead of .get values() although this may break other things depending on your dataset

[Pravalika Salla]

function showMenu(menuItems) 

  {

  var list = $('#menu');

list.find('option').remove();  

  for (var i = 0; i < menuItems.length; i++) 

  {

    list.append('<option>' + menuItems[i] + '</option>');

  }

}

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAFX%2Bz3VpVPcN_18Uuo%2B4DNh79ChPQyMOhEY%3DNmHHft7cP%3DX9%3DQ%40mail.gmail.com.

[cbmserv...@gmail.com]

The showMenu function looks ok. But the error is basically indicating that it can not find it. So you should make sure this function is defined correctly in the same html file and preferably before where it is being called.

 

Also, not sure why you have nested google.script.run commands. You should segregate them and then see if error goes away.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAMHuw2ska9osPNrDhz4TnMmu2R0mfV%3DkQL7oGVbzJZ_4_Cb5ZQ%40mail.gmail.com.

[cbmserv...@gmail.com]

One issue that may get many in dealing with webapps is the publish step.

 

Anytime you do a change to the code on the server side or on the client side, you need to publish a new version of the code or else none of the changes take effect.

 

I am not sure this is your case or not,  as you have not shared any code with us here. But certainly one thing to check closely.

 

From: 'Jeremiah Martinez' via Google Apps Script Community <google-apps-sc...@googlegroups.com>
Sent: Wednesday, March 8, 2023 7:54 AM
To: Google Apps Script Community <google-apps-sc...@googlegroups.com>
Subject: Re: [Apps-Script] Re: google.script.run.withSuccessHandler is not working

 

Any update on this? I'm following closely as I am also having the same issue (all of a sudden, like within the last couple days).

 

In one instance withSuccessHandler correctly receives the parameter from the server-side function. In another instance, withSuccessHandler doesn't receive the parameter at all.  Both instances run the same server-side function and both instances use the same client-side function to pass the same parameter to the server-side function.  Logging the parameter right before returning back to withSuccessHandler shows me that the parameter is correct on the server side in both instances before being passed back to client-side.

 

This is totally bizarre. 

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5a10ebac-7ec9-4940-870a-bc2066797dedn%40googlegroups.com.

[Brett Grear]

What is being passed back to the client from the server?

Is it values from a spreadsheet?

Do these values from the spreadsheet include Dates or Times?

Dates and times can not be passed back in a successHandler but it does not result in an error, it just passes back null.

On Wed, 8 Mar 2023 at 15:53, 'Jeremiah Martinez' via Google Apps Script Community <google-apps-sc...@googlegroups.com> wrote:

Any update on this? I'm following closely as I am also having the same issue (all of a sudden, like within the last couple days).

In one instance withSuccessHandler correctly receives the parameter from the server-side function. In another instance, withSuccessHandler doesn't receive the parameter at all.  Both instances run the same server-side function and both instances use the same client-side function to pass the same parameter to the server-side function.  Logging the parameter right before returning back to withSuccessHandler shows me that the parameter is correct on the server side in both instances before being passed back to client-side.

This is totally bizarre. 

On Monday, February 27, 2023 at 10:28:54 PM UTC-7 cbmserv...@gmail.com wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5a10ebac-7ec9-4940-870a-bc2066797dedn%40googlegroups.com.