Skip to main content

Records warehouse management system

Record Hold: Every stored file tracked, found in seconds and billed

A records storage system for a Riyadh provider that keeps clients' paper files in numbered boxes. It tracks every box, file and shelf, prints barcode labels and turns the activity into monthly VAT invoices.

Industry
Records Management
Platform
Web App
Market
Riyadh, Saudi Arabia
Record Hold dashboard on desktop with files indexed, boxes, retrievals and delivery notes, and File Track on mobile
Record Hold indexing table listing files by box number, claim number and folder
1 / 9

Record Hold dashboard and File Track

Build at a glance

API endpoints
74
Screens
25
Database tables
16
User roles
3

01 Overview

About Record Hold

Record Hold is a records storage system for a Riyadh provider that keeps its clients' paper files in numbered boxes on warehouse shelves. It tracks every box, file and shelf location, prints barcode labels, follows files out and back, and turns that activity into monthly VAT invoices.

A storage provider's whole business is knowing where a given file is. When a client calls for a claim, someone has to find the box, find the shelf, pull the file and note who took it. We built the web application and a REST API on top of the client's existing SQL Server database.

02 The challenge

What Record Hold needed to solve

The provider ran this work on spreadsheets and an old desktop program, which lost time and sometimes lost files.

  1. When a client asked for a file, staff had to track down the box and the shelf, and files were sometimes lost.

  2. The new system had to work with the client's existing SQL Server tables exactly as they were.

  3. Boxes and shelf locations needed barcode labels that staff can scan.

  4. Every month the provider still had to bill each client from the same data that tracks boxes and file movements.

03 What we built

How we built Record Hold

We built a React and TypeScript web app on a Node.js and Express API that talks to SQL Server through hand-written queries. Billing reads the same records that track boxes, files and movements.

  • Indexing and search

    Staff index files by box, claim, company and location. The search engine filters by company, file number, box number, memo, ID number and warehouse, and long lists are paged and cached for short periods.

  • File Track

    Every movement out and back is recorded with the claim, box, out date, who sent it, page count and charges. Each file shows a status such as out, pending, delivered or returned, and keeps a full tracking history.

  • Boxes Master and box tagging

    Each box has a number, description, type and owning company. Box Tagging assigns a box to a shelf location and lists the files inside it.

  • Shelf locations and barcode labels

    Each location is addressed by warehouse, bay, section, aisle, row, level and depth, with a flag for whether it is in use. Staff print 104 mm barcode labels for boxes and shelves.

  • Client companies and deliveries

    Client companies are kept with English and Arabic names, contacts and addresses. Delivery notes record the date, company, total files and pages, and move from scheduled to in progress to completed.

  • Billing and accounting

    Billing turns the same records into bill headers, line items and payments. The accounting section also covers products, statements of account and an accounting report.

  • Bilingual tax invoices

    Monthly tax invoices are produced in English and Arabic with VAT and a QR code, covering services such as box storage, file retrieval and delivery, and scanning. Each invoice can be downloaded as a PDF or printed.

  • Dashboard, exports and access

    The dashboard shows files indexed, boxes, retrievals, delivery notes and weekly activity. Users sign in with an access token and a longer-lived refresh token, non-admin users only see their own company's data, and exports run through ExcelJS and jsPDF.

04 The results

What changed for Record Hold

Record Hold gives the provider an exact index of every box and file and a monthly bill built from the same data.

  • Staff find a file in seconds instead of searching shelves and spreadsheets.
  • Boxes and shelves carry barcode labels that scan.
  • Each file has a full history of its movements out and back.
  • Clients receive bilingual tax invoices without anyone retyping figures.
  • The web app and API run on the client's existing SQL Server tables exactly as they were.
  • ONE CCL admin dashboard on desktop and employee app home screen on a phone

    Employee communications app

    ONE CCL

    ONE CCL is an employee communications app for iOS and Android where CCL staff read news, register for events, thank colleagues and track approvals.

    Platforms: iOS App, Android App, Admin Dashboard

  • Inbo AI email assistant marketing site on desktop and review queue dashboard on mobile

    AI email assistant

    Inbo

    An AI email assistant for Gmail and Outlook that drafts replies in the user's own voice before they open their inbox, and holds sensitive mail until a person decides.

    Platforms: Web App, Website

  • Malto.io customer feedback platform admin overview on desktop beside the mobile marketing site

    Customer feedback platform

    Malto.io

    A customer feedback platform for software companies: users post and vote on ideas, follow a public roadmap, and the team gets AI summaries.

    Platforms: Web App, Admin Dashboard, Website

Planning something like Record Hold? Tell us what you need built. We’ll give you a straight answer on fit, then a clear plan with scope, timeline and cost before any build work starts.