In this edition of Can Your FileMaker Do This?, we’re diving into how semantic search can transform the way construction companies, field service providers, and manufacturing firms create quotes and job estimates.

If your team is constantly sifting through old estimates, quote templates, job specs, or proposal language, trying to reuse what worked last time—but without an easy way to find it—you’re not alone. Most organizations rely on a mix of shared drives, tribal knowledge, and Ctrl+F.

There’s a better way. And you can build it in Claris FileMaker.

What is Semantic Search?

Semantic search lets you search by meaning, not only exact words. Instead of typing a perfect phrase or remembering which folder something lives in, your team can use natural language queries—and still get accurate results.

Think of it as the difference between:

• Keyword search: “custom ductwork”
   
• Semantic search: “quote section we used for that HVAC job with oversized ductwork in the warehouse”
   

Even if the exact phrase wasn’t used, semantic search will find the closest match based on intent and context.

Use Case: Building Better Quotes Faster

Let’s say your estimator is prepping a quote for a new commercial HVAC install. They want to reuse part of a proposal from a job two years ago with similar scope and specs.

With semantic search built into FileMaker, they could type:

“HVAC quote for a large warehouse project with custom ductwork and multiple zones”

FileMaker, enhanced with semantic search, would return:

• The specific quote paragraph about zoning and ductwork
   
• A line item pricing block from a previous estimate
   
• Related installation notes or drawings stored in container fields
   
• Even client-specific terms used in similar contracts
   

No more hunting through files. No more emailing around. Just faster, smarter access to the right content.

How It Works (Behind the Scenes)

Semantic search is powered by a vector-based similarity model. Here’s how it integrates with FileMaker:

1. Index your past quotes and templates
    
   • Store vectors in FileMaker (using container fields)
      
   • Use a semantic embedding model to convert content into vectors
      
2. User enters a query
    
   • Their question is embedded the same way and compared to stored vectors
      
3. FileMaker returns relevant matches
    
   • Sorted by similarity—ready to reuse in a new quote
      

This can all be powered via integration with services like OpenAI, or hosted locally using a setup like our Local LLM for FileMaker tutorial.

Why This Beats Traditional Search

Real Benefits for Construction & Field Teams

• Speed up quoting and estimating
• Reduce errors by reusing proven language
• Make junior estimators more productive
• Standardize tone and terminology across your documents
• Eliminate redundant work

Whether you build HVAC systems, manage commercial renovations, or run a field service company, this tool helps your team move faster and smarter—with FileMaker as your foundation.

Can Your FileMaker Do This?

If your team is still navigating shared drives, copy-pasting from old files, or relying on institutional memory to build client proposals, it might be time to level up.

With the right integration, FileMaker can support AI-powered semantic search to help you find content faster and deliver more tailored, winning proposals.

Want to see this in action? We’d love to show you how this works in a real-world FileMaker app. Let’s talk.

Large conventions and industry events often involve complex logistics—including the rental and management of thousands of pieces of equipment. From booth displays and AV gear to tables, lighting, and staging, every item must be reserved, delivered, tracked, and returned with precision. Managing high-volume equipment rentals requires a solution that handles the details in real time without dropping the ball.

That’s where Claris FileMaker comes in. FileMaker’s flexible, low-code platform empowers businesses to create customized rental management solutions that simplify scheduling, automate check-in/check-out processes, and ensure accurate invoicing—all within a single interface. With FileMaker, teams can efficiently manage rentals from reservation to return, even across large and fast-paced environments like conventions and trade shows.

Challenges of High-Volume Rental Management

When handling equipment at scale, traditional spreadsheets or generic rental systems often fall short. Companies face a range of challenges, including:

• Overlapping Reservations – Without real-time scheduling, equipment can be double-booked or forgotten.
   
• Lost or Damaged Gear – Tracking asset status and condition is difficult without a consistent logging system.
   
• Manual Invoicing Errors – Billing based on usage can be time-consuming and error-prone.
   
• Scattered Communication – Without centralized data, sales, logistics, and accounting teams can lose sight of project details.
   

These issues become amplified when managing hundreds—or thousands—of concurrent rentals at large-scale conventions.

How FileMaker Streamlines Equipment Rentals

Claris FileMaker provides a centralized platform to manage every part of the rental process, customized to fit your workflows. With FileMaker, you can:

• Automate Reservations and Scheduling
  Use calendar views and dashboards to manage real-time availability. Prevent double bookings with intelligent scheduling rules.
   
• Track Inventory in Real Time
  Monitor where each item is, its status, and its condition. Log check-outs and returns using mobile devices or barcode scanners.
   
• Generate Invoices Automatically
  FileMaker can calculate rental duration, late fees, and damage charges, generating accurate invoices and syncing with your accounting system.
   
• Integrate with 3PL and Logistics Partners
  For conventions with offsite storage or outsourced logistics, FileMaker integrates with third-party logistics (3PL) systems to track deliveries, pickups, and shipping manifests.
   
• Support On-Site Staff with iPads
  Field teams can use FileMaker on iPads to manage inventory on the convention floor, capture signatures, and even attach photos of setup or damage.
   

Custom Solutions for Convention Workflows

What makes FileMaker especially powerful for this use case is its adaptability. Need to create client-specific rate tiers, automate follow-up emails, or tag assets by convention type? You can build it. Want to generate reports on equipment utilization or rental trends? Done. FileMaker molds to your operational needs—not the other way around.

High-volume equipment rental operations demand organization, flexibility, and speed—especially at large events like conventions. With Claris FileMaker, you can simplify rental scheduling, inventory tracking, and billing while integrating with logistics partners and on-site teams. Interested to learn more about how Claris FileMaker can solve for high-volume rental management? Reach out to Kyo Logic here.

OVERVIEW

AFD has been the leading provider of display showcases for over 100 years. They operate on a very large scale and can supply tens of thousands of cases upon demand.

AFD are a family-run company that provides a complete line of high-quality showcases, which can be used to display all kinds of products, including jewelry, antiques, collectibles, and more. Cases are rented for trade shows and exhibitions across the United States.

Exhibitors consider AFD to be the top choice for satisfying all exhibition needs; from thousands of display cases at major jewelry industry trade shows to a single showcase at a private auction, they provide exhibitors and show managers with personalized, professional service and high-end products. They are the official showcase provider for the country’s most renowned trade shows.

PROBLEM

AFD faced three situations calling for a change. First, their core order tracking system needed significant upgrades and did not have the required capabilities. Second, the company wanted to add a web portal to support clients, present their wide range of showcases, and allow online ordering. Third, the company wanted a new, modernized system to automate processes, track inventory and assist in these transitions.

TASK

In looking for a replacement system, AFD reached out to many vendors to offer alternative approaches for modernizing their system. A key requirement was having up-to-the minute inventory control over multiple warehouses and active venues at any given time. In addition, since the company offers rentals not final sales, the company required a sophisticated inventory forecasting system to know the availability of every case for many months in advance.

The primary task was for Kyo Logic to develop a design for this tracking system in conjunction with AFD leadership. The business requirements were very detailed and precise reflecting the century of experience that AFD has in this business. In addition, Kyo Logic planned the design interface for a customer portal that would allow clients to handle orders online. Given the detailed logistics associated with this nationally scoped rental system, the integration requirements were extreme.

Finally, AFD wanted a control system to support hundreds of clients while onsite at a show. Technicians are texted a link to the service ticket (this step supports multiple languages, so these texts are sent in the technician’s primary language). The technicians can then update the status of the ticket and even add notes in their web browser.

The most recent addition is the ability for AFD customers to design their both layout through the web portal. Booth designs are sent to the AFD support team with detailed instructions on exactly where each case should go in the booth. This negates the need for hand-written layout designs and removes the guesswork from the process, saving hundreds of hours.

PROCESS

Kyo Logic worked closely with AFD to plan the new system and then built the core order processing system. This work included a multi-member development team working in Claris FileMaker in addition to integrating with other vendors such as payment processing banks, and other accounting systems. The initial system was developed in conjunction with the customer web portal. By business necessity, the system went live quite early in the process and led to a lot of learning on demand as process requirements emerged. Kyo Logic worked very closely with AFD during this period and continuously managed to improve timeliness of reporting and access to real-time statistics about case availability.

RESULTS

The new system now handles all elements of the case rental business. The web portal handles a third of all orders and the system works in a reliable and timely manner in a very high volume environment. The cloud-based system is available 24/7 and operates anywhere across the nation. A challenge has been the quality of wireless service at live conferences and shows. Kyo Logic continues to work with AFD to identify solutions to this essential wireless problem at shows. 

Currently, the company is having record rentals and the integrated operating environment has allowed the company to operate with a lean staff while maximizing utilization of its case inventory. Not only can the company forecast demand by case type for future shows, but it can also forecast inter-warehouse transfers. In addition, warehouse schedules are displayed on large monitors allowing staff to manage loading priorities. All this happens in a mostly paperless environment.

In fast-moving environments like conventions, field service, or equipment rentals, staying on top of inventory is crucial. Missing or overbooked items can lead to project delays, lost revenue, and unhappy clients. To operate efficiently, businesses need a way to track every delivery and return as it happens—with total accuracy and visibility.

Claris FileMaker offers a powerful way to track inventory in real time. With a custom FileMaker app, your team can monitor stock levels across multiple locations, log item deliveries and returns on the go, and reduce manual errors with barcode scanning or automated workflows. The result is a streamlined process that keeps everyone aligned—whether they’re in the office, on the warehouse floor, or at a client site.

Why Real-Time Inventory Tracking Matters

Outdated or manual tracking methods often lead to:

• Inaccurate Stock Counts – Items go missing or are double-booked.
   
• Delayed Deliveries – Teams lose time locating available inventory.
   
• Lost Revenue – Unavailable or forgotten items cause missed opportunities.
   
• Disjointed Workflows – Teams rely on phone calls or emails to confirm stock status.
   

These issues are magnified when your operations involve multiple events, frequent shipments, or 3PL coordination.

How FileMaker Simplifies Real-Time Inventory Management

With Claris FileMaker, your inventory system can be built to match your exact workflows. Here’s how it helps:

• Live Inventory Dashboards
  FileMaker apps show current item counts by category, location, and status. Warehouse teams and project managers can instantly see what’s available.
   
• Mobile Check-In/Check-Out
  Staff can scan items in and out using iPads or iPhones, automatically updating inventory in the central database.
   
• Track Deliveries and Returns
  Document the delivery, return, and condition of each item. Attach photos or notes to create an auditable chain of custody.
   
• Automate Notifications
  Trigger alerts when inventory is low or when returns are overdue, helping you stay proactive.
   
• 3PL Integration
  Coordinate inventory movement with third-party logistics providers by syncing FileMaker with external tracking systems or importing manifest data.
   

Designed for Your Operations

Unlike rigid out-of-the-box systems, FileMaker lets you customize every field, status, or report. Need to track serial numbers, condition reports, or upcoming reservations? Want to generate usage reports by event or client? You can build it all into your FileMaker solution—no coding team required.

Real-time inventory tracking is the foundation of smooth operations, especially when deliveries and returns happen on tight schedules. With Claris FileMaker, you gain full visibility into your stock, streamline coordination with teams and vendors, and prevent costly errors. Interested to learn more about how Claris FileMaker can solve for real-time inventory tracking? Reach out to Kyo Logic here.

Field engineers need instant access to customer histories and past service records to diagnose issues quickly and deliver efficient solutions. Without a centralized system, technicians may struggle with incomplete information, leading to delays in troubleshooting and repeated service visits. Claris FileMaker provides a powerful solution by equipping field engineers with iPads that display detailed customer data, past site visits, and previous problem resolutions—ensuring faster, more informed service.

The Importance of Accessing Customer Histories in the Field

When field engineers arrive on-site, having a full view of a customer’s service history can make the difference between a quick fix and an extended, costly repair. Key details such as previous issues, maintenance history, and past resolutions help technicians:

• Diagnose problems faster by identifying recurring issues.
• Reduce service redundancies by ensuring previous solutions are referenced and applied.
• Improve customer satisfaction by demonstrating an understanding of past service interactions.

Without immediate access to this information, engineers may waste time searching for records or risk making incomplete repairs, leading to follow-up visits and increased operational costs.

Benefits of Using Claris FileMaker for Customer Data Management

By using Claris FileMaker on iPads, field engineers can:

• Instantly Retrieve Customer Records – Access site visit logs, past maintenance history, and troubleshooting notes.
• Improve Service Efficiency – Reduce time spent diagnosing issues by leveraging previous resolutions.
• Enhance Customer Interactions – Show clients a detailed service history, building trust and demonstrating reliability.
• Sync Updates in Real Time – Ensure that any new findings or resolutions are immediately logged for future reference.

For industries such as HVAC, utilities, and industrial equipment maintenance, having a mobile, data-driven solution eliminates the guesswork and streamlines service workflows.

How Claris FileMaker Powers Field Service Operations

Claris FileMaker provides a customizable platform that allows businesses to:

• Store and organize customer histories in a structured, easy-to-access format.
• Enable field engineers to retrieve service records from their iPads in real time.
• Automatically sync new service updates to a centralized database.
• Integrate with scheduling and dispatch systems to optimize technician workflows.

By replacing paper records and disconnected digital systems, Claris FileMaker ensures that every technician has the right information at the right time—reducing service delays and improving overall efficiency.

Providing field engineers with instant access to detailed customer histories and past site visit data enhances troubleshooting efficiency and improves customer satisfaction. Claris FileMaker equips teams with a powerful mobile solution that streamlines service workflows and ensures informed, efficient problem resolution. Interested to learn more about how Claris FileMaker can solve for field service data management? Reach out to Kyo Logic here.

Field technicians and service teams often need to capture images and upload critical documents while on the job. Whether documenting equipment conditions, recording inspections, or attaching service reports, having a seamless way to link files to relevant records is essential. With Claris FileMaker, technicians can capture photos, annotate images, and upload sample documents directly from their iPads, ensuring all files are securely stored and easily accessible within a centralized database.

The Importance of Efficient Photo and Document Management

Manual file handling can slow down workflows and lead to lost or misfiled documents. Without an organized system, retrieving specific images or reports can become time-consuming, delaying service resolutions and impacting operational efficiency. A digital solution that integrates image and document management streamlines processes, improves documentation accuracy, and ensures that all records are linked to the appropriate job, customer, or service request.

Benefits of Using Claris FileMaker for Image and Document Capture

By leveraging Claris FileMaker, businesses can enhance their documentation process with the following capabilities:

• Instant Photo Capture & Annotation – Take photos directly within the FileMaker app, add annotations, and link them to specific service records.
• Seamless Document Uploads – Upload and store sample documents, such as invoices, compliance forms, and service reports, for easy retrieval.
• Centralized Record Management – Ensure all files are stored securely within a single database, accessible to authorized personnel at any time.
• Improved Compliance & Reporting – Maintain a clear audit trail of captured images and documents, ensuring thorough documentation for regulatory or customer requirements.

For industries such as field service, construction, and equipment maintenance, having an integrated photo and document capture solution enhances both productivity and accuracy.

How Claris FileMaker Powers Digital Documentation

Claris FileMaker provides a customizable platform that enables businesses to:

• Capture and annotate images on iPads or mobile devices.
• Attach photos and documents directly to relevant service or customer records.
• Automate file organization with structured naming conventions and metadata tagging.
• Sync captured data with central databases for immediate access by office teams.

By eliminating the need for paper-based documentation and disconnected file storage, FileMaker ensures that critical images and documents are always at your fingertips.

Efficiently capturing photographs and uploading sample documents is essential for maintaining accurate service records and streamlining workflows. Claris FileMaker offers a powerful solution that integrates photo capture, document uploads, and centralized record management into one seamless system. Interested to learn more about how Claris FileMaker can solve for digital documentation? Reach out to Kyo Logic here.

Technical engineers often work in environments where internet connectivity is unreliable or unavailable. Whether conducting site inspections, troubleshooting equipment, or collecting field data, they need a solution that allows them to work offline while ensuring seamless data synchronization once they regain connectivity. With Claris FileMaker’s offline capabilities, engineers can capture critical information in the field and automatically sync it with a centralized database when online access is restored.

The Challenges of Working Without Connectivity

Many industries—such as construction, utilities, and remote infrastructure maintenance—require engineers to operate in locations with limited or no internet access. Traditional cloud-based solutions may not function effectively in these conditions, leading to delays in data collection and reporting. Without an efficient offline solution, engineers are forced to rely on manual methods or risk data loss when attempting to transfer information later.

Benefits of Offline Data Collection with FileMaker

Claris FileMaker provides a seamless offline data management system that ensures engineers can work without disruption. Key advantages include:

• Uninterrupted Workflow – Engineers can collect data, complete forms, and store information locally on their device.
• Automated Synchronization – Once an internet connection is restored, data syncs with the central database without manual intervention.
• Data Accuracy and Consistency – Eliminates errors caused by manual data entry or delayed reporting.
• Enhanced Productivity – Engineers spend less time worrying about connectivity and more time focusing on their tasks.

This functionality is particularly valuable for industries that require compliance reporting, asset management, or time-sensitive data collection.

How Claris FileMaker Powers Offline Data Management

With Claris FileMaker, businesses can develop custom solutions that enable technical engineers to:

• Collect and store data securely on mobile devices.
• Capture signatures, photos, and test results without an internet connection.
• Sync records to a centralized system once back online, ensuring real-time updates.
• Integrate seamlessly with enterprise resource planning (ERP) and asset management systems.

FileMaker’s flexibility allows businesses to tailor offline workflows to their specific needs, improving efficiency and ensuring that field data is always accessible when needed.

Conclusion

Enabling technical engineers to work offline while ensuring seamless data synchronization is critical for industries that rely on field operations. Claris FileMaker provides a powerful solution that allows engineers to collect and manage data efficiently, even in areas with limited connectivity. Interested to learn more about how Claris FileMaker can solve for offline data collection and synchronization? Our KyoSync could be the solution for you. Reach out to Kyo Logic here to find out more.

Field technicians need efficient tools to perform on-site testing and collect accurate performance data. Traditional paper-based methods or disconnected digital systems can lead to delays, errors, and inefficiencies in data reporting. By equipping technicians with iPads running custom Claris FileMaker apps, businesses can streamline on-site testing, capture real-time performance data, and ensure accurate reporting and analysis—all within a single, seamless system.

The Need for Real-Time On-Site Testing

On-site testing often involves collecting large amounts of data under varying conditions. Whether measuring equipment performance, conducting inspections, or troubleshooting operational issues, technicians need immediate access to structured, reliable tools. Real-time data entry eliminates the need for manual transcription later, reducing errors and ensuring that decision-makers receive up-to-date, accurate information. By leveraging iPads with custom-built Claris FileMaker apps, businesses can enhance efficiency and improve the quality of their field testing.

Benefits of Using iPads for Field Data Collection

Equipping technicians with iPads running Claris FileMaker apps provides several advantages:

• Instant Data Capture – Enter test results and in-use statistics in real time, eliminating paperwork.
• Automated Reporting – Generate reports instantly, reducing administrative overhead.
• Offline Access – Capture data in remote locations without an internet connection and sync later.
• Standardized Workflows – Ensure consistent testing procedures and accurate data collection.

For industries requiring compliance tracking, safety inspections, or equipment performance analysis, iPads with FileMaker apps provide a reliable and scalable solution.

How Claris FileMaker Enhances On-Site Testing

Claris FileMaker offers a fully customizable platform that enables businesses to design field-friendly applications tailored to their testing needs. These apps allow technicians to:

• Perform structured tests with preconfigured workflows.
• Capture photos, signatures, and real-time sensor data.
• Integrate with back-office databases for seamless reporting.
• Generate instant insights that help drive operational improvements.

With its ability to work across multiple devices and platforms, Claris FileMaker ensures that field technicians, analysts, and decision-makers are always connected to the data they need.

Equipping field technicians with iPads running Claris FileMaker apps transforms on-site testing by improving efficiency, accuracy, and real-time reporting. Businesses can collect and analyze performance data seamlessly, leading to better decision-making and operational improvements. Interested to learn more about how Claris FileMaker can solve for on-site testing and data collection? Reach out to Kyo Logic here.