We're looking for someone with experience using Google App Script to customize a Google Form and Spreadsheet. We're looking for someone who is a creative problem solver to help us find and build a solution that will satisfy our client, a small business owner. A successful project would likely open up opportunity for more jobs.
The objective of this project is to use Google Docs (Forms and Spreadsheets) to create a simple timesheet application for a small business. The solution must be simple for the company to use and maintain and be able to format the data in a way that satisfies their requirements.
Please see attached document for our idea of how this might work.
The desired workflow is for employees to enter their time each week through the use of a Google Form, and have these responses collected in a Google Spreadsheet. The management team would then process the responses using the Google Spreadsheet and prepare the data for their accountant to process payroll.
The challenge is that for their accounting needs, the company needs the spreadsheet which collects the form responses to display a project code instead of the project name. We cannot simply use the project code in the form because they mean nothing to the employees.
The Google Form should ask for Name, Date, Time In, Time Out, Project, and Task.
The Spreadsheet needs to display Employee name, Date, Time in, Time Out, Hours (calculated from time in/out), Project Code, Task Code and Approved (this will be added by the management team once the responses are in).
One possible solution that would be easy for the company to use would be to have a dropdown menu on the Google form driven by a spreadsheet that the business could use to enter projects and their codes. Each of the projects listed would become an option in the dropdown menu of the form. The project names would be displayed to the employee, but when submitted, the project code gets input into the spreadsheet.
It apppears Google App script can be used to accomplish this task. Doing a similar flow for tasks is a “nice to have” feature, but since these don’t change, we could probably figure out a different workaround if the complexity is too high.