Case study · Construction inspection
From a fillable PDF to a daily inspection report app
Inspectors on a construction project filled in a fillable PDF every day, pressing “Add sheet” whenever they ran out of room. Nothing in those PDFs could be searched across the project. We built a Retool app where inspectors fill in the report on screen, save drafts, attach photos and submit, and still download a PDF in the layout the engineer expects.
The challenge
What wasn’t working
The daily report covers a lot: shift, weather and temperature, safety deficiencies, visitors, workforce and equipment by contractor, quantities measured for payment, and photos.
In a fillable PDF, every report was a separate file. Nobody could ask “which contractors were on site last month?” without opening files one by one.
Inspectors often fill the report in over a day, so half-finished reports must not be filed as final, and the office still needed the familiar PDF.
The solution
What we built
On-screen report form
A sectioned form for report details, shift and weather, deficiencies, visitors, workforce and equipment, payment items and photos.
Draft and submit
Save Draft keeps work in progress, Submit files it as final, and empty rows are never saved.
Safe editing
Opening a saved report loads it back into the same form, and saving updates rows rather than duplicating them.
Photos
Photos with a location and description are stored in Retool Storage and shown on the dashboard.
Same PDF as before
A Retool Workflow generates the report as a PDF in the paper form’s layout, one click away.
Project-wide views
Every section has its own table across all reports, with contractors, visitors and work activities joined in and exportable.
How it works
How a daily report is filed
- 1
Start the report
The inspector opens a new report and it gets its ID straight away.
- 2
Fill it in
Sections are filled in over the day and saved as a draft.
- 3
Submit
Rows are checked and the report is filed as final.
- 4
Download and review
The PDF goes to the engineer, and the office reviews every section across the project.
The result
What changed
- Inspectors file daily reports on screen instead of in a fillable PDF
- Drafts stop half-finished reports from being filed as final
- Contractors, visitors, quantities and photos are searchable across the project
- The engineer still gets the familiar PDF layout
More work
More case studies
Publishing AI video summaries to WordPress in one click
Read the case study →Group travelA group travel company moves off Airtable onto Supabase and Retool
Read the case study →Gemstone manufacturing (B2C)House Of Sylas: from a backlog of Google Sheets to apps for the team and its partners
Read the case study →Have a project like this?
Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.
Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day