We are a 5 employee manufacturing business that is looking to improve our time/project tracking system. Currently we use a Microsoft Access program. We would like to integrate [login to view URL] for a better payroll system, and then build a new database online.
The database would pull the hours worked out of TSheets. The database would update the Job list so TSheet employees could only clock in to Jobs that were not closed.
The database would be based on Jobs, grouped together by Projects.
I don't know a lot about databases so I will explain the project in a way I think is best but feel free to change the layout if you think that would make more sense.
There would be a Jobs table. Job(unique); Project; DueDate; Status; Jobdescription
Project table. Project(unique); Customer; Projectdescription; Projectduedate
Customer table. Customer(unique); ??
Table to contain time info retrieved from TSheets. Employee; Date; ClockIn; ClockOut; Job; Description; Hours(calculated field?)
We would like 1 view showing Jobs, sorted by status, with the total hours and an editable status.
1 view showing Projects. Projects that have 1 or more uncompleted Jobs would at the top of the list. Clicking on the Project would show a pop up with all associated Jobs.
1 view showing data retrieved from TSheets.
TSheets API: [login to view URL]
29 pekerja bebas membida secara purata $1422 untuk pekerjaan ini
hello, how are you? I am a skilled website developer and I have worked on the similar projects, I can do this job on time with some great results. let's have a chat session to discuss details. thank you
Hello, PHP expert here. I've just checked the API doc. Its a RESTFull API, also they have git repo. So it won't be a problem get the data. Please lets discuss more detail. Thanks
Hi there, I am Senior PHP Developer. I checked TSheets API and I am really confident to do this project for you as per your posted requirement. I have a great experience. Let's discuss with me. Thanks
Hello sir I read your proposal and i am interested in your project I have rich experience in Ruby on Rails and Angularjs,Laravel,ASP.NET I am sure i can satisfy you in time Regards.