Version 6.6

FieldVoice Pro

AI-Powered Field Reporting for Construction Inspectors

Save 1+ hour daily on DOT-compliant documentation

26,768
Lines of Code
13
HTML Pages
22
JS Modules
17
Database Tables
106
Total Files

Executive Summary

Voice-powered construction documentation that transforms field notes into professional DOT reports

📱

What It Is

A mobile-optimized Progressive Web App (PWA) for construction field documentation. Enables RPRs and inspectors to quickly document daily work using voice dictation, generating professional DOT-compliant reports.

👷

Who Uses It

Resident Project Representatives (RPRs), construction inspectors, and field engineers working on DOT (Department of Transportation) construction projects.

🎯

The Problem

Manual paper-based reporting is time-consuming, error-prone, and lacks consistency. Field staff spend hours each day on documentation instead of inspection work.

✨

The Solution

Voice-first capture with AI refinement. Speak your notes, snap photos with GPS, and let AI transform informal field notes into professional DOT-format reports.

🔌

Offline-First

Full PWA support with localStorage and IndexedDB caching. Capture data in the field without connectivity, sync when back online.

📄

Instant PDF

Generate print-ready DOT RPR Daily Reports with one tap. Professional formatting, GPS-verified photos, and digital signatures.

System Architecture

Three-tier architecture: Mobile PWA → Supabase Backend → n8n AI Processing

📱 Mobile PWA
Vanilla JS + Tailwind CSS
⟷
🗄️ Supabase
PostgreSQL + Storage
⟷
🤖 n8n Webhooks
AI Processing
💾
localStorage
Quick state
🗃️
IndexedDB
Offline cache
🐘
PostgreSQL
17 tables
📦
Storage Bucket
Photos & PDFs
🧠
AI Refinement
Text processing
📑
Doc Extraction
PDF/DOCX import

User Flow

From field capture to submitted report in 8 steps

1

Open App

Dashboard shows active project & today's status

2

Begin Report

Select project, auto-fetch weather

3

Quick Interview

Voice/text notes, GPS photos

4

AI Processing

15-20 sec refinement via n8n

5

Report Review

Edit AI-refined content

6

Final Review

DOT format preview

7

Submit

Generate PDF, archive

8

View PDF

Google Docs viewer

Capture Modes

⚡

Quick Notes (Freeform)

Single freeform textarea for fast dictation-first workflow. Best for experienced users who want minimal structure.

📋

Guided Sections

5 expandable section cards: Weather & Site, Contractor Activities, Issues & Delays, Safety, and Progress Photos.

Database Schema

17 PostgreSQL tables with full relational integrity

Entity Relationship Diagram

projects CORE
🔑 id UUID
project_name TEXT
noab_project_no TEXT
location TEXT
prime_contractor TEXT
notice_to_proceed DATE
status TEXT
reports CORE
🔑 id UUID
→ project_id UUID
report_date DATE
status TEXT
capture_mode TEXT
inspector_name TEXT
toggle_states JSONB
contractors
🔑 id UUID
→ project_id UUID
name TEXT
type TEXT
trades TEXT[]
report_entries
🔑 id UUID
→ report_id UUID
section TEXT
content TEXT
→ contractor_id UUID
report_raw_capture
🔑 id UUID
→ report_id UUID
capture_mode TEXT
raw_data JSONB
weather JSONB
photos
🔑 id UUID
→ report_id UUID
storage_path TEXT
caption TEXT
location_lat NUMERIC
location_lng NUMERIC
ai_responses
🔑 id UUID
→ report_id UUID
raw_response JSONB
generated_content JSONB
final_reports
🔑 id UUID
→ report_id UUID
pdf_url TEXT
executive_summary TEXT
contractors_json JSONB
user_profiles
🔑 id UUID
full_name TEXT
title TEXT
company TEXT
email TEXT

Additional Tables

equipment · report_contractor_work · report_personnel · report_equipment_usage · report_ai_request · report_ai_response · report_user_edits · report_final

Technology Stack

Modern, no-build-step architecture optimized for mobile field use

Frontend

Vanilla JavaScriptES6+ Modules
Tailwind CSSCDN v3.x
Font Awesomev6.4.0
PWAService Worker

Backend & Storage

SupabasePostgreSQL + Auth
Supabase StoragePhoto Bucket
localStorageQuick State
IndexedDBOffline Cache

External APIs

n8n WebhooksAI Processing
Open-MeteoWeather API
Geolocation APIGPS Coords

Browser APIs

MediaDevicesCamera
Canvas APICompression
FileReaderDoc Import
Drag & DropFile Upload

Key Features

Purpose-built for construction field documentation

🎤

Voice-First Capture

Native keyboard dictation support on iOS and Android. Speak naturally, let AI refine.

🤖

AI Refinement

Transform informal field notes into professional DOT-compliant language in 15-20 seconds.

📍

GPS-Tagged Photos

Every photo automatically tagged with high-accuracy GPS coordinates and timestamps.

📴

Offline-First PWA

Full functionality without connectivity. Auto-sync when back online.

📄

Document Import

Extract project data from existing PDF/DOCX reports via AI-powered extraction.

🖨️

Instant PDF Generation

Print-ready DOT RPR Daily Reports with professional formatting.

☁️

Cloud Sync

Multi-device sync via Supabase. Access reports from any device.

🌤️

Auto Weather

Automatic weather data via Open-Meteo API based on GPS location.

Application Pages

13 HTML pages with 22 shared JavaScript modules

Page Lines Purpose
index.html 1,002 Home dashboard with project selection and weather
quick-interview.html 3,912 Daily report capture (Quick Notes / Guided Sections)
report.html 3,219 AI-populated editable DOT form
finalreview.html 2,273 Read-only DOT RPR viewer with print layout
archives.html 477 Report history with swipe-to-delete
drafts.html 614 Offline queue and draft management
project-config.html 1,857 Project management with document import
permissions.html 1,530 Permission setup (mic, camera, GPS)
settings.html 458 Inspector profile (name, title, signature)
landing.html 1,494 Marketing/onboarding landing page

JavaScript Modules

  • 📁 js/
    • config.js — Supabase credentials
    • storage-keys.js — localStorage structure (v6)
    • report-rules.js — Business rules validation (v6)
    • supabase-utils.js — Data converters (snake_case ↔ camelCase)
    • sync-manager.js — Real-time backup & offline sync
    • data-layer.js — Single source for data operations
    • indexeddb-utils.js — IndexedDB operations
    • pwa-utils.js — Service worker, offline banner
    • ui-utils.js — escapeHtml, generateId, showToast
    • media-utils.js — Photo compression, GPS
    • project-config.js — Project page logic
    • quick-interview.js — Interview page logic (5,124 lines)
    • finalreview.js — Final review logic (1,970 lines)
    • archives.js — Archives page logic
    • index.js — Dashboard logic
    • sw.js — Service worker (cache v1.11.0)