Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 3 down vote favorite

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:

All your triggers

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.
share|improve this question

1 Answer

up vote 0 down vote accepted

There is a record of this complaint, Issue 146. It was raised in July 2010, and closed as Won't Fix in Feb 2011.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.