Daily report spreadsheet and google form

TASK 1 - To create a google form that automatically submits data into the spreadsheet

1. Date

- dropdown to select the date

2. Employee name

- space for employee to type his/her name

3. Department

- dropdown for the following options : Purchasing, Design, Site, Store

4. Category of work

- dropdown dependant on the department of choice

- Purchasing will have dropdown options : 1, 2, 3

- Design will have dropdown options : 1, 2, 3, 4

- Site will have dropdown options : 1, 2, 3, 4, 5

- Store will have dropdown options : 1, 2, 3, 4, 5, 6 (6 options total)

I will amend these at a later time.

5. Description of work

- empty text box for employees to type in

I will also need an option to 'ADD ANOTHER' for category of work and description of work after the first option is complete as some individuals will have completed multiple assignments during the working day.

TASK 2 - To create a google form spreadsheet with the following columns :

1. Date of submission

2. Date

3. Employee e-mail address

- automatic from the email address used to submit the google form

4. Employee name

5. Department

6. Category of work

7. Subcategory of work

8. Description of work

9. Checked

- This column needs to have individual check-boxes that are ticked when clicked on.

10. Satisfactory

- This column needs to have individual check-boxes that are ticked when clicked on. If this is not clicked/ticked but 9. Checked is ticked, then the row will be highlighted in red

TASK 3 - A summary of results on an annual basis to be completed on a separate sheet. With a monthly breakdown of each individual. If an individual has incomplete or unsatisfactory reporting, their name will be highlighted red for that month on this summary for that month.

Skills: Excel, HTML, Javascript, PHP, WordPress

See more: web form to google spreadsheet, publish google form to web, google form to spreadsheet, google form report, daily report spreadsheet, daily report spreadsheet retail, daily report spreadsheet template, google form theme create, google spreadsheet design form, google form spreadsheet, writing google spreadsheet php form, template jobsite daily report form, google form create pdf, daily report form sample designers, working daily report form, security daily report form, companies daily report form samples, government job daily report form, job daily report form, daily report form

About the Employer:
( 4 reviews ) kuala lumpur, Malaysia

Project ID: #16295528

29 freelancers are bidding on average RM583 for this job


Hi, Kindly share me more details so that i can give you estimated time and cost. Please check my below work.. 1. Case Management system. [login to view URL] you can crea More

RM513 MYR in 3 days
(24 Reviews)

Sir, I will do it for you with perfection and will keep working on it until you are 110% satisfied. I am looking for opportunities to excel in this [login to view URL] me a chance to prove myself. For more than 2 years I’ve More

RM1000 MYR in 10 days
(167 Reviews)
RM513 MYR in 3 days
(82 Reviews)

Dear Sir/Madam, Thank you for reading my proposal. I am expert in Admin support, Customer support, eCommerce product listing, Online Marketing and Web Development services . I have following experience of work wh More

RM513 MYR in 3 days
(4 Reviews)

We are having very good impact in market since last few months with our very accurate timely delivery and quality of work being delivered . We assured you quality and timely completion of this project which you can con More

RM1800 MYR in 6 days
(38 Reviews)

Hi there, I will be happy to help you with that. The first and second task are really simple. There is nothing challenging about the form and the spreadsheet. While we use a Google Script to compelte the third task More

RM988 MYR in 5 days
(33 Reviews)

Hi AM READY TO START NOW. I read through the job details carefully and I am absolutely sure that we can do the project very well. Our skill... WORDPRESS, PHP, mySQL, HTML, JS, CSS > Template design > ecommerce d More

RM735 MYR in 3 days
(41 Reviews)

Hey I will not praise my self here. I just want to tell you that I can this do easily. and I want your support to build up my business in this field. If you believe to give opportunities to new freelancer then You c More

RM99 MYR in 1 day
(8 Reviews)

Hi hope you are doing well. I have taken a look at your task and I have confidence that we can work together, I have lot of experience in this field, so give us a chance to work with you. Once you give as a cha More

RM616 MYR in 3 days
(26 Reviews)
RM555 MYR in 3 days
(44 Reviews)

Hello, sir. I have Gone thoroughly your requirement as you stated in the bid description .I am a Wordpress developer with an experience of 5+ years in creating and customizing WP themes and plugins. I am well equipped More

RM513 MYR in 3 days
(3 Reviews)
RM888 MYR in 3 days
(13 Reviews)

I'm experienced in Google Forms and Sheets and I can do your work well. I have many examples of similar tasks solved in my Portfolio. My area of expertise is data science and statistics.

RM400 MYR in 2 days
(2 Reviews)

Having wide-spread knowledge and experience about website development, website designing and mobile application, graphics development, Content Writing, Virtual Assistant, graphics design, digital marketing. Have succes More

RM800 MYR in 2 days
(1 Review)

We can deliver this project fast as I have a well trained team at my disposal. And you can rely on us for complete satisfaction

RM99 MYR in 2 days
(4 Reviews)

A proposal has not yet been provided

RM722 MYR in 4 days
(2 Reviews)

I'm good in spreadsheet work especially Google Drive files. I have already worked for successful projects like this

RM444 MYR in 3 days
(0 Reviews)
RM513 MYR in 3 days
(0 Reviews)
RM116 MYR in 3 days
(1 Review)

A proposal has not yet been provided

RM444 MYR in 2 days
(0 Reviews)