Simple Jog Logging / Time Sheet Database

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.


Näytä lisää: total jobs login, technicians jobs, technician jobs in, technician jobs, service technician jobs, service technician, logging jobs, job technician, jobs using excel, jobs technician, jobs in an office, job for a c technician, job description it technician, job description for it technician, it technician job description, i need a technician, how to find technicians, find technicians, find technician, column jobs, what type of jobs are there, what are service jobs, how to add time, customers service jobs, need technicians

Tietoa työnantajasta:
( 2 arvostelua ) Fyshwick, Australia

Projektin tunnus: #1709943

Myönnetty käyttäjälle:


Dear sir. I sent you a private message. Please check it. Regards.

$750 AUD 10 päivässä
(84 Arvostelua)

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


Hi, Immediately ready for your work, please check PM for details.

$1200 AUD 30 päivässä
(95 arvostelua)

Experts here please check pmb for more details. Thanks

$800 AUD 25 päivässä
(23 arvostelua)

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

$800 AUD 20 päivässä
(40 arvostelua)

Please check my message for further details thanks

$790 AUD 15 päivässä
(11 arvostelua)

can do it for you.

$750 AUD 4 päivässä
(6 arvostelua)

Hello: I've done similar apps in the past many times. I have good experience with generating both pdf end excel files on the fly (if needed for reporting etc.) I will also include a specially optimized version of Lisää

$750 AUD 7 päivässä
(5 arvostelua)

We are providing this service so affordable because we want to prove our expertise, build a longterm relationship so when you have other IT needs, and substantiate a Freelance record of good customer relations. To dis Lisää

$1200 AUD 14 päivässä
(4 arvostelua)

hello sir, i fully understood your requirement you basically need:- 1 Login system 2 Database system and its frontend to manage and edit entries 3 export the required data in the form on PDF file if any thing Lisää

$750 AUD 15 päivässä
(0 arvostelua)

Custom software development - <b><i>Removed by Admin</i></b>

$1500 AUD 1 päivässä
(0 arvostelua)