[x] write prototype code for automatically extracting the user's email and return full name
(get current user's email address, match with email within members.json, pull full name from members.json)
[ ] debug code
[ ] compare the email from the Teamsheet 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 a record and raise an error to inform them
[ ] Warning: Make sure value in members.json = values in Timesheet, if not manually eidt members.json
[ ] IF POSSIBLE: Link dropdown values within Timesheet and email address instead of members.json
If possible, Ver 1.1 If not, Ver. 1.2
Todo
[x] write prototype code for automatically extracting the user's email and return full name (get current user's email address, match with email within members.json, pull full name from members.json)
[ ] debug code
[ ] compare the email from the Teamsheet in the Timesheet, then choose which team member and fill in the "Full name" part
[ ] Warning: Make sure value in members.json = values in Timesheet, if not manually eidt members.json
[ ] IF POSSIBLE: Link dropdown values within Timesheet and email address instead of members.json