AI Script Editor

Summary

• Purpose: Generate FileMaker scripts from natural language prompts and copy them directly to FileMaker clipboard
• Audience: Developers, scripters
• Prereqs: AI Accounts and Models configured, BaseElements plugin installed, Ottomatic AI Runtime enabled

Overview

The AI Script Editor allows you to generate FileMaker scripts by describing what you want in natural language. ProofChat's AI analyzes your request and generates a complete, well-commented FileMaker script that you can copy directly to your FileMaker clipboard and paste into Script Workspace.

Requirements

BaseElements Plugin

The AI Script Editor requires the BaseElements plugin to copy scripts to FileMaker clipboard. The plugin provides clipboard functionality that allows ProofChat to set script steps directly on FileMaker's clipboard.

Installation: Download and install BaseElements from the BaseElements Plugin GitHub repository.

Ottomatic AI Runtime

The AI Script Editor requires Ottomatic AI Runtime to function. This runtime provides the necessary infrastructure for advanced features including automatic tool result submission, enhanced streaming, and server-side processing capabilities that enable the AI Script Editor to work seamlessly.

Why Ottomatic AI Runtime?

• Automatic tool result submission: Script generation results are automatically processed and submitted
• Advanced streaming: Enhanced real-time processing for complex script generation
• Server-side capabilities: Specialized processing required for FileMaker XML generation
• Multiple AI provider support: Access to Anthropic, OpenAI, and more providers (coming soon)

How It Works

Basic Workflow

1. Type your request: In the ProofChat interface, describe the script you want to create (e.g., "Create a script that finds all customers in California and sets their status to active")
2. AI generates the script: ProofChat analyzes your request and generates a complete FileMaker script with proper formatting, comments, and error handling
3. Review the script: The generated script appears in a tool panel with syntax highlighting and line numbers
4. Copy to FileMaker: Click the "Copy to FM" button to copy the script directly to FileMaker's clipboard
5. Paste in Script Workspace: Open FileMaker Script Workspace, create a new script, and paste (Cmd+V / Ctrl+V) to insert the script steps

Script Generation Features

The AI Script Editor generates scripts that:

• Follow FileMaker scripting best practices
• Include helpful comments explaining what each section does
• Handle errors appropriately
• Use proper variable naming conventions
• Include appropriate script step parameters

Model Configuration (Optional)

For optimal performance and cost efficiency, you can configure specialized models for the script generation process. These are optional—if not configured, ProofChat will use your "Main Chat" model.

Available Model Purposes

FM-Script-Step-Classifier

Purpose: Classifies individual script steps to identify their type and structure.

Recommendation: Use a smaller, faster, and more cost-effective model for this task. Classification is a simpler task that doesn't require the full capabilities of larger models.

Examples: gpt-4o-mini, gpt-3.5-turbo, or similar smaller models

FM-Script-Step-XML-Generator

Purpose: Generates FileMaker XML clipboard format from script step text.

Recommendation: Use a smaller, faster, and more cost-effective model for this task. XML generation follows a structured format that smaller models handle well.

Examples: gpt-4o-mini, gpt-3.5-turbo, or similar smaller models

Configuring Optional Models

1. Open ProofChat and navigate to Settings → AI Accounts
2. Scroll to Model Assignments (bottom of the page)
3. Find FM-Script-Step-Classifier in the list
   • Select your preferred provider (e.g., OpenAI)
   • Choose a smaller, faster model (e.g., gpt-4o-mini)
4. Find FM-Script-Step-XML-Generator in the list
   • Select your preferred provider (e.g., OpenAI)
   • Choose a smaller, faster model (e.g., gpt-4o-mini)
5. Save your changes

Usage Examples

Example 1: Simple Script Generation

Prompt: "Create a script that finds all records where Status equals 'Active' and shows a count"

Result: The AI generates a script with:

• Enter Find Mode step
• Set Field for Status
• Perform Find
• Show Custom Dialog with found count
• Error handling

Example 2: Complex Script with Variables

Prompt: "Create a script that loops through found records, calculates a total, and sets a global variable"

Result: The AI generates a script with:

• Find logic
• Loop structure
• Variable calculations
• Set Variable steps
• Proper loop exit conditions

Best Practices

1. Always review generated scripts: Even though the AI follows best practices, always review scripts before using them in production
2. Test in a development environment: Test generated scripts in a safe environment before deploying
3. Be specific in your requests: More detailed prompts lead to better script generation
4. Use smaller models for classification/generation: Configure the optional model purposes with smaller models to save costs and improve speed
5. Keep BaseElements updated: Ensure you're using a recent version of BaseElements plugin

Troubleshooting

"Copy to FM" Button Doesn't Work

• Check BaseElements installation: Ensure BaseElements plugin is installed and enabled in FileMaker
• Verify script permissions: The setFMClipboard script must be accessible and executable
• Check FileMaker version: Ensure you're using FileMaker 21 or later

Generated Scripts Have Errors

• Review the script: Check for syntax errors or missing parameters
• Try rephrasing your prompt: More specific prompts often yield better results
• Break complex requests into smaller parts: Generate scripts in steps rather than one large script

Model Configuration Issues

• Verify model assignments: Check Settings → AI Accounts → Model Assignments
• Test model connection: Ensure your AI provider account is connected and working
• Check model availability: Verify the model you selected is available in your provider account

Related

• AI Accounts and Models - Configure AI models and providers
• Tools are Scripts - Understanding how tools work in ProofChat
• BaseElements Plugin Documentation - BaseElements plugin reference