Tag: workflows

If you’re still thinking of FileMaker as a standalone database for internal apps, you’re missing out on what makes it a modern business tool. A big part of that evolution? JSON.

Even if you’re not technical, understanding JSON will help you see why upgrading to FileMaker 2025 is critical for keeping your systems integrated, automated, and future-proof.

What is JSON?

JSON (JavaScript Object Notation) is a lightweight format for organizing and transmitting data. It’s the lingua franca of modern software, used by virtually every API, web app, and cloud service.

Think of JSON as a super-flexible digital form that can carry data like:

• Customer records

• Order details

• Inventory updates

• API responses

It’s structured, yet highly adaptable—perfect for dynamic systems that need to exchange data cleanly and consistently.

Why JSON Matters in FileMaker

Older FileMaker versions struggled to communicate with other apps because they couldn’t easily read or write data in JSON format. But in current versions, including FileMaker 2024 and 2025, JSON is fully embraced with powerful new capabilities and integration with other applications. FileMaker 2025 brings new JSON functions and significant performance enhancements to enable AI and manage significant data integrations.

This means you can now:

• Integrate with APIs easily: Talk to web services like Slack, QuickBooks, Claris Studio, Shopify, or Salesforce.

• Build better dashboards: Use structured JSON data to power analytics.

• Simplify workflows: Claris Connect and Event-Driven Connect rely on JSON for payloads.

• Store complex data structures: Store flexible, nested data directly in FileMaker without needing dozens of related tables.

• Consolidate FileMaker scripting: JSON allows FileMaker elements to communicate far more effectively with other components greatly streamlining code and enhancing performance

Real-World Business Benefits

1. APIs & Automation

Want FileMaker to update your CRM, notify a Slack channel, or send customer data to QuickBooks? JSON is the bridge that makes it possible.

2. Cross-System Consistency

Instead of copy-pasting or manually re-entering data between apps, JSON enables automatic, structured data syncs.

3. Fewer Workarounds

In legacy systems, connecting to other apps required complex plug-ins or brittle workarounds. Now, native JSON support in FileMaker means cleaner, faster, and more reliable integrations.

4. Future-Proofing

Most modern SaaS apps speak JSON. If your FileMaker system can too, you’re set up for the next wave of digital transformation.

If your FileMaker system isn’t JSON-ready, you’re:

• Stuck with manual processes

• Limited in your ability to integrate with cloud apps

• Slower to adapt to modern workflows

Upgrading to FileMaker 2025, with its newJSON capabilities, isn’t just about new features—it’s about ensuring your data can move, connect, and create value in an increasingly digital world.

Need help modernizing your FileMaker system? Contact us for a JSON-readiness assessment and let’s unlock your data’s full potential.

 

 

 

 

Searching for data in a database often requires knowing the exact fields, operators, and syntax—something that can slow down even experienced users. With FileMaker 2025, that barrier is gone thanks to the new Find by Natural Language feature, which lets you search your data using plain English.

This update bridges the gap between human-friendly input and database-driven insights, making it easier for teams to quickly get the answers they need without technical expertise.

How Natural Language Search Works

The Find by Natural Language feature uses built-in AI capabilities to interpret your request, translate it into a structured query, and return the relevant records—all without you touching a search operator or complex find request.

Example searches you could run:

• “Show all orders over $5,000 placed in the last 90 days”
  
  

• “List employees who started in the marketing department this year”
  
  

• “Find customers in New York with overdue invoices”
  
  

FileMaker processes the plain text and runs the correct SQL query or FileMaker Find operation in the background.

Why It’s a Game-Changer for Users and Developers

For users, it means no more guessing at field names or filtering options—just type what you want in everyday language. For developers, it means fewer custom search layouts, simplified training, and the ability to make complex datasets accessible to everyone in the organization.

Real-World Applications

• Sales teams can quickly pull customer lists without relying on IT support
  
  

• Customer service teams can filter service tickets by status or priority in seconds
  
  

• Operations teams can review inventory or shipping records with a single request
  
  

By lowering the learning curve, Natural Language Search encourages more engagement with your data, which leads to better, faster decision-making.

The Find by Natural Language feature in FileMaker 2025 transforms how teams interact with data. Instead of navigating complex search tools, users can simply type their request in plain English and let FileMaker handle the rest.

Want to see how Claris FileMaker can make your data more accessible and actionable? Reach out to Kyo Logic here.

 

 

 

FileMaker 2025 introduces native AI and large language model (LLM) capabilities, giving developers the power to build intelligent workflows without relying on complex integrations or external tools. From generating content to interpreting natural language queries, these new features make it possible to deliver smarter, faster, and more intuitive applications—directly within the FileMaker ecosystem.

Prompt-Based Scripting for Dynamic Content

The new Generate Response from Model script step allows you to send prompts directly to supported AI providers (such as OpenAI or Cohere) and bring the results back into FileMaker instantly. This enables dynamic content creation and on-demand text generation inside your custom apps.

Example use cases:

• Summarizing long client emails for faster review
  
  

• Drafting proposals or status updates directly in FileMaker
  
  

• Generating consistent, branded responses for customer service teams
  
  

Natural Language Queries for Data Access

With Perform SQL Query / Find by Natural Language, users can search for records using plain English instead of technical query syntax. FileMaker interprets the request, converts it into an SQL or Find operation, and delivers the matching results in real time.

Example use cases:

• “Show all invoices from the past six months over $5,000”
  
  

• “List customers who purchased product X last year”
  
  

This feature lowers the barrier for non-technical team members while speeding up information retrieval.

Reusable Prompt Templates and Predictive Analytics

Developers can now configure Prompt Templates and ML Regression Models for AI-driven workflows that are consistent and repeatable. Predictive analytics can be embedded directly into business processes, enabling smarter forecasting and decision-making.

Example use cases:

• Predicting future sales based on historical trends
  
  

• Creating reusable AI prompts for marketing copy or internal reports
  
  

Why This Matters

By integrating AI natively, FileMaker 2025 eliminates the friction of managing third-party tools for AI features. Businesses can now:

• Build custom AI-powered workflows tailored to their industry
  
  

• Keep sensitive data inside the trusted FileMaker environment
  
  

• Give teams natural language tools for faster, more accurate work
  
  

• Deliver more responsive and intelligent applications without heavy coding
  
  

The AI and LLM features in FileMaker 2025 aren’t just a glimpse of the future—they’re tools you can use right now to make your apps smarter and your workflows more efficient. From natural language queries to dynamic, AI-generated content, these capabilities open new possibilities for innovation inside your existing solutions.

Want to see how Claris FileMaker’s AI features can transform your workflows? Reach out to Kyo Logic here.

 

 

For developers, FileMaker’s Script Workspace is the engine room of app building. It’s where logic takes shape, processes are automated, and workflows come to life. With FileMaker 2025, Claris has introduced several updates that make Script Workspace faster, cleaner, and more efficient, helping developers stay focused on building instead of battling clutter.

Code Folding: Collapse and Expand Script Parts

The standout improvement is code folding, which lets developers collapse sections of scripts for easier navigation. Long scripts that once required endless scrolling can now be folded into concise blocks. This means you can:

• Hide complex logic until you need it
• Focus on the section you’re actively editing
• Keep large scripts more organized and readable
  
  

For teams working with multi-step processes or deeply nested conditions, this feature alone saves hours of effort.

New Script Step: Go to List of Records

FileMaker 2025 also introduces the Go to List of Records step, simplifying navigation between found sets and layouts. Instead of writing multiple steps to manage record navigation, developers can now leverage this single, streamlined command based on the underlying record IDs.

This makes it easier to build user flows that jump between record views and improves efficiency for solutions that rely heavily on search results.

Faster Script Navigation

On top of new functionality, Script Workspace now includes smarter navigation tools:

• Improved find and search within scripts
• Better handling of script parts for organization
• More intuitive movement through nested logic
  
  

These refinements may seem small individually, but together they create a more polished, developer-friendly experience.

Why Developers Will Love These Updates

Script Workspace is where developers spend much of their time, and every improvement compounds over the course of long projects. By collapsing complex logic, navigating faster, and leveraging new script steps, developers can build and maintain FileMaker solutions more efficiently than ever before.

FileMaker 2025’s Script Workspace improvements give developers the tools to work smarter, not harder. From collapsing script logic to navigating found sets with a single step, these enhancements streamline the development process and reduce complexity.

Want to take advantage of FileMaker 2025’s new developer tools? Reach out to Kyo Logic here.

 

Coordinating deliveries—especially at scale—requires more than sticky notes and shared spreadsheets. Without a structured schedule, even small delays can create major bottlenecks, disrupt customer expectations, and strain internal teams. For businesses managing high delivery volumes, clarity and coordination are key.

Claris FileMaker offers a customizable solution to generate detailed delivery calendars that keep operations running on schedule. Whether you’re coordinating daily truck routes, convention drop-offs, or equipment pickups, FileMaker automates calendar generation, ensuring your entire team stays aligned and customers remain informed.

Why Delivery Scheduling Needs Structure

Relying on manual scheduling tools often leads to:

• Missed or Overlapping Appointments – Without real-time visibility, it’s easy to double-book time slots or miss key delivery windows.
  
  

• Poor Communication – Internal teams and customers may not be alerted when deliveries are scheduled, changed, or delayed.
  
  

• Disorganized Dispatching – Drivers and logistics teams operate without a clear picture of the day’s plan.
  
  

• Frustrated Clients – Delays or unclear delivery times erode trust and satisfaction.
  
  

The larger the operation, the more crucial it is to keep schedules tightly managed—and clearly communicated.

How FileMaker Creates Smart Delivery Calendars

Claris FileMaker makes it easy to build a delivery calendar that reflects your business’s unique needs. Key features include:

• Automated Calendar Generation
  Automatically populate delivery schedules based on confirmed orders, routes, availability, or lead times.
  
  

• Drag-and-Drop Rescheduling
  Easily adjust deliveries on the fly with a visual interface, updating related records in real time.
  
  

• Color-Coded Views and Filters
  Segment deliveries by location, team, status, or client priority for quick insights and better planning.
  
  

• Team Notifications and Assignments
  Alert staff when deliveries are scheduled or updated—automatically assigning tasks to the right drivers or teams.
  
  

• Customer Visibility Options
  Generate customer-facing delivery calendars or confirmations, helping clients stay in the loop and reducing inbound support inquiries.
  
  

A Calendar That Works Across Your Workflow

Whether you’re coordinating deliveries across multiple warehouses, managing 3PL schedules, or tracking on-site service drop-offs, FileMaker lets you design a delivery calendar that supports your flow—not the other way around. Integrate with external systems like Google Calendar, Outlook, or dispatching platforms for maximum flexibility.

A well-organized delivery calendar is essential for minimizing delays and keeping customers informed. Claris FileMaker helps you generate and manage delivery schedules with structure, automation, and clarity—ensuring your team stays on track and deliveries go out as planned. Interested to learn more about how Claris FileMaker can solve for delivery scheduling? 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.