Status Update
No update yet.
Comments
ma...@google.com
Hello,
Please share how the trigger is installed and the code the trigger is running. Can you show any common pattern between error affected submissions? Can you reproduce the error with one of these submissions?
ma...@gmail.com
I can not reproduce the error, it is just completely random. It's on Google's end because I have no control over this situation.
I do not see any patterns with this. I would just like Google to ensure it never happens again.
sr...@gmail.com
ma...@google.com
Can you show the installed triggers list?
ma...@gmail.com
ma...@google.com
Hello,
Thank you for the list. I see that your triggers look fine. Let's try to understand where the problem could be:
-
How many times out of 10 events do you encounter the error?
-
Is the event triggered with data or without anything? I.e can you filter the payload of the event Object to understand if this is repeated one?
-
Did you try to delete and install again your trigger?
-
Did you try to create a new project from scratch?
-
Does the onFormSubmit execution overlaps/interferes with any of the Time-Driven triggers?
ma...@gmail.com
How many times out of 10 events do you encounter the error?
It rarely happens every 10 events. This problem is rare and hard to reproduce.
Is the event triggered with data or without anything? I.e can you filter the payload of the event Object to understand if this is repeated one?
The event is triggered with data. So my trigger occurs twice for one submission and both those triggers add the data in the way I programmed it to.
Did you try to delete and install again your trigger?
Yes, did not work. Happened again 3 days ago.
Did you try to create a new project from scratch?
No but I feel like it will occur again later on.
Does the onFormSubmit execution overlaps/interferes with any of the Time-Driven triggers?
It does not.
ma...@gmail.com
The problem is completely random, and is definitely has no association with my specific account. What if Google's servers glitch and execute something twice? That's the only plausible reason I can think of.
ma...@google.com
"... and is definitely has no association with my specific account."
Did you validate this with the G Suite support?
Please validate this too: try to create a new project from scratch.
I cannot reproduce the issue in my environment.
Description
Furthermore, the additional form submit trigger glitch does not add a row to the spreadsheet form responses, this is because the user isn't submitting the form twice, it's on Google for triggering it. This has happened randomly about 3 times in the past few months and it is extremely critical that my program only executes once for each job. After hours of research, I was unable to find a problem similar to mine. The problem also persisted even after adding the following line of code:
> if(e.values && !e.values[1]){return;} //To fix error when onFormSubmit triggers multiple times under one form submission //Doesn't work/do anything 6/8/2020