Contact person: Business Client

Phone:Show

Email:Show

Location: medford, United States

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Freelance Software Developer – Truck Loading & Dispatch System (Airtable + Google Sheets)

Company: Beaver Pumice
Location: Remote
Project Type: Freelance / Contract
Start: Immediately

About Us

Beaver Pumice operates an active pumice mining and processing site in the U.S. We load and ship large volumes of pumice via truck, and we need a simple, reliable, and efficient software system to manage truck loading, tickets, customer orders, and daily production.

Project Overview

We are seeking a freelancer to design and build a custom truck-loading and dispatch management system using Airtable and Google Sheets, with automation layers as needed. The system must be extremely user-friendly for on-site personnel, fast to operate, and reliable in areas with limited connectivity.

The final tool will help our loader operators quickly enter truck data, automatically generate tickets, track loads against customer orders, and sync data to our internal office team.

Key Responsibilities

Design a simple and intuitive workflow for truck loading at the pumice mine.

Build structured databases in Airtable (or Google Sheets if needed for redundancy).

Create easy input screens/forms for loader operators (mobile/tablet-friendly).

Automate:

Ticket generation

Customer order tracking

Daily production summaries

Driver/truck logs

Ensure data syncs smoothly between on-site entry and office staff.

Create reporting dashboards (loads per day, tonnage totals, customer breakdowns, etc.).

Provide basic documentation and brief training for our staff.

Integration (optional but preferred): QuickBooks, [login to view URL], Zapier, or API connections.

Required Skills & Experience

Strong experience building workflow systems using Airtable and Google Sheets.

Ability to create clean, simple user interfaces suitable for non-technical users.

Familiarity with automation tools (Make, Zapier, Airtable Automations).

Ability to understand real-world operational processes (dispatch, logistics, inventory).

Experience working with construction, mining, or trucking industries is a plus.

Deliverables

Fully functional truck-loading entry system

Automated ticket generator (PDF or printable format)

Customer order and inventory tracking tables

Operator-facing input screen or mobile-friendly form

Admin dashboard for office and management

Documentation + training session

Ideal Candidate Traits

Can think through operational problems

Communicates clearly

Designs very simple tools that workers can use with minimal training

Available for ongoing support or enhancements after initial build (optional)

How to Apply

Please submit:

A brief description of your relevant Airtable/Sheets experience

Examples of similar workflow tools or automation systems you’ve built

Your estimated timeline and budget for a project like this

Your hourly rate or fixed-price proposal" (client-provided description)