Build a small online database that communicates with TSheets

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]

Kemahiran: Pengaturcaraan Pangkalan Data, PHP, SQL

Lihat lagi: Build a small online dating , Build a small online dating asp.net web site., build an awards website with a small online store, tsheets free trial, tsheets app, tsheets tracking, tsheets desktop, pricing for tsheets, tsheets integrations, time reporting, timesheet and payroll software, php, java, mysql, sql, python, database programming, build server india small business database raid, app build online database, mp3 tags online database api

Tentang Majikan:
( 0 ulasan ) Rosenort, Canada

ID Projek: #16641795

Dianugerahkan kepada:


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 dalam 10 hari
(200 Ulasan)

29 pekerja bebas membida secara purata $1422 untuk pekerjaan ini


Hi there, I have checked your project brief very carefully and can integrate [login to view URL] API to build a new database. I have several years of experience designing and developing website and already developed many cust Lagi

$1323 CAD dalam 20 hari
(1157 Ulasan)
$1323 CAD dalam 20 hari
(199 Ulasan)

Get The Best Service In Fair Price!!  Hi There I have checked the requirement to create a online database that communicates with TSheets. I have more than 9 years of experience in this domain personally to m Lagi

$1764 CAD dalam 25 hari
(104 Ulasan)

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 Lagi

$1058 CAD dalam 20 hari
(106 Ulasan)

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 dalam 20 hari
(337 Ulasan)

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

$1558 CAD dalam 30 hari
(84 Ulasan)

Hello, Hope you are doing well. We have gone through the details and can do the project tracking application for you. We can integrate Tsheets into the wbesite and save data into database. We can use the data to Lagi

$1764 CAD dalam 45 hari
(114 Ulasan)

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 Lagi

$1250 CAD dalam 10 hari
(33 Ulasan)

Hi I am an highly experienced web developer. I have already developed a web app where I ahve integrated [login to view URL] into my php app and the rosters are fetched and put in db. I can discuss the project further with y Lagi

$1333 CAD dalam 20 hari
(98 Ulasan)

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

$1500 CAD dalam 30 hari
(96 Ulasan)

Hi, I checked your project details and checked the [login to view URL] I need few more details and need to discuss some points so I can provide you proper budget and time line. Please check Lagi

$1323 CAD dalam 35 hari
(56 Ulasan)
$1250 CAD dalam 20 hari
(67 Ulasan)

I have reviewed your project description and understood your project scope, would love to discuss your project over chat. This is Jannica from MT-Pixels one of the top web & App development company in Texas, USA. Lagi

$1500 CAD dalam 21 hari
(17 Ulasan)

Hello sir we are expert in database management,Blockchain,ICO, php,codeigniter,Laravel,Lumin,cake php,asp.net,c#,wordpress,opencart,Magento,javascript,Angularjs,node.js,jquery,ajax,html, css,html5,[login to view URL] have strong Lagi

$1250 CAD dalam 20 hari
(30 Ulasan)

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.

$1000 CAD dalam 15 hari
(23 Ulasan)

Hi, Can we discuss in more details, i guess i have a better solution then TSheet. i have an android application that is used for taking finger prints to take attendance. rest project and payroll we can calu Pleas Lagi

$2000 CAD dalam 20 hari
(22 Ulasan)

Hi, I have have got experience with these and have 7+ years of experience in PHP/MySQL based Web Designing and Development including CMS coding conventions and configurations. Please check my best PHP works: = Lagi

$1529 CAD dalam 20 hari
(34 Ulasan)

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

$1529 CAD dalam 20 hari
(23 Ulasan)

Hello, I can understand that you want to improve & update Time & Project Tracking System with the help of TSheets.com. I have read your Job Description extremely carefully and It is pretty much doable. Also I am Lagi

$4552 CAD dalam 20 hari
(5 Ulasan)

100% JOB COMPLETED, 100% ON TIME, 100% ON BUDGET on freelancer.com [login to view URL] Hello sir. I checked your project description and I am very interested in this job Lagi

$1250 CAD dalam 20 hari
(5 Ulasan)