Use web UI to submit a time record in Timesheet

[kangabee]

Ver 1.0

Requirements

As a freelancer of Coderbunker, I would like to use a interface to record my time in timesheet in a more convenient way, instead of putting an record manually in spreadsheet.

Solution

• create an sidebar for timesheets spreadsheets, and create web interface for people to finish
• transfer this sidebar into a standalone web page: if possible also get sidebars for Coderbunker Members Profile, Coderbunker Calender together into the web page (will implement it in the future)

UX/UI Design

Final Sidebar UI/UX design

Todo

• [x] create an web interface (web page) with input area and submit button
• [x] create a script that allow the submitted result from the sidebar recorded into the spreadsheet
• [x] check user entry, log: who wrote what and when (Use log to move entry to another sheet "Log" in Timesheet)

Notice

• Do not make modification on timesheet directly, in case not to break the timesheet. Copy the timesheet spreadsheet to your own Google drive, and make modification with that.

[andiechu]

@kangabee paste your UX/UI design images in the issue's description

[kangabee]

Need help with getting code reviewed for automatic extraction of name from members.json : function matchName () { var emailaddress = Session.getActiveUser().getEmail(); Logger.log(emailaddress); var member = DriveApp.getFileById('141seEreVW3yZwsbWtHQ7QXDJ5_LzweXf'); //members.json for(var i = 0; i < member.length; i++) { if((member[i].members.email == emailaddress) || (member[i].members.altemails == emailaddress)) { return member[i].members.fullname; } else { return null; } } }

[kangabee]

Also need help with getting a code reviewed for checking entry, the plan is that when the user submits the information the inputs will be sent to both the Timesheet and another file on the Google Drive called the "entry.json" file: function saveEntry(datas) { var savePage = DriveApp.getFileById('1MnrEDykZU6AvKRREEn50oM0dMRYAwDdW'); //entry.json var obj = JSON.parse(savePage); obj['userEntry'].push({"full name":datas.enterFullName, "date":datas.enterDate, "start time":datas.enterStartTime, "end time":datas.enterEndTime, "activity":datas.enterActivity}); savePage = JSON.stringify(obj); }