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

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?

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?

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.

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,

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);

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!

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.

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!

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.

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!