Trigger Failures

[hellogeli]

I got such message when using trigger to update data every hour:

Your script, Daily Activity, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.

The script is used by the document Untitled spreadsheet.

Summary:

Error Message Count Please select an active sheet first. (line 43, file "Code") 24

Any ideas?

Thank you!

[valt449]

Try inserting this code: var doc = SpreadsheetApp.openById("INSERT_SPREADSHEET_ID"); doc.getSheetByName("INSERT_SHEET_NAME");

Instead of this: var doc = SpreadsheetApp.getActiveSpreadsheet();

Helped me!