Can Your FileMaker Do This? Semantic Search in Proposal

 

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

 

 

Traditional Search

Semantic Search

Requires exact matches or tags

Understands intent & context

Limited by filenames or keywords

Searches full content meaning

Slower & more manual

Faster proposal assembly

New staff must know what to search for

Even new hires get accurate results

 

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.




Manage High-Volume Equipment Rentals for Conventions

 

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.




Track Inventory in Real Time, Including Item Deliveries and Returns

 

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.




Export container data on FileMaker Server with the Data File script steps

Free FileMaker demo file

Export container data on FileMaker Server with the Data File script steps

A free demo file that writes PDFs, images, and documents out of container fields from a server-side script, with no plug-ins.

Yes, FileMaker can write container data to disk from a server-side script. The native Data File script steps (Create Data File, Open Data File, Write to Data File, and Close Data File) have shipped with FileMaker since version 18, and Claris lists all four as supported on FileMaker Server and FileMaker Cloud. This free demo file shows the whole pattern in a form you can open, run, and copy.

Here is the moment it exists for. A nightly script on FileMaker Server is supposed to drop every signed delivery PDF into a folder your accounting system picks up in the morning. The script ran fine when someone tested it from their desk. In the morning the folder is empty, and nobody knows until accounting asks where the paperwork went.

Why is exporting container data on the server tricky?

For years the obvious tool, Export Field Contents, could not run in a server-side script. Teams worked around it with plug-ins, or by moving the export back onto someone’s desktop where a person had to remember to run it.

That changed recently. The FileMaker 2026 release notes state that Export Field Contents “is now supported in scripts run by FileMaker Server, FileMaker Data API, and the OData API.” If your host already runs FileMaker Server 2026, you have two native options. If your host runs FileMaker Server 2025 or earlier, or you are on FileMaker Cloud, where Claris still lists Export Field Contents as not supported, the Data File steps are the native route.

Even with both options available, the Data File steps give you finer control. You decide the exact path, you check for an existing file first, and you decide when the file is closed. The container field does not need to be on the layout, and no plug-in has to be installed on the server.

What the demo file does

The demo walks through one export from start to finish. Every step is a native script step, so you can read the script and copy it straight into your own solution.

A script runs on FileMaker Server, on a schedule or through Perform Script on Server

↓

The script builds the full file path and stores it in $filepath

↓

Get File Exists checks that path, and Delete File clears an old copy if one is there

↓

Create Data File makes a new, empty file, then Open Data File returns a file ID

↓

Write to Data File writes the container contents as binary

↓

Close Data File releases the file so other processes can read it

A minimal version of the script looks like this. Field and table names are examples.

Set Variable [ $filepath ; Value: Get ( DocumentsPath ) & Exports::FileName ]
Get File Exists [ "$filepath" ; Target: $exists ]
If [ $exists ]
    Delete File [ "$filepath" ]
End If
Create Data File [ "$filepath" ; Create folders: Off ]
Open Data File [ "$filepath" ; Target: $fileID ]
Write to Data File [ File ID: $fileID ; Data source: Exports::Document ]
Close Data File [ File ID: $fileID ]

Three details matter in production:

  • Create Data File does not open the file. Claris documents that it creates an empty, closed file, so Open Data File is always the next step.
  • Container data is written as binary. When the data source is a container field, Write to Data File ignores the character encoding option and writes the file as-is, so a PDF comes out as a PDF.
  • Always close the file. A file left open stays locked until the script closes it or the session ends, and FileMaker allows only 25 data files open at once.

How the Data File steps compare to Export Field Contents

This table reflects the current Claris compatibility listings for each script step.

Where the script runsData File script stepsExport Field Contents
FileMaker ProYesYes
FileMaker ServerYes, since FileMaker 18Yes, from FileMaker 2026
FileMaker CloudYesNo
FileMaker WebDirectNoPartial (downloads to the browser)

If users need to download a file in WebDirect, Export Field Contents is still the right step. For scheduled and server-side work, the Data File pattern runs everywhere your server does.

The same four steps power other Kyo tools. The Calendar Invite Creator uses them to write .ics invite files, and they pair well with the Multi-File Uploader when files come in through one door and need to go out through another.

What this could look like in your solution

Most teams start with one export and find three more. Signed delivery receipts pushed to a shared folder every night. Inspection photos written out for a customer portal. Invoices saved as PDFs where the accounting system can pick them up. A backup copy of every drawing attached to a job. Each one is the same pattern with a different path and a different container field.

Kyo Logic builds custom Claris FileMaker and manufacturing software for businesses across New England and beyond, and this demo comes from the same work: a problem our clients kept hitting. If you want help pointing the pattern at your own tables, setting up the server schedule, or deciding where exported files should live, reach out.

Frequently asked questions

Can FileMaker Server export container data?

Yes. The Data File script steps (Create Data File, Open Data File, Write to Data File, Close Data File) run on FileMaker Server and FileMaker Cloud and have been available since FileMaker 18. From FileMaker 2026, Export Field Contents also runs in server-side scripts.

Do I need a plug-in to export files from a container on the server?

No. The Data File script steps are native FileMaker script steps. The container field also does not need to be on the current layout.

Why should I close the data file after writing?

Open Data File keeps the file open until Close Data File runs or the session ends. Closing it releases the file for other processes, and FileMaker allows a maximum of 25 data files open at once.

Does this work in FileMaker WebDirect?

No. Claris lists the Data File script steps as not supported in WebDirect. For WebDirect downloads, use Export Field Contents, which sends the file to the browser.

Quick takeaways

  • Check which FileMaker Server version your host runs. On 2025 or earlier, or on FileMaker Cloud, the Data File steps are the native way to export container data on the server.
  • Always pair Open Data File with Close Data File, and check for an existing file before you create a new one.
  • Write exports to a known folder such as Get ( DocumentsPath ) so the next system knows where to look.
  • Download the demo and run the script once before you wire it into a schedule.

Get the Data File Export demo file

Tell us where to send it and we will email your download link right away.

Announcing April’s Kyo Sync Webinar!

Many of our clients rely on Claris/FileMaker for day-to-day operations but often lose connectivity while traveling or working in the field. Although offline usage isn’t a built-in feature, we created KyoSync to fill that gap. Now, you can keep updating your FileMaker solution entirely offline and have your data sync automatically when you’re back online. Join us for our upcoming webinar to see how KyoSync can extend your FileMaker system to handle any connectivity situation with ease.

In this free, 45-minute session, we’ll showcase Kyo Sync—a native FileMaker add-on that lets your team record data even without an internet connection and automatically sync changes once you’re back online.

 

During the webinar, you’ll learn:

  • How Kyo Sync seamlessly integrates with your existing FileMaker solutions

  • Tips to handle real-world scenarios like conflicting edits and offline updates

  • Easy setup steps to get your organization started fast

 

Plus, we’ll walk you through a live demo and share practical use cases from clients who have successfully tackled offline challenges. Don’t miss this chance to discover how Kyo Sync keeps your data safe, consistent, and synced—no matter where your users are.

 

Mark your calendars for April 23 at 12pm ET, and register now by clicking here. We can’t wait to see you there!