What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Sheet no longer fires a trigger when submissions are received.

    Asked by edswartz on August 15, 2014 at 04:23 AM

    I'm not sure if you can help me with this, but now the Google Sheet no longer fires a trigger when JotForm sends new data. It used to be that when JotForm passed a row into the Google Sheet, a trigger fired that called a function. Since I reintegrated the sheet, the trigger does not fire when Jotform passes data to it. It will run manually when I update the sheet, but not when JotForm passes it data.

     

    Any ideas?

  • Profile Image

    Answered by jedcadorna on August 15, 2014 at 09:58 AM

    Are you using the new spreadsheet link or the old spreadsheet link? I just tested the integration on my end and it works fine. It sends data perfectly.

    Can you please share to us which form is not passing data to the spreadsheet so we can check. Can you please explain which triggers is not working? Is it the conditional rule?

  • Profile Image

    Answered by edswartz on August 15, 2014 at 10:52 AM

    Hi. To be clear, teh data is getting passed perfectly. However, when the data gets passed, the trigger withing the Google sheet no longer fires. It's as though the data is coming in as "stealth mode." So in your test, add a trigger in Google Sheet (e.g., On Change run "myFunction"). I will also try to test on a clean sheet.

  • Profile Image

    Answered by jedcadorna on August 15, 2014 at 11:59 AM

    I'm not sure if there have been some changes with the integration. I haven't tested the triggers yet I will make some test on my end to see what's causing this triggers not to fire. We'll let you know if any success. 

    Thanks,

  • Profile Image

    Answered by edswartz on August 15, 2014 at 02:37 PM

    I brought up the JavaScript console and captured the following in my sheet as soon as I completed my form:

    Uncaught TypeError: Cannot read property 'impl' of undefined

     

    When I look at the code it refers to this section. Note the comment upfront explains why the code is included. The actual "impl' referenced is on the 3rd line of the actual code:

    // In case the extension never invokes the responseCallback, and also // doesn't keep a reference to it, we need to clean up the port. Do // so by attaching to the garbage collection of the responseCallback // using some native hackery. messagingNatives.BindToGC(responseCallback, function() { if (port) { privates(port).impl.destroy_(); port = null; } }); var rv = requestEvent.dispatch(request, sender, responseCallback); if (isSendMessage) { responseCallbackPreserved = rv && rv.results && $Array.indexOf(rv.results, true) > -1; if (!responseCallbackPreserved && port) { // If they didn't access the response callback, they're not // going to send a response, so clean up the port immediately. privates(port).impl.destroy_(); port = null; } } } privates(port).impl.onDestroy_ = function() { port.onMessage.removeListener(messageListener); }; port.onMessage.addListener(messageListener);

     

  • Profile Image
    JotForm Support

    Answered by Welvin on August 15, 2014 at 05:29 PM

    Is it a trigger that is manually added to the Sheet that is generated by the Google Spreadsheet Integration? If so, then most likely, the function is not well configured or missing some characters. And I think, that's not part of the integration. Am I right?

    Can you share to us the spreadsheet instead? Share it to our Gmail Account at jotformsupport@gmail.com

    Thank you!

  • Profile Image

    Answered by edswartz on August 15, 2014 at 05:40 PM

    I shared the sheet with you. I've also reintegrated the sheet so it is a new integration. You will see the resource has a trigger for "on Change" to kick off my function.

     

    I also tried to create a trigger programmatically, but have commented that out.

  • Profile Image
    JotForm Support

    Answered by Welvin on August 15, 2014 at 07:00 PM

    My apologies! But I don't have the idea where to find that script or trigger to the sheet. Can you guide us please? A screenshot?

    Thank you!

  • Profile Image

    Answered by edswartz on August 16, 2014 at 08:34 AM

    See screenshot at https://docs.google.com/drawings/d/19KiqByf9IcS8dQS_ai_bQbUBzH_Kl_oafU4YrbV54IM/edit?usp=sharing I also shared with your gmail support address. Basically you go to the Tools Menu and select Script Editor. This will bring up a new page and new menus. Now go to the Resources menu and select Current project's triggers.

     

     

  • Profile Image
    JotForm Support

    Answered by Welvin on August 16, 2014 at 03:54 PM

    I'm sorry to say, but this is outside for what we can do in the current integration. We will try to help, but we can't promise you anything since we also need to look for some resource that would help us to troubleshoot this. You may also consider posting some questions related to this to Google Spreadsheet Forums.

    Thank you!