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
[ ] check user entry, log: who wrote what and when
[ ] compare user input with previous input, especially time overlapping / develop system that shows what the user have previously entered
[ ] automatically extract the user's (who's using the sidebar) email and name: (get current user's email address, match with email within members.json, pull full name from members.json)
[ ] compare the email from the Team sheet in the Timesheet, then choose which team member and fill in the "Full name" part
[ ] if the member is not in the team, forbid them to put an record and raise an error to inform them
[ ] extract title tag from url user inputs, then move the extracted title to activity column
[ ] Test the code before you do a pull request!
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.
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
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
Todo
Notice