Mogsdad
Reputation: 45710
How to determine source script of installable trigger?
I have a trigger that I can't find! At least, I can't find it easily, and may have to resort to the brute force method.
I've got more than a hundred scripts and spreadsheets-with-scripts, and somewhere in there I have a function called colorRows that is set up as a trigger. I know that, because it shows up in my triggers list:
How can I find the script that contains colorRows?
- I've tried using Search in Google Drive, but it appears to be unable to find the content of scripts contained in spreadsheets. (It does index standalone scripts, so that did narrow down my search to just spreadsheets.)
- I can open every spreadsheet, then open the script, and search - brute force. No thank you, that's still some 75 sheets.
- Script Services
getProjectTriggers()is project-based, as the name implies, and only works within the project it's running in. - The title of Spreadsheet source of a programmed trigger sounded good, but is quite different.
- I don't want to stop the trigger (that's easy), I want to find the code. So How to Stop Orphaned Triggers is irrelevant.
Upvotes: 4
Views: 318
Answers (1)
Related Questions
- How to identify whether Google Apps Script is launched as a Trigger or Manually?
- How to programatically find and distinguish triggers in Apps Script?
- A summary of all Google Apps Script triggers in my account
- Why do I see installable triggers in my source google apps script that is published as a Sheets add-on
- Checking for installed Triggers onOpen for Google Spreadsheet without using an installable trigger
- How to get installable trigger to sense event
- How to check existing triggers on google appscript project?
- Get all Google Script Triggers and remove them
- Is there a way to obtain details on triggers in Google Scripts?
- Spreadsheet source of a programmed trigger