How to Build:
Note: This project requires Go version 1.7.4 or higher.
This package uses oauth2 client for authentication. You need to get service account key from Google Developer Console. Place the client_secret.json to the root of your project.
Form layout:
| 0 | A | B | C |
|---|---|---|---|
| 1 | Date | Date | |
| 2 | Toastmaster of the Day | FirstName LastName | FirstName LastName |
| 3 | Joke Master | FirstName LastName | FirstName LastName |
| 4 | General Evaluator | FirstName LastName | FirstName LastName |
| 5 | Timer | FirstName LastName | FirstName LastName |
| 6 | Ah Counter | --- | --- |
| 7 | Grammarian | Date | Date |
| 8 | Speaker 1 | Nathaniel LastName\nCC #3 | --N/A-- |
| 9 | Evaluator 1 | Chris LastName | --N/A-- |
| 10 | Speaker 2 | Betty LastName\nCC #6 | --N/A-- |
| 11 | Evaluator 2 | Carolyn LastName | --N/A-- |
| 12 | Speaker 3 | Ann LastName | --N/A-- |
| 13 | Evaluator 3 | FirstName LastName | --N/A-- |
| 14 | Speaker 4 | --N/A-- | |
| 15 | Evaluator 4 | --N/A-- | |
| 16 | Back Up Speaker(s) | ||
| 17 | Table Topics Master | Nick LastName | Chris LastName |
| 18 | Notes | Transition Meeting? |
- Column A contains the names of the required fields (i.e row 2 is "Toast Master of the Day", row 3 "General Evaluator").
- Columns B and C start out with the Date as the header and the corresponding field corresponding to the rows listed in column A. Example row 2 column B requires the First and Last Name of the "Toast Master of the Day".
NOTE :- i) In order to change the Google Docs sheets, make sure your sheet is 'publicly' readable with a link.
ii) The spreadsheet identifier which can be found on the shareable link, needs to be added to the file 'Sheets.go'. For example, if the shareable link is as follows, then the identifier is the highlighted part :-
https://docs.google.com/spreadsheets/d/1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k/edit?usp=sharing
Thus, the identifier is '1_P9K2asfsITSGEAh7PrPLxncSemNnjXHg3_O3q7OW0k' (without the quotes).