Case study · Mobile & Web Apps (Google Workspace)

Live Tally Stock Lookup on Mobile

Live stock from two Tally companies pushed to Google Sheets and searchable on any phone - no Tally licence or VPN.

The challenge

Sales staff away from the office had no way to check whether an item was in stock without phoning the accounts desk and waiting for someone to look it up in Tally.

What we built

We paired two pieces of software: a Windows job that reads live stock positions from Tally and writes them into a Google Sheet, and a mobile web app that serves a fast, searchable view over that sheet. Because the client runs two Tally companies, the tool refreshes each company's quantity column independently against the item rows rather than rebuilding the sheet, so both stock positions sit side by side against a single item list. Anyone with the link gets current stock on their phone - no Tally licence, no VPN, no phone call. The search page is a deployed web app that shows each item's stock company by company with a running total.

The result

Before: phone the accounts desk. Now: stock on the phone.

Related case studies

Mobile & Web Apps (Google Workspace)

QR-Based Order Booking and Billing App

Retail exhibition organiser

QR-code mobile ordering and multi-mode billing for a 5,000-visitor sale event, backed by Google Sheets.

Before10-15 minutes per bill
→
Nowseconds per customer
Mobile & Web Apps (Google Workspace)

Vehicle Loading Status Tracker with Customer Alerts

Steel trading house

Yard supervisors update vehicle status in four taps and customers get an automatic email at every stage.

Beforeconstant customer phone calls
→
Nowzero calls
Mobile & Web Apps (Google Workspace)

Barcode-Based Invoice Document Tracking

Manufacturing company

Supplier invoices barcoded and scanned by each department, with a dashboard showing where every document is.

Beforedocuments regularly went missing
→
Nowfull movement history

← Search all 60 case studies

Have a process like this on your desk?

Tell us how the work is done today. We will show you what can be automated - usually a working version within days.