apps script trigger sometimes does not work

[Wim De Backer]

I'm using apps script on google sheet for about 2 years.
Since few days the scripts trigger waits till another new post to run.

Workflow:

1) google form fills sheet

2) apps script with trigger

This trigger 'sometimes' waits for next input.

I've highlighted the screenshot.
Normal behaviour = green
Delayed = red

There are no errors, is there a way to fix this?

[George Ghanem]

That is unusual. Have not seen that myself through all the forms I have.

Take a look at the executions page and check to see if the script is being invoked or not. It may be stopping itself for some reason.

--
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 visit https://groups.google.com/d/msgid/google-apps-script-community/3ceab850-5c25-4a51-a998-6cbb1724c528n%40googlegroups.com.

[Wim De Backer]

Thanks for the quick response George,
below I've tried to get every data together.

after execution at 12:01 script stopt working for over an hour


new respons at 13:06 processed all three form-inputs (12:05, 12:21 and eventually 13:06 did the trick):

The execution log does not clearrify anything, or am I missing something?

[George Ghanem]

Yes, the script execution log does show that the Trigger did not run as you indicated. 

Does this happen a lot where it is skipping some of the form submissions?

I am not sure why this would happen. But here are a couple of more questions for you:

1- The trigger and software, are they inside a spreadsheet or from the Google Form itself?

2- Do you have any form notifications turned on that may filter out some events?

One way to address this is to have the software handle all form submissions that were skipped, would something like that work or do you need it to be more timely?

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/3513e7ae-c8ed-424a-9b2f-a5b0b43eb782n%40googlegroups.com.

[Wim De Backer]

1- trigger is setup within GoogleSheet 'Apps Script'
2- we do notify the person who filled the form, that is handled by the form. I wouldn't assume the sheet/apps script to have issues with this

3- timing is rather essential - script creates json on specific google drive and is picked up by other automations

We have several about identical workflow (form-sheet-apps script-jason), there hadn't been any remarks on those.
On the other hand: these are not used daily.

I'll try to create shadow-setup (tomorrow) and switch to it, this way we can see if it is happening again with newly created.

Many thanks for all your efforts, I'll keep you posted!

[George Ghanem]

One other question, are form responses entered into the spreadsheet even when the trigger is not triggered?

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/92f81dbb-2d9a-40f9-a232-4809c7a8682cn%40googlegroups.com.

[Wim De Backer]

Yes. I believe I've found the origin of the problem. Only, weird that there is no error like timeout.
Every submitted form got a new row, these rows where 'cleaned', not removed. So the sheet had >9k rows.
I've altered the script to delete the row after export, manually cleaned the empty rows.

It's stupid on my side to not have noticed this, stupid that Apps Script did not return any error.
Let's hope this resolves the issue for us :-)

[George Ghanem]

Yes, it is a good practice to keep spreadsheets accepting form input as small as possible. I archive all data in seperate spreadsheets on a yearly basis.

Maybe that helped me avoid your issue.

Good catch!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/05c4a330-817e-4a53-808b-53d7a74dc555n%40googlegroups.com.