Build a small online database that communicates with TSheets

$750-1500 CAD

Completed

Posted

about 6 years ago

$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]

Database Programming

PHP

SQL

Project ID: 16641795

About the project

24 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@WebInfoSolutions

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?

$833 CAD in 10 days

4.9

(254 reviews)

7.9

24 freelancers are bidding on average $1,440 CAD for this job

@tojisb059

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

$988 CAD in 20 days

4.9

(581 reviews)

9.2

@augurstech

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 freelancer chat box so that we can discuss all details with you and take this project to development stage we have team of exp database experts in our company with 4-9 years of experience and we will deliver you quality and professional work I will be eagerly waiting for your reply asap Warm Regards Sam

$1,058 CAD in 20 days

4.9

(227 reviews)

9.3

@hiretechexperts

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 amount as the amount field is required to submit this bid. Thanks & Regards Hire Tech Experts

$1,250 CAD in 10 days

5.0

(77 reviews)

8.3

@asifchaudhry2015

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

$1,500 CAD in 30 days

5.0

(264 reviews)

8.5

@dotcomdotbd

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

$1,558 CAD in 30 days

4.9

(86 reviews)

7.5

@xiqian88

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.

$1,000 CAD in 15 days

5.0

(39 reviews)

7.1

@zhangyingtai

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, Yongtao

$1,529 CAD in 20 days

4.9

(52 reviews)

6.9

@gr8tech

Hello there, I will provide integration between your application and Tsheets through the provided API. On the database side, I can use Access or a PHP/MySQL/MariaDB for the online database. I have gone through your project description and we will need to discuss and agree on the items to be captured in the database. Kindly confirm if you have a hosting company for the online database. However for the development phase, I will provide a link with the hosted app, which will later be transferred to you host. I look forward to hearing from you. Moosa

$823 CAD in 20 days

4.8

(30 reviews)

5.3

@WebStar426

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 forward to meeting with you this week and discussing the details of this position. I will be able to start your project as soon as possible according to you. Thank you for your consideration Best Regards Ethan Ivanov

$1,111 CAD in 20 days

4.8

(6 reviews)

3.0

@VirtualBrainInc

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.

$2,000 CAD in 20 days

5.0

(6 reviews)

3.0

@gsoftwareinc

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 will not be dealing with a solo developer that can disappear in the middle of the project. We will deliver the work quick, I think this is a great opportunity to get your work done cheap, fast and with quality. Pls, let me know if you have time for a chat or maybe a call. Thanks

$750 CAD in 7 days