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.

Taidot: Excel, HTML, Javascript, PHP, WordPress

Näytä lisää: 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

Tietoa työnantajasta:
( 4 arvostelua ) kuala lumpur, Malaysia

Projektin tunnus: #16295528

29 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

RM513 MYR 3 päivässä
(24 arvostelua)

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 Lisää

RM1000 MYR 10 päivässä
(167 arvostelua)
RM513 MYR 3 päivässä
(82 arvostelua)

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 Lisää

RM513 MYR 3 päivässä
(4 arvostelua)

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 Lisää

RM1800 MYR 6 päivässä
(38 arvostelua)

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 Lisää

RM988 MYR 5 päivässä
(33 arvostelua)

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 Lisää

RM735 MYR 3 päivässä
(41 arvostelua)

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 Lisää

RM99 MYR 1 päivässä
(8 arvostelua)

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 Lisää

RM616 MYR 3 päivässä
(26 arvostelua)
RM555 MYR 3 päivässä
(44 arvostelua)

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 Lisää

RM513 MYR 3 päivässä
(3 arvostelua)
RM888 MYR 3 päivässä
(13 arvostelua)

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 2 päivässä
(2 arvostelua)

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 Lisää

RM800 MYR 2 päivässä
(1 arvostelu)

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 2 päivässä
(4 arvostelua)

A proposal has not yet been provided

RM722 MYR 4 päivässä
(2 arvostelua)

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

RM444 MYR 3 päivässä
(0 arvostelua)
RM513 MYR 3 päivässä
(0 arvostelua)
RM116 MYR 3 päivässä
(1 arvostelu)

A proposal has not yet been provided

RM444 MYR 2 päivässä
(0 arvostelua)