I need some to write Google Sheets scripts for a Timesheet system
3144
$$
- Posted:
- Proposals: 4
- Remote
- #886564
- Archived
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: The company provide Spanish language courses and employs a number of teachers.
Kind of development: Customization of existing program
Num. of modules: possibly 3
Description of every module: Please see attached PDF for flow diagram and process notes.
The script needs to be written in Google Sheets apps script. The appropriate Google Sheets will be shared with the successful candidate.
Description of requirements/functionality: The aim is to enable staff to enter timesheet information for a month and submit the totals to the admin's summary spreadsheet. The summary spreadsheet data will be sent to the payroll department to facilitate payment of staff salaries on a monthly basis.
Teacher Monthly Timesheet Entry (gsheet)
Enter time and task details where some days need to support more than one entry (1 per line); need a "submit" button to submit the summary information to the Admin Monthly Staff Summary (gsheet); and a reset button to clear the form down for use in the new month (on submit could do a clear down instead of a separate "reset" button); on submit or reset, the script should make a backup copy of the current gsheet named with the following details, "timesheet" + teacher name + month + year, and shared with the admin email address (to be supplied)
Admin Monthly Staff Summary
Requires a manual check and sign-off that every teacher has submitted a timesheets (staff numbers and names change as business requires) before clicking on a "submit" button which would trigger a backup of the file and name it, "Staff Time Summary"+ month + year, email the current sheet to the Payrol dept (email to be supplied) and clear down the entries ready for the next month.
See PDF for logic and excel docs for example layouts of the gsheets.
CMS and Admin requirements: none
Specific technologies required: Google Apps script - Google Sheets, Google Drive, Gmail
Extra notes: The scripts need to be written in Google Sheets apps script.
Kind of development: Customization of existing program
Num. of modules: possibly 3
Description of every module: Please see attached PDF for flow diagram and process notes.
The script needs to be written in Google Sheets apps script. The appropriate Google Sheets will be shared with the successful candidate.
Description of requirements/functionality: The aim is to enable staff to enter timesheet information for a month and submit the totals to the admin's summary spreadsheet. The summary spreadsheet data will be sent to the payroll department to facilitate payment of staff salaries on a monthly basis.
Teacher Monthly Timesheet Entry (gsheet)
Enter time and task details where some days need to support more than one entry (1 per line); need a "submit" button to submit the summary information to the Admin Monthly Staff Summary (gsheet); and a reset button to clear the form down for use in the new month (on submit could do a clear down instead of a separate "reset" button); on submit or reset, the script should make a backup copy of the current gsheet named with the following details, "timesheet" + teacher name + month + year, and shared with the admin email address (to be supplied)
Admin Monthly Staff Summary
Requires a manual check and sign-off that every teacher has submitted a timesheets (staff numbers and names change as business requires) before clicking on a "submit" button which would trigger a backup of the file and name it, "Staff Time Summary"+ month + year, email the current sheet to the Payrol dept (email to be supplied) and clear down the entries ready for the next month.
See PDF for logic and excel docs for example layouts of the gsheets.
CMS and Admin requirements: none
Specific technologies required: Google Apps script - Google Sheets, Google Drive, Gmail
Extra notes: The scripts need to be written in Google Sheets apps script.
Francois J.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
5 Oct 2015
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies