Blog

Thoughts on DevOps, Coding, and AI.

Breaking the Container: Native PDF Text Extraction in FileMaker 2025

2025-12-12

A deep dive into the GetTextFromPDF function in FileMaker 2025. Learn the architectural patterns for native text extraction, indexing, and the critical differences between text layers and OCR.

Architecting AI Integrations in FileMaker: 3 Use Cases to Enhance your FileMaker System

2025-12-11

A guide for FileMaker developers on the architectural patterns and practical techniques for integrating external AI services like OpenAI using cURL and JSON.

Architecting Robust cURL Error Handling in FileMaker

2025-12-06

Learn a multi-layered architectural approach to handling errors with the Insert from URL script step. Go beyond Get(LastError) to parse HTTP headers and response bodies for reliable API integrations.

User Story Mapping for FileMaker: Building Solutions That Last

2025-12-05

Discover how user story mapping can transform your FileMaker development by clarifying requirements, designing robust database schemas, and avoiding costly rework. Learn to build user-centric solutions with this Agile technique.

Unlocking AI's Full Potential: A Guide to Writing Effective Prompts

2025-12-05

Master the art of writing effective AI prompts with this comprehensive guide. Learn how to get meaningful and accurate results from tools like ChatGPT, Gemini, and Claude by understanding AI strengths, providing context, and structuring your requests for optimal output.

Introduction to JSON in FileMaker: Modern Data Handling

2025-12-05

Explore the fundamentals of JSON in FileMaker, from core functions to advanced techniques. Learn how to leverage JSON for efficient data interchange, API communication, and building dynamic, scalable FileMaker applications.

Building User-Proof FileMaker Apps: Preventing Errors and Enhancing Security

2025-12-05

Learn essential strategies for user error protection in FileMaker applications to prevent data corruption, enhance security, and ensure robust, user-friendly workflows. Discover best practices for validation, interface design, script trapping, and role-based security.

Best Security Practices for FileMaker 2025: Protecting Your Data

2025-12-05

Discover essential FileMaker security practices for 2025 to protect your sensitive data. Learn about user authentication, encryption, server hardening, backup strategies, and compliance for a secure FileMaker environment.

FileMaker Native API Integration: Automate Data Sync & Ditch Manual Entry

2025-12-05

Eliminate manual data entry and costly plugins by leveraging FileMaker's native API integration capabilities. Learn to build robust, error-handling scripts using `Insert from URL` and JSON functions for seamless data synchronization with external services.

FileMaker Middleware: Architectural Patterns for Maintainable Solutions

2025-12-05

Implement the middleware pattern in FileMaker with controller scripts to separate UI from business logic. Learn how this three-layer architecture enhances reusability, testability, and adaptability for complex FileMaker applications and API integrations.

FileMaker Looping Scripts: Building Resilient and Reliable Data Processing

2025-12-05

Learn how to design FileMaker looping scripts that scale efficiently and prevent 'Not Responding' errors. This guide covers strategies for separating UI from logic, using utility layouts, the Loop-Off-Edge pattern, server-side processing (PSoS), and providing user feedback for robust data operations.

Your Script Parameters Are Brittle (And You Know It)

2025-12-05

Revolutionize your FileMaker development by replacing brittle, order-dependent script parameters with robust JSON objects. Learn how to use JSON for flexible, scalable, and maintainable script communication, avoiding common pitfalls and improving performance.

Global Fields, Global Variables, and Global Tables in FileMaker

2025-12-05

Understand the differences and best use cases for global fields, global variables, and global tables in FileMaker. Learn how to manage temporary and persistent values effectively for robust and scalable applications, including behavior in server-side scripts.

Feature Flags in FileMaker: Safer Deployments and Controlled Rollouts

2025-12-05

Implement feature flags in FileMaker to enable safer deployments, gradual rollouts, and instant rollbacks of new functionality. Learn how to build a robust feature toggle system using tables, scripts, and best practices for controlled release management.

Scaling FileMaker: The Power of Data and UX Separation

2025-12-05

Discover how data and UX separation enhances FileMaker scalability, performance, and maintainability. Learn best practices for implementing this architectural strategy, including container separation and external SQL integration, to optimize your FileMaker solutions.

Custom Functions vs. Inline Calculations in FileMaker: When to Use Each

2025-12-05

Master the decision between FileMaker custom functions and inline calculations for cleaner, more maintainable code. This guide provides frameworks to optimize for reusability, clarity, and performance in your FileMaker development.

Stored vs. Unstored vs. Scripted in FileMaker: The Right Calculation Pattern

2025-12-05

Master FileMaker calculation patterns by understanding the trade-offs between stored, unstored, and scripted values. This guide provides decision frameworks for optimizing performance, data accuracy, and scalability in your FileMaker solutions.

FileMaker API Integration Patterns: Building Maintainable Connections

2025-12-05

Discover architectural patterns for building robust and maintainable FileMaker API integrations. This guide covers centralized configuration, request builders, response objects, error handling, API facades, token management, and queuing to streamline your FileMaker development.

FileMaker API Integration: Connecting Your Custom App to the World

2025-12-05

Unlock the power of FileMaker API integration to create smarter, connected workflows. Learn how to connect your custom FileMaker app with external services like Slack, QuickBooks, and Google Maps to eliminate manual data entry, reduce errors, and automate tasks.

FileMaker 2025: GetRecordIDsFromFoundSet and Go To List of Records

2025-12-05

Explore the new `GetRecordIDsFromFoundSet` function and `Go To List of Records` script step in FileMaker 2025. Learn how these native features simplify tracking, storing, and restoring found sets for enhanced scripting and user context management.

A Beginner’s Guide to Artificial Intelligence and Large Language Models (LLM)

2025-12-05

Explore the fundamentals of Artificial Intelligence and Large Language Models (LLMs) in this comprehensive guide for beginners. Understand core concepts, applications, and the future of AI.