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. 1

    Start the report

    The inspector opens a new report and it gets its ID straight away.

  2. 2

    Fill it in

    Sections are filled in over the day and saved as a draft.

  3. 3

    Submit

    Rows are checked and the report is filed as final.

  4. 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

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