Use Calendar as a timesheet entry interface

[rngadam]

tasks

• Create a data format similar to the existing Timesheet object used with Google Spreadsheet
  • https://github.com/coderbunker/gsuite-appsscript/blob/master/timesheet/data.js
• export and push to our snapshot API endpoint
• document and setup add-ons

code style

• use type annotation comments: https://google.github.io/styleguide/jsguide.html#jsdoc-type-annotations
• style code properly

more information

Example of current entries:

{
    "id": "1wldjlRUzSKzUYXVI7gIIJgbfMDOG8gWHq07zephzKlI",
    "name": "DLG Project Timesheet",
    "timezone": "Asia/Shanghai",
    "apptype": "Spreadsheet",
    "category": "Timesheet",
    "sheets": {
        "Timesheet": {
            "data": [
                {
                    "month": "2017-06",
                    "date": "2017-06-08",
                    "hourlyrate": "¥700.00",
                    "start": "15:00",
                    "stop": "16:00",
                    "hours": "1:00:00",
                    "total": "-¥700.00",
                    "resource": "Ricky",
                    "taskname": "Setup",
                    "activity": "https://docs.google.com/document/d/1FLue-J9WRWUauCOVbL92U7l29i7Z1Bz7VSf4sGcjkRI/edit#"
                },

• Calendar should be an additional column on the Balance sheet so we can retrieve associated calendars:

Leads & Opportunities | Accounts > Project Timesheet | Balance | Calendar > Calendar

• Use PropertiesService for configuration settings

postponed

• unit testing
• Official add-on
• automated calendar setup interface
• refactor code (interacting with REST interface) into a Google Apps Script library
• add API key to prevent DoS

[rngadam]

done a first version... to be continued.