gDoc Sub System

Setup

1. Create a new Google Docs spreadsheet.
2. Select Tools > Script editor....

3. Select Blank Project.
4. Paste the code from main.js. Update the global params as needed.

5. Select File > Save. Name your project.

6. Select File > Project properties. Set the appropriate timezone.

7. Select Resources > Current project's triggers.
8. Click Add a new trigger.
1. Set a Time-driven trigger to update colors. This will grey out past dates.
2. Add a trigger to send emails every morning.

9. Save your changes and authorize the app to send emails.
10. Reopen the spreadsheet. You should now see a Subs menu.
11. Setup your header rows and columns. The only requirement is that the first column contain dates.

• Note: If everything is setup correctly, the script should start coloring the cells appropriately. This image was taken on 1/25/14, so the dates before that are greyed out automatically.
• Tip: It might be helpful to put the day info in the second column. This can be done by adding =TEXT(A2, "E (MMM d)") as seen above.
12. The Subs menu can be used to manually do certain tasks.
1. Send email can be used to manually send an email at anytime.
2. Update colors can be used to force all colors to update.

• Note: You will need to provide authorization the first time you use the Subs menu.
The sub system is now ready! Share the spreadsheet link with your group and start using. The generated emails will look like this.