I need a simple job logging / time tracking database. This will be used for an IT service provider that needs to record how much time is spent at a customers site. At the moment the data is collected in Excel and each technician populates the spreadsheet. there are 7 columns of data that is collected (JobID, Date, Hours, Client, Job Description, Technician, Type). Find below a description of each column
JobID - Unique Job Identifier
Date - Date the job was completed
Hours - How many hours in total were spent
Client - Drop down list of which client logged the job
Job Description - A description of what was done on the job
Technician - which technician performed the job
Type - Was the job standard rate, double time, time & half or No Charge.
We would like to make this a PHP application so our technician can update this while they are out of the office.
We would like each Technician so have their own login and be able to assign users admin rights so they can delete jobs. So there should be a page to add/delete/edit technicians. There should be also a page to add/delete/edit clients.
All data should be able to be exported to PDF by a filer/report function and also exported to CSV.
We like the current Excel Spreadsheet format as you are able to easily tab across and add each column with ease as well as you can see all the jobs previously done.
I am happy to supply the current Excel spreadsheet we are using on request.
Please find attached the Excel spreadsheet we are currently using to record our jobs. The data in the spreadsheet is sample data and it also using Excel's condition formatting to color code the type.
There is another sheet within the workbook called 'client template'. at the end of the month, the timesheet is sorted per client by Excel's inbuilt filters, and then it is copied to the client template and exported to PDF to be emailed to the client.
Được trao cho:
10 freelancer đang chào giá trung bình $929 cho công việc này
Hello We can finish this website in the fixed time After we discuss more details we will provide detailed plans how to tackle this I want to see sample spreadsheet Thanks