Magnolia River Group Modernizes Field Operations With FastField, Quickbase, Samsara, and Vista

The Company Profile: Magnolia River

• Use Case: Field Operations Management, Safety & Compliance, Daily Work Reporting, Payroll & Billing Automation
• Technology: Quickbase, FastField, Samsara, Vista
• Headquarters: Mississippi
• Project: Field Operations & Workflow Optimization

For more than two decades, Magnolia River has supported the organizations responsible for building, maintaining, and modernizing critical utility infrastructure. The company provides engineering, inspection, consulting, and technology-enabled services that help utilities and infrastructure operators manage complex assets, projects, field operations, and regulatory requirements.

Magnolia River works across the natural gas, water, pipeline, and broader utility infrastructure sectors, supporting projects throughout the infrastructure lifecycle. Its capabilities span engineering and design, pipeline and utility inspection, construction management, integrity management, geospatial services, field data collection, and technology solutions designed to improve how infrastructure information is captured, managed, and used.

Because much of this work takes place in the field, Magnolia River operates in an environment where accurate and timely operational data is essential. Field teams need efficient ways to document work, inspections, safety activities, equipment usage, labor, and production information, while administrative and operational teams need that information to be structured and accessible for downstream processes.

As Magnolia River continues to support complex utility operations at scale, the organization is modernizing how information moves between field employees and the operational, safety, payroll, billing, and administrative teams that support them. Creating a more connected flow of field data helps reduce manual administrative work, improve visibility, strengthen data quality, and provide a more reliable foundation for reporting and business operations.

Quandary Consulting Group is helping establish that foundation through a connected field operations environment centered on Quickbase, FastField, Samsara, and Vista™ construction ERP software (Trimble) beginning with workflows supporting Magnolia Utility Services and the engagement is designed to improve operational workflows, streamline data capture, standardize information, increase visibility, and establish integrations between Quickbase and the systems supporting field operations.

The Challenges

Connecting a Large Field Organization to the Back Office

Organizations, like Magnolia River, operate in an environment where work happens across crews, vehicles, equipment, job sites, utility corridors, and customer locations rather than behind a desk and this makes operational data both extremely valuable and unusually difficult to manage.

During a single workday, a crew may complete pre-trip inspections, travel to multiple locations, use several pieces of equipment, perform production work, record employee hours, identify safety concerns, and generate information that ultimately affects payroll and customer billing; each activity creates data.

The challenge is making sure that data does not become trapped inside paper forms, spreadsheets, emails, disconnected systems, or manual administrative processes and for Magnolia River, the initial transformation focuses on connecting those frontline activities to a structured digital operating environment.

The objective documented in the engagement is to create scalable solutions that improve visibility, standardize data collection, streamline field data capture, establish reporting and approval workflows, and create foundational integrations with external systems.

For Magnolia River, the broader opportunity is significant; instead of managing field data as a collection of individual documents and transactions, the organization can begin treating it as a connected operational asset.

Field Data Becomes Structured Operational Data

The transformation begins where the work happens: in the field. Quandary is implementing FastField and Quickbase to digitize several of Magnolia's frontline processes, beginning with:

• Pre-trip inspections
• Close-call reporting
• Good-catch reporting

The engagement specifically calls for these FastField forms to be created and integrated with Quickbase so information captured by field teams flows into structured operational records and this distinction is important (vs. just simply digitizing a paper form reduces paper). Connecting the form to the operational environment changes what happens after the form is submitted.

A FastField submission can become a Quickbase record associated with the appropriate crew, date, job, event type, equipment, supporting notes, and attachments.

Instead of information remaining isolated inside an individual form, Quickbase becomes the centralized environment where the data can trigger additional workflows, reporting, approvals, and downstream business processes and for a company operating hundreds of vehicles and pieces of equipment across a distributed field organization, that creates a much stronger foundation for operational visibility.

Safety Reporting Becomes an Active, Connected Workflow

For Magnolia River, safety reporting is more than documenting an incident or completing a required form. The value comes from turning field-level safety activity into structured, actionable information that teams can use to identify trends, address exceptions, strengthen compliance, and reduce operational risk.

Close calls and good catches, for example, can provide valuable insight into conditions across crews and job site; but, that information only becomes useful when it is consistently captured, categorized, reviewed, and connected to the broader operational environment.

Quandary is creating a dedicated Safety Events structure within Quickbase that centralizes safety information and supports standardized monthly reporting. Using FastField, employees can document safety events directly from the field, while Quickbase transforms those submissions into structured records that managers and safety leaders can review, track, and analyze.

The safety data model connects each event to the operational context surrounding it: Event Type → Crew → Region → Date → Location → Supporting Documentation → Follow-Up

Instead of manually compiling information from individual forms, Magnolia River gains a centralized view of safety activity across the organization. Leadership can identify patterns across crews, regions, locations, and event types while reducing the administrative effort required to prepare recurring safety reports.

Turning Pre-Trip Inspections Into Compliance Visibility

Pre-trip inspections create another important layer of operational and compliance visibility. Rather than simply collecting and storing completed inspection forms, Magnolia River can use the connected FastField and Quickbase workflow to monitor whether required inspections are actually being completed.

The operating model becomes:

Crew → Vehicle/Equipment → Pre-Trip Inspection → Date → Submission Status → Compliance Visibility

This distinction is important. A digital form confirms what was submitted; a connected workflow can also help identify what should have been submitted but was not.

Managers gain earlier visibility into missing inspections, incomplete records, and potential compliance exceptions, allowing teams to address gaps while they are still actionable rather than discovering them during downstream reporting or review.

The result is a more proactive approach to utility safety management and field compliance, where safety data becomes part of the operational workflow instead of remaining isolated in individual forms and reports.

Daily Work Reports Become the Operational Backbone of Field Operations

For Magnolia River, the Daily Work Report is more than a record of what happened on a jobsite. It creates a structured connection between field activity and the administrative, operational, payroll, and billing processes that depend on accurate field data.

Each Daily Work Report captures the core information needed to understand work performed in the field, including: Crew → Employee Hours → Equipment → Production → Work Performed

Quandary is structuring this information within Quickbase and developing the associated approval, notification, and processing workflows. The greater value, however, comes from what happens after the information is captured.

Rather than treating the Daily Work Report as a static record of completed work, Magnolia River can use it as the starting point for multiple downstream business processes.

Once a field employee submits a report, Quickbase routes the record to the appropriate manager and moves it into a pending approval status. The manager can review the underlying labor, equipment, production, and job information before approving the record for office processing. From there, the validated data becomes available to support downstream functions such as payroll and billing.

This creates a defined operational workflow: Field Work → Daily Work Report → Manager Approval → Office Processing → Payroll + Billing

More importantly, the same underlying data can move through each stage without employees repeatedly recreating, rekeying, or reconciling information between disconnected processes.

For Magnolia River, this turns the Daily Work Report into a central operational data layer for field service management. Information captured closest to the work can flow directly into the business processes that depend on it, helping improve data accuracy, accelerate approvals, reduce administrative effort, and create greater visibility from field activity through financial processing.

Field Hours Become Payroll-Ready Data

For Magnolia River, labor data begins in the field, but its value extends well beyond the Daily Work Report. Employee hours ultimately need to support payroll, operational reporting, job costing, and workforce visibility, which means the accuracy of downstream processes depends heavily on the quality of the information captured at the source.

In a manual environment, preparing field hours for payroll can require administrative teams to collect individual reports, identify employees and crews, reconcile hours, verify approvals, aggregate totals, and then reformat that information for payroll processing. Each additional handoff introduces administrative work and creates another opportunity for delays or data discrepancies.

Quandary is helping Magnolia River establish a more structured workflow in Quickbase. Once Daily Work Reports are approved, Quickbase can aggregate operational data using standardized reporting logic, including hours by employee, crew, work date, and other relevant dimensions.

The same information originally captured to document field activity can therefore become part of the payroll process without requiring teams to recreate the underlying labor data.

The data flow becomes: Employee → Crew → Work Date → Hours → Manager Approval → Payroll Reporting

This creates greater traceability between reported labor and the work performed in the field while reducing the administrative effort required to prepare payroll information.

More importantly, it establishes a principle that can extend across Magnolia River's broader field operations: capture operational data once, validate it at the appropriate point, and reuse it wherever the business needs it.

Connecting Field Production Directly to Billing

For field-intensive utility operations, the information required to invoice completed work often originates with the crews performing that work. Production records may contain variables such as work type, quantities, measurements, tree size, or other job-specific details that ultimately determine how the work should be classified and billed.

When those operational details require manual interpretation before they can become billing information, an additional administrative layer exists between completed field work and revenue.

Quandary is helping Magnolia River introduce rules-based billing automation into that process. Defined business rules can evaluate production information captured in the field and assign the appropriate billing codes based on customer requirements and operational variables.

The workflow becomes: Completed Work → Production Data → Business Rules → Billing Code → Billing-Ready Data

Instead of requiring administrative teams to repeatedly translate field activity into billing classifications, Magnolia River can begin applying standardized logic directly to the underlying production data.

Thus creates a stronger connection between what happened in the field and what the organization is prepared to invoice and over time, this type of automation can reduce manual billing preparation, improve consistency, strengthen the audit trail between production and invoicing, and shorten the time between completed work and revenue recognition.

Samsara Connects Equipment, Crews, Jobs, and Location Data

Field operations do not happen independently from the physical assets used to perform the work: vehicles, equipment, crews, jobs, and production activity are interconnected, and understanding those relationships creates a more complete picture of field operations.

With this being the case, Quandary included a foundational integration with Samsara, connecting telematics and equipment information with Magnolia River's operational workflows.

Rather than attempting to synchronize every element of the Samsara platform immediately, the initial architecture focuses on establishing connectivity and making high-value equipment data available where it can improve field reporting and operational visibility.

Several use cases become particularly valuable:

• Equipment identification: Equipment maintained in Samsara can become available within operational workflows, allowing employees to accurately identify the vehicles and assets associated with a job or Daily Work Report.
• GPS and location context: Asset-location information can provide additional context around where equipment is operating and how it relates to reported field activity.
• Job-location validation: Equipment associated with a Daily Work Report can potentially be compared with location data to help determine whether the selected asset was present at or near the location where the work was reported.
• Equipment usage visibility: Connecting assets with crews, jobs, production records, and Daily Work Reports creates a more complete operational history of how equipment is being used across the organization.

Together, these connections establish a richer operational data model: Employee → Crew → Job → Equipment → GPS Location → Production

Instead of maintaining telematics data and field reporting as separate sources of information, Magnolia River can begin connecting them within the same operational ecosystem. That creates greater visibility into not only what work was completed, but who performed it, which equipment supported it, and where that activity occurred.

Quickbase and Vista Connect Field Operations With the ERP

The next layer of the architecture connects Magnolia River's field operations with Vista, creating a structured path between operational activity and the organization's enterprise resource planning environment.

Rather than attempting a comprehensive ERP integration at once, Quandary is establishing the initial Quickbase-to-Vista integration framework through a phased approach focused on integration discovery, connectivity, data-flow validation, and an initial production use case.

This sequencing matters because an enterprise integration is most valuable when the information entering the ERP has already been captured consistently, reviewed appropriately, validated against business rules, and prepared for its intended downstream use.

The architecture creates that progression: Field Activity → FastField → Quickbase → Manager Approval → Business Rules → Billing-Ready Data → Vista

Within this model, FastField supports field data capture, Quickbase serves as the operational workflow and data layer, and Vista remains the downstream enterprise system.

Quickbase therefore does more than transfer information between platforms. It provides the environment where field data can be standardized, enriched, reviewed, approved, and transformed before it reaches the ERP.

This creates a fundamentally stronger integration model than simply moving fragmented information from one system into another; and, for Magnolia River, the larger opportunity is a connected field-to-ERP architecture in which information captured at the point of work can move through operational workflows and ultimately support payroll, billing, equipment management, reporting, and enterprise financial processes: Field Capture → Operational Data → Validation → Approval → Automation → ERP

The result is an operational model designed around the flow of data rather than individual applications, giving Magnolia River a more scalable foundation for connecting field operations with the back office as the organization continues to grow.