SYSTEM DEVELOPMENT

Google Apps Script

Automation

AppSheet

App Interface

Looker Studio

Report / Analysis

Water Laundry (San Po Kong) 24-hour self-service laundromat - Automated Settlement System

Octopus Company sends a CSV file containing the day's revenue to an email every night. Employees check their inbox the next morning, download the attachment, and manually import the file into Excel for recording and data analysis.

This process is time-consuming and prone to errors. Therefore, the store owner adopted our solution to automate this repetitive daily task using Gmail, Google Apps Script, and Google Spreadsheet. Now, employees can focus on analyzing daily data.

Skyroam - SIMs Inventory and Service Provider Support Record System

To address the logistical challenges faced by our client, we developed two integrated software solutions. 

Firstly, a real-time inventory management system was implemented to accurately track SIM card stock levels across various delivery and usage periods. This system replaces the previous manual tracking method using Excel spreadsheets, which lacked the granularity necessary for effective time-sensitive management. 

Secondly, we deployed a comprehensive time-tracking system to streamline the billing process between Skyroam and its local service providers. These systems enhance operational efficiency and financial transparency.

Master Chain Limited - Tacket Management System

TVP Project No.:  TVP/2172/19

Master Chain Limited is a company specializing in providing support services. As customer inquiries primarily come through email and service follow-ups are solely handled by the initial point of contact, work efficiency has been hindered.

To enhance operational efficiency, we have developed a comprehensive case management system utilizing Google Apps Script, leveraging the capabilities of Gmail, Google Groups, and Google Sheets within Google Workspace. This system empowers all employees to seamlessly track customer inquiries and support requests, fostering effective team collaboration.

Big East Environment Engineering Limited - Clockin / Clockout and Project Management System

TVP Project No.: TVP/4904/20

Due to the nature of hiring daily-rated workers in construction projects and the lack of a systematic recording system, there is a high risk of payroll errors. Moreover, for smaller projects that require only one or two workers, supervisors must constantly travel between different sites, resulting in significant time consumption.

To address these challenges, we have developed a mobile time and attendance app that enables workers to clock in and out at the start and end of their shifts. The HR department can then view real-time data on the number of workers present and their locations, facilitating accurate monthly payroll calculations.

In addition, our project management app allows supervisors to add project tasks and assign them to workers. Workers can update their progress and upload project photos within the app, enabling supervisors to monitor the project status from anywhere at any time.

Global King Mortgage Limited - File Scanning Management System

With the ever-increasing volume of mortgage documents and limited office space, paperless operations have become an irreversible trend in recent years. However, the security concerns associated with directly transferring scanned documents from all-in-one network scanners to computers or servers have hindered the full implementation of paperless offices.

To address this issue, we propose an innovative solution: utilizing Gmail as an intermediate station for document transfer instead of traditional computers or servers. Once scanned, documents are first sent to Gmail. Subsequently, Google Apps Script is employed to automatically store these documents in Google Drive and delete the original scanned emails. This approach not only effectively reduces redundant file storage but also leverages the powerful search capabilities of Google Drive, enabling us to quickly and accurately locate the required documents and data.