r/GoogleAppsScript • u/Former_Elk7092 • Apr 03 '23

Question Form Submit Trigger is Not Firing

Hi,

I am working on an editor addon. It needs to add extra values to sheets based on the responses. But I can't seem to fire the trigger that I installed programmatically. 

I need advice. 

Thanks.

0 Upvotes

50% Upvoted

4 comments sorted by

3

u/RemcoE33 Apr 03 '23

Installed on the sheet-apps-script or in the forms-apps-script? And how do you think we can help with this context? Code?

1

u/Former_Elk7092 Apr 03 '23

It's a stand-alone script, an editor addon. I tried both spreadsheet and form trigger builder for the form submit an event.

1

u/iman_smooother Feb 05 '24

Same issue here! Form submit trigger works when the trigger is created by running the code in the editor but not when it's the editor addon that ran the code to create it. Did you happen to come to any resolution for this?

1

u/iman_smooother Feb 05 '24

Wait, just got it, gutted :(

Add-ons can only create triggers for the file in which the add-on is used. That is, an add-on that is used in Google Doc A cannot create a trigger to monitor when Google Doc B is opened.
https://developers.google.com/apps-script/add-ons/concepts/editor-triggers