In Progress

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:
( 1 review ) kuala lumpur, Malaysia

Project ID: #16295528

Awarded to:


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
(33 Reviews)

31 freelancers are bidding on average RM578 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. [url removed, login to view] 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 [url removed, login to view] me a chance to prove myself. For more than 2 years I’ve More

RM1000 MYR in 10 days
(133 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)

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
(16 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
(18 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
(23 Reviews)
RM513 MYR in 3 days
(7 Reviews)
RM888 MYR in 3 days
(11 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)
RM555 MYR in 3 days
(2 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
(1 Review)
RM513 MYR in 3 days
(0 Reviews)

A proposal has not yet been provided

RM444 MYR in 2 days
(0 Reviews)

A proposal has not yet been provided

RM444 MYR in 2 days
(0 Reviews)
RM513 MYR in 3 days
(0 Reviews)

Hello, I read your requirement you looking for full stack developer I would be happy to assist you. Let us connect and discuss in detail.

RM222 MYR in 3 days
(0 Reviews)

A proposal has not yet been provided

RM666 MYR in 1 day
(0 Reviews)

Hello, Thanks for job posting I have gone through the job description and it would be my pleasure to get this opportunity. I will give you the 100% assistance. SKILLS: Wordpress, WordPress Multisite, WooCommerce More

RM513 MYR in 3 days
(1 Review)

As an engineer I have handled many small and large scale projects in my career so I think I will handle this project well. Thank You.

RM513 MYR in 3 days
(0 Reviews)

I'm a hardworking person and work and pass on time, no delay, no hassle for your project. Hire me with no regrets! Ready to get more done, let me shave hours off of your workweek. Whether it is business or personal, I More

RM99 MYR in 3 days
(0 Reviews)