Timesheet App

An engineering company in the States hired me in October/November 2017 to design and program an internal timesheet web app for their staff and contractors.

The back end of the app was implemented in PHP by the client, using open source CRM software. My job was to create the frontend, using API calls to obtain and save data. Design guidelines were provided, based on their existing solution, but I was free to interpret the requirements using my own judgement. Responsive design was optional, but as everything is responsive nowadays, I implemented it well, working on devices down to an iPhone 4.

Some of the features: a login form to authenticate users and an API/cookie system to keep them logged in for a week, the ability to add and delete rows, no entry allowed in timesheets marked as submitted, Excel-like navigation of cells, highlighting of holidays, and autocomplete in the project name input.

No framework was used, preferring a vanilla HTML/CSS/Javascript solution. I like the lesson of MVC frameworks, but once that lesson is learnt, I find that “rolling your own” is usually more efficient (except, perhaps, when working in a team). Not even jQuery was used, for the sake of performance.

Note that the screenshot shows an in-progress version, the Activity column was later removed.

This was a demanding but satisfying project, an experience I hope to repeat.

Previous

Next