Using Filemaker Database with AI and LLM for Private Securing Prompting and Access for Research Development and Operations form your Computer or Network Access from Smartphone from Infinity Turbine

All Products IT10 IT10 System IT50 IT50 System IT250 IT250 System CO2 Turbine Generator Radial Outflow Turbine ROT 06 ROT 15 ROT 24 Axial Casterbeam Rocket Fuel from CO2 ROT12 IT Micro Redstone IT Micro Radial Turbine IT Redstone IT10 Haas Tooling Helical 3D Heat Exchanger Coni Radial Inflow Mag Coupling ITXR Telsa Experimenters Kit 3D Filter Ejector Pump Solid State Chiller SDR Charts Vortex Tube Desalination Structured Data Heat Pump ORC Standing Wave Turbine Illusion Drone CO2 Phase Change Cart CO2 ORC and Heat Pump Build License CO2 ORC and Heat Pump Experimenters Platform Solar Thermal Modular Heater Sulfur Deposition Using Supercritical CO2 Gas Leverage Turbine Sulfur Deposition Using Supercritical CO2 Viktor Schauberger CO2 Gas SuperCapacitor Turbine Condensed Matter Battery RIN Renewable Identification Number CO2 Flow Battery Modular Block Heat Pump Turbine Kit Turbine Machining Organogel Electrolyte CO2 Hydraulic Motor and Actuator Davos Hydro Electric Turbine Flow Battery Licensing ROT 12 Turbine Plans Sand Battery Features Sand Battery Product UK Solar Power Homeowner Paraffin Wax Thermal Energy Storage Modular Block Examples Salt Battery Utility Power Energy Mining Water Conditioning Power Production Cogen Battery Powerplant Brine as a Flow Battery Salt Battery Supercritical CO2 Extractor Supercritical CO2 Extractor Build Graphene Hard Carbon from Wood Wastes Salt Water Redox Flow Battery Tech Report Energy Strategy Technology Guide Robots Technology Guide Ferro Fluids Technology Guide Organic Rankine Cycle Builders Guide Desalination ORC Salgenx Lift Pump Tesla Disc Pump Turbine Cavgenx HVAC Turbine Micro Robots Viktor Schauberger History of Robots Robot Actuator Robot Code Telsa Optimus Telsa Robot Engineers Closed Loop CO2 Heat Pump Turbine Plasma Ion Propulsion Modular Block Sampler Kit Sand and Salt Battery Zeolites Capstone CRMS ROT Turbine Flat Pack NIMS Nvidia Silent Drone CMPG Cluster Mesh Power Generation Data Center Technology Report Data Center Cold Vortex Cooling Data Center Algorithm Chiller on a Chip Laser Print 3D Electrodes Laser Engraving Electrodes 3D Printing Motor Coils cavitation HVAC compressor pump Cavitation Pump HVAC CO2 Working Fluid CO2 Turbine Data Center TEG vs ORC SCO2 Data Center Cycle NVIDIA Chipset Cooling Magnetocaloric Heat Pump Dutch AI Data Center Trompe Cooling COP Cooling sCO2 sCO2 Waste Heat Pump Vortex Tube Cooling Primary ORC Turbines Cluster Mesh Drone System Paper Drone NVIDIA Blackwell NVIDIA Blackwell NVIDIA Blackwell LiftGenX Payload Hydrogen Balloon Lithium Hazards Tech Report ORC Build Plans Extracting Gold from E Waste E Waste Presious Metal Recovery Industrial Gold Recovery Machine Industrial Gold Extraction Process Industrial Gold Recovery Bitcoin vs Industrial Gold Mining Comparison Industrial Gold Extraction Mining Equipment Extracting Gold from E Waste Industrial Gold Recovery Articles Carbon Fiber Tow Additive Manufacturing Software Software IT Mini Kit

Unlocking the Power of AI with FileMaker 24 and Local LLMs for Private, Smart Database Solutions

Harnessing AI on Your Terms with FileMaker 24

FileMaker 24, the latest evolution of Claris’s powerful low-code platform, now includes robust support for integrating artificial intelligence (AI) and large language models (LLMs). With this integration, developers and businesses can enhance their FileMaker databases with powerful natural language processing and automation—all while maintaining full control over data privacy and deployment.

One of the most transformative approaches is running LLMs locally on your MacBook Pro or desktop system, rather than relying on cloud APIs. This allows for maximum data security, full compliance with privacy regulations, and real-time access across your network.

The Case for Local LLMs on Mac

Running AI models locally offers both performance and privacy. Leading LLMs that perform exceptionally well on modern Apple Silicon (M1, M2, M3) MacBook Pros include:

• Mistral 7B or Mixtral 8x7B: Fast, accurate, and efficient

• LLaMA 3 (8B): Meta’s latest open model with excellent general-purpose capabilities

• Phi-2 or Phi-3 (Microsoft): Lightweight and powerful for lower RAM systems

• Gemma (Google): Efficient and optimized for AI research tasks

These models can be deployed using local tools such as:

• Ollama: A terminal-based AI runner optimized for macOS

• LM Studio: A user-friendly GUI to load and run GGUF-based quantized models

• GPT4All: Another GUI tool for experimenting with multiple LLMs

Running these models locally eliminates the need for internet access or reliance on third-party servers, which enhances security and reduces operational costs.

Privacy and Power: A Perfect Match with FileMaker

FileMaker’s trusted database platform provides an ideal front-end and backend environment for AI integration. Whether you are building a customer service chatbot, automating data entry, or creating a context-aware messaging platform, FileMaker 24 can serve as the command center for your AI applications.

Benefits include:

• Secure local or LAN-based LLM integration

• Real-time interaction with FileMaker records through natural language

• No external data transmission required

• Custom workflows, scripts, and field-based prompts

These features allow your AI to interact directly with your FileMaker data while ensuring complete confidentiality.

Remote Access with FileMaker Go

For mobile users, FileMaker Go provides seamless access to your AI-enhanced database from an iPhone or iPad. When paired with a secure VPN or local Wi-Fi connection, FileMaker Go lets you:

• Query or update records using natural language

• Access monitoring dashboards from anywhere

• Receive AI-generated insights on the move

• Communicate securely within your private network

This mobile access ensures that your data and tools remain close at hand, whether you are in the office or in the field.

Infinity Turbine: Your Integration Partner

Infinity Turbine LLC provides specialized consulting to help businesses and developers integrate FileMaker databases with AI and LLMs on a local or network basis. We've been programming and running Filemaker in our business since 1992. Services include:

• FileMaker 24 database architecture and customization

• Deployment of local LLMs on Mac and server-based systems

• Setup of remote access via FileMaker Go

• Integration of secure messaging, monitoring, and reporting systems

• Full-stack local AI solutions without third-party cloud dependencies

Our expertise ensures your system remains private, efficient, and perfectly tailored to your needs.

Contact Infinity Turbine LLC today to explore how FileMaker 24 and private AI can transform your workflows, improve productivity, and secure your data infrastructure for the future.

Leveraging JSON in FileMaker and FileMaker Go for Dynamic, Modern Applications

Explore how JSON in FileMaker and FileMaker Go streamlines data handling, API integration, and mobile interactions for modern database-driven applications.

Powering FileMaker Solutions with JSON

• JSON (JavaScript Object Notation) has become the universal language of structured data exchange. With native • JSON functions built into FileMaker Pro and FileMaker Go, developers now have powerful tools to structure, parse, and transmit complex data more efficiently than ever before.

FileMaker’s support for JSON allows it to function not just as a database, but as a fully integrated platform for modern web, API, and mobile workflows.

What Is JSON and Why Use It in FileMaker?

JSON is a lightweight data-interchange format that is easy to read, write, and parse. In FileMaker, JSON is used to represent complex structures like arrays, objects, and nested records—making it ideal for transmitting data between layouts, scripts, and external systems.

Key benefits of using JSON in FileMaker:

• Seamless integration with APIs (REST, Webhooks, etc.)

• Simplifies data passing between scripts and layouts

• Supports scalable, flexible structure for mobile and desktop apps

• Enables efficient data packaging for transmission and storage

Core JSON Functions in FileMaker

FileMaker includes several native JSON functions that provide powerful data manipulation capabilities:

• JSONSetElement: Build or update JSON structures

• JSONGetElement: Extract data from a JSON object

• JSONDeleteElement: Remove keys or values from a structure

• JSONListKeys: View all keys in a JSON object

• JSONFormatElements: Make JSON readable for humans

These functions allow FileMaker scripts to dynamically generate, manipulate, and retrieve structured data—ideal for advanced workflows and external communication.

Real-World Applications of JSON in FileMaker

1. API Integration

When working with external web services, FileMaker can both send and receive JSON payloads. This allows for real-time interactions with platforms like payment gateways, CRMs, inventory systems, and more.

2. Dynamic UI and Layout Control

By embedding JSON structures in fields or global variables, developers can control UI behaviors, populate dynamic portals, or pass values across scripts without creating numerous fields or variables.

3. Mobile Forms and Offline Sync (FileMaker Go)

FileMaker Go applications can store form data as JSON when offline and synchronize the data later. This approach is efficient for minimizing write operations and handling multiple records at once.

4. Record Auditing and Change Tracking

JSON allows bundling multiple field values into a single structure that can be logged for auditing purposes. Developers can compare old and new values to track changes over time.

5. Custom Logging and Messaging

Developers can use JSON to format internal messages, log script execution results, or send structured notifications between modules in a modular FileMaker system.

FileMaker Go and JSON: A Mobile Powerhouse

FileMaker Go, the mobile counterpart of FileMaker Pro, fully supports JSON operations. This enables advanced features such as:

• Capturing user inputs into structured JSON objects

• Syncing data with a host system in JSON format

• Storing temporary records and converting them into proper table entries

• ntegrating with NFC, barcode scanners, and sensors with JSON responses

With JSON, FileMaker Go can move beyond simple data entry and serve as a mobile command center for data collection, review, and remote interactions.

Building Modern Workflows with FileMaker and JSON

Using JSON as a core element of your FileMaker development strategy enables:

• Scalable data structures that evolve without needing major schema changes

• API-driven solutions for integrations with cloud services or IoT devices

• Dynamic, data-driven interfaces for user-friendly apps

Mobile-first capabilities that are efficient and lightweight

Infinity Turbine Consulting: FileMaker JSON Experts

Infinity Turbine LLC offers consulting services to help you implement advanced FileMaker solutions using JSON. Whether you need to integrate APIs, build mobile offline apps, or streamline your data flow, our team can:

• Design JSON-first data models

• Build FileMaker scripts with efficient JSON handling

• Implement mobile sync strategies for FileMaker Go

• Set up webhooks and RESTful integrations