Customized Solutions

CASE STUDY 1

PROBLEM

Client needs to automate time and attendance tracking of employees with the following requirements:

  • Determine early in and late in

  • Employee schedules vary daily and weekly

  • Total worked hours are used to calculate salary

  • Employees logging in even if not yet in the store location

SOLUTION

I built a timer and attendance web app using Google Sheets as the database. This app includes a signup feature to capture information of new employees, with the app assigning a unique User ID and automatically creating folders in the client’s Google Drive at user signup. A separate Manager Portal allows admin to pre-log employee schedules.

web app for business
web app for business

Signup web app that captures information of new employees and ensures consistent data across systems

google web app
google web app

Timer and attendance web app with geolocation lock

web app for business
web app for business

Timer and attendance web app with the ability to capture user clock in and clock out

With this app, the client achieved the following results:

  • Only employees with schedules logged in the Manager Portal can log in to the attendance app, ensuring data integrity and accuracy

  • Accurately records worked hours

  • Automates capturing of new employee information

  • Eliminates manual double-checking of clock-in and
    clock-out logs

  • Solves the problem of late employees changing their clock-in log as on time. With the geolocation API locking the app to a specific location, this ensures that users can only log in to the attendance app when they are within the vicinity of the store

  • Eliminates the hassle of employees needing to interface with a spreadsheet. Now they only need to open the web app on a browser, enter their User ID and password, and click a button to clock in or clock out for the day when they have a schedule

CASE STUDY 2

PROBLEM

Client selling motorcycle parts needs an application that will allow an employee to enter sales into their records. They also need the ability to record purchases and monitor inventory of items.

SOLUTION

I built two separate web apps, one for entering sales and another for entering purchases. The sales web app only allows adding and deleting entries, while the purchases web app allows adding, editing, and deleting entries. The client specifically uses a tablet device, so the web app is designed for this requirement.

With this custom-built web app, the client achieved the following results:

  • Record sales and purchases into Google Sheets databases. The app comes with multiple pages and contextual menus that provide the necessary functionalities to add, view, search, filter, and delete items from the databases

  • Automatically track inventory (batches and individual items)

  • Enable recording of batch purchases

  • Ensure data integrity and accuracy by creating unique IDs for entries, which is an essential feature for updating details and deleting entries

  • Automate generation of a unique code used to internally determine actual price of items

Custom-built web app for inventory and purchases using Google Sheets as databases

Project Builds

Like what you’ve seen?

Lets start a project or hire me for freelance gigs. Im open to a long-term partnership.

ninja@speedstersolutions.com

spreadsheet ninja
spreadsheet ninja