Deliverables Tracker Automation
-
Time-based trigger: If enabled, the script will run daily, sometime between 12am and 1am.
-
Manual trigger: 2 options
- Mark all late deliverables: will audit the entire spreadsheet.
- Mark late deliverables on this sheet: will audit the sheet that you are currently viewing.
The script will skip the Deadlines, Student+Apps, and Names + Emails sheets.
NOTE: If a permissions prompt appears, please allow all the permissions it is asking for.
-
Open the spreadsheet you would like to install this script on.
-
Click Tools in the menu.
-
Click Script editor in the dropdown menu.
You should be brought to a new page with an empty Google script that looks like the image below.
-
Copy the contents of
watcher.gs
(from this repo) into the newly created Google script. -
Save the file. (CMD + S)
-
Wait a second for the Watcher button to appear next to the Help button.
- If installed correctly, you should see a new item in the toolbar at the top of your spreadsheet. (See image below)
- Click Watcher.
- Hover over Time Trigger Settings to reveal a dropdown menu.
- Click Enable time trigger.
The script will audit the spread sheet daily sometime between 12am and 1am.
NOTE: Google does not allow finer control of time triggers.