No two agencies inspect construction work exactly the same way. The same is true for engineering consultants managing inspection workflows across different clients, funding requirements, project types, and reporting standards.
Appia has long supported standard Worksheets that help inspectors document item-specific work in the field, but standard Worksheets can only go so far, as Ricky Jeffries, Senior Product Manager for Appia, explained in our recent webinar, Modernizing Inspection Forms:
“Field data is still scattered within too many agencies,” Jeffries said. “You have paper forms, external spreadsheets, disconnected systems, and inspectors find themselves doing duplicate entry, building manual workarounds, and producing project records that just don’t match up.”
That is exactly the gap Custom Worksheets are designed to close.
Evolving beyond standard Worksheets
Standard Worksheets cover common inspection scenarios, but every project brings its own requirements. Agencies may need to capture unique measurements, specialty material details, project-specific documentation, local compliance fields, or item-level calculations that do not fit neatly into a prebuilt form.
When inspection software cannot support those workflows, teams often create workarounds outside the system: spreadsheets, side calculations, handwritten notes, PDFs, or disconnected forms.
As Jeffries put it during the webinar, “When a platform can’t flex to fit your workflows, you end up bending your processes to fit the software.”
That creates downstream issues. Data captured outside the system of record is harder to report on, harder to validate, and harder to leverage for analysis. It can also create friction when local agencies need to report information up to a state system or provide project documentation for review.
Custom Worksheets give Appia users a more flexible way to capture item-specific data directly within daily reports, helping inspection teams document the details that matter without leaving their normal workflow.
Introducing Custom Worksheets in Appia
Custom Worksheets allow admin users to build Worksheet templates from scratch and associate them with any item in a collection. Once configured, inspectors can complete those Worksheets as part of their normal item posting workflow in Appia.
That means agencies can create worksheets around the way they actually inspect work.
With Custom Worksheets, teams can:
- Build a worksheet once and reuse it across multiple items of the same type
- Associate worksheets with specific pay items in a collection
- Capture item-specific data directly in daily reports
- Automatically inherit associated worksheets when new projects are created from a collection
- Flow worksheet data into Item History
- Export worksheet data to CSV or PDF
This functionality creates a more configurable inspection experience without forcing inspectors into a separate system.
Build the fields your inspection process requires
The Custom Worksheet Builder gives teams the ability to mix and match field types based on what needs to be documented.
Available field types include text box, text, checkbox, multi-select, number, dropdown, description, and date picker. Admins can also reorder fields with drag-and-drop functionality and mark fields as required when needed.
This flexibility gives agencies and consultants more control over the structure of their inspection forms. A worksheet can include a mix of qualitative notes, yes/no confirmations, dropdown selections, dates, numeric measurements, and descriptive guidance for inspectors.
For example, a worksheet for asphalt placement could include fields for length, width, thickness, material density, core sample status, and compaction testing status. Instead of capturing those details across multiple tools, the inspector can document them directly within the item posting process.
Calculating fields: the power behind the numbers
One of the most valuable parts of Custom Worksheets is the formula builder.
For Worksheets that require quantity calculations, admins can build formulas using number fields. The builder also supports custom numbers, allowing teams to include static values or defined numbers within a formula.
In the webinar demo, Jeffries showed an example using length, width, thickness, and material density to calculate a quantity. Once the Worksheet was completed, the calculated result populated the quantity placed.
“If the worksheet does contain a formula, the result of that formula would automatically populate the quantity placed for you,” Jeffries explained.
Inspectors can also preview calculated results before applying the worksheet, giving them a chance to confirm the value before saving the item posting.
Keeping worksheet data connected
Custom Worksheets also keep inspection data connected to the broader project record.
Once a worksheet is completed, the data flows into Item History. From there, users can view worksheet entries, see calculated values, track quantities, and export the information to CSV or PDF.
That helps agencies and consultants preserve a cleaner record of what happened in the field. It also makes the data more useful over time.
See Custom Worksheets in action
Custom Worksheets are now available in Appia, giving teams a more flexible way to build inspection forms software around their real-world workflows.
Whether you are a local public agency managing item-level documentation, a consultant supporting multiple clients, or an existing Appia customer looking to reduce manual workarounds, Custom Worksheets can help bring more of your field data into one connected system.
Want to see how it works?
Explore the Custom Fields and Worksheets Storylane demo.
You can also watch the full webinar recording here.
Author
Nate Binder
Digital Marketing Manager
A proud graduate of Florida State University, Nate works with subject matter experts and sales professionals to produce targeted marketing collateral.