Trigger not triggered

[Adisak]

Trigger not triggered onChange event  on google sheet , how to check the error or limitation ? 

[Marcel Brauner]

I recently had the discovery that "small" changes like checkboxes do not trigger the on change. However I recently did something with a dropdown and there it worked. But I am interested if there is some hard facts on when it triggers and when not. My learning was just based on experience :) 

[Ed Sambuco]

Check out the Google doc on the Events object:

https://developers.google.com/apps-script/guides/triggers/events

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/5d76a820-a61f-4105-9206-6e973b329176n%40googlegroups.com.

[Adisak]

It works appropriately early until 5 pm. it stopped triggering the change event.

[Andrew Roberts]

"on change" and "on edit" aren't very comprehensive. If picking up all changes is crucial you might want to look at drive push notifications.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/04db40b1-7f63-4451-9355-01557ac64095n%40googlegroups.com.

[Rashid Khan]

I have installed onedit trigger in more then 1000 spreadsheets, but some of them do no work. I use those spreadsheets rarely. let say same sheet in edited after 3-5 months and I can see the trigger but it do not trigger.If I install it again and then It starts working.
What could be the reason of this?

[CBMServices Web]

Google regularly uninstalls triggers that are not used in the past x months (I don't know how many months specifically, but I have also had triggers (on form submit mostly) uninstalled and had to go through the authorization for them to re-activate them.

Only way to avoid this is to ensure your triggers are used regularly to avoid them being decommissioned. Other option is to change how you manage the work and reduce the number of triggers you have and ensure those are getting exercised regularly.

 Hope this helps.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/4211bb21-4560-4b73-b868-5d492736c131n%40googlegroups.com.

[Rashid Khan]

Thank you

[Rashid Khan]

If I apply time based trigger let say it runs every 10 or 20 days and reinstall the onedit trigger will it solve the issue?

[CBMServices Web]

This may work, you can try it and let us know. :-) 

 10 to 20 days would be too frequent. I think the decommissioning is for triggers that have not been used in the past 9 or 12 months. So if you do it every 6 months it should be plenty. But if you do have 1000s of spreadsheets, that is a lot of work to list out the 1000s of scripts that need to be re-installed. I would look at reducing the number of spreadsheets you need to trigger from instead to avoid this issue all together.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/590af7e9-ab8c-4c90-8723-dd6a0c2a44e2n%40googlegroups.com.

[Rashid Khan]

I will try this and will update you.
There are spreadsheets which are not used for 3 months but that triggers are not working so I need to install a trigger of 1 month max.

I can not reduce the numbers of spreadsheet as it has different data and I can not combine it.

Do you have any idea about limitation of installing triggers in a single Gmail account?