Build a small online database that communicates with TSheets
$750-1500 CAD
Paid on delivery
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?)
UI
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]
Project ID: #16641795
About the project
Awarded to:
How will user roles will use this application? I saw there are 5 employees, I am assuming this will be used for internal purpose only?
24 freelancers are bidding on average $1440 for this job
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
Dear Employer Hope you are doing well Coming to your project scope we will develop your database which will pull the hours worked out of Tsheets that will be based on jobs grouped together by projects. Ping us via More
Hello, I Have gone through the project description provided , but need to ask few points. So please click Chat button to send me a text message when you have time to discuss. At present I am placing a placeholder bid More
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, 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
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.
Dear sir I am interested in this project and can do it. I am familiar with tsheets api and I have done a similar project. I am ready to work for you. Looking forward to hearing from you soon. Best Regards, More
Hi, thank you for looking at my cover letter. I’ve carefully gone through your job posting. I can work with you anytime you want. I believe I possess the necessary skills and experience you are seeking. I look for More
Hello, I have briefly read the description on online database development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.
Hi, Thank you for posting the project. We will love working with you, it is nice when you found a client that knows what he wants! Nice specs. I think that my company it is a perfect fit for this project. You wi More
