Google Apps Script – Viewing All Currently Running Scripts

google sheetsgoogle-apps-script

I have lots of GSheets with google apps scripts in them. Is there a way I can see which ones are currently running on my account?

Best Answer

If "currently running" means "have a trigger that runs them periodically or under certain conditions, then the answer is to go to Script Editor, select Edit -> All my triggers.

The triggers not associated with the currently opened script will appear in light grey, which makes them look as if they are inactive items that can't be edited. And indeed, they cannot be edited from here - but they can be deleted from this menu by clicking x on the left.

Related Solutions

Google Sheets – How to Use Formulas in Filter Views

If your data is in A1:D10, maybe:

=filter(A1:D10,A1:A10>500)

To allow for "new ones will be added" put the formula outside A:D and adjust to:

=filter(A1:D,A1:A>500)

Edit to include comment from someone who knows (@AdamL):

it is not possible to do what you want with the Sheets filter tool alone. You can combine both the filter tool and a FILTER or QUERY formula (eg apply the filter tool to the output of pnuts' solution, which could also reference the 500 part in another cell, perhaps in the header row to the side). Alternatively, a helper column(s) could be used to simulate the required functionality.

Google-sheets – Protect Scripts in Google Spreadsheets

I wonder why this question hasn't got a decent answer yet after more than 4 years.

It's surprisingly simple :-) Just create a new script (standalone, or under another spreadsheet), and replace all the SpreadsheetApp.getActiveSpreadsheet() calls by SpreadsheetApp.openById("spreadsheet-id") in which the spreadsheet-id is the last part of the document URL; https://docs.google.com/spreadsheets/d/{spreadsheet-id}

Using this easy trick, you access the shared spreadsheet by your own script that is not accessible to the others.

Best Answer

Related Solutions

Google Sheets – How to Use Formulas in Filter Views

Google-sheets – Protect Scripts in Google Spreadsheets

Related Topic