Calculation Quick AI
Calculation Quick AI is the small native AI overlay inside FileMaker’s Specify Calculation dialog. It is built for one job: draft a FileMaker calculation expression from the dialog you already have open.
It is not CODE mode, QuickCode, or a script apply path. It does not create scripts, edit script XML, click OK, or change schema. It inserts only draft calculation text back into the calculation editor after Genie confirms the dialog has not drifted.
When to use it
Section titled “When to use it”Use Calculation Quick AI when you are already inside a calculation dialog and want help with:
- a field calculation
- an auto-enter calculation
- a validation calculation
- a conditional expression
- a
Letexpression - a date, text, number, JSON, or relationship-aware formula
Use normal Genie chat instead when you need planning, schema work, scripting, data changes, or a broader explanation before writing the calculation.
What Genie captures
Section titled “What Genie captures”Calculation Quick AI uses a tiny FileMaker-aware context instead of the full chat pipeline.
It can include:
- the current calculation text
- the active dialog, table, and result-state snapshot
- capped fields from the current table
- prompt-matched fields and custom functions
- counts and warnings for available metadata
This keeps the request narrow and helps the model write a calculation, not a script or broader implementation plan.
Safety boundaries
Section titled “Safety boundaries”Calculation Quick AI is draft-only.
- It runs through the calculation generator pipeline, not the CODE script workflow.
- It asks the Coding provider for a structured calculation draft.
- It rejects script-looking output, FileMaker script XML, patch instructions, and unsupported response keys.
- It checks referenced fields and functions against known metadata where possible.
- It verifies the dialog snapshot before inserting text so stale dialog state does not receive the draft.
- It leaves final review and confirmation to you in FileMaker.
Genie may return warnings, assumptions, or a review-required draft when the prompt is ambiguous or metadata is incomplete.
How it differs from CODE
Section titled “How it differs from CODE”| Area | Calculation Quick AI | CODE mode |
|---|---|---|
| Target | One calculation expression | FileMaker script generation or script edits |
| Entry point | Specify Calculation dialog overlay | Genie chat composer |
| Context | Tiny calculation/dialog context | Captured scripts, selections, metadata, project rules |
| Output | Draft calculation text | Reviewable script result |
| Apply behavior | Inserts draft text into the calculation editor only | Preview/Copy/Apply actions when safe |
| Safety model | Dialog drift checks and calculation draft validation | CODE preflight, scoped planning, validation, preview/apply guardrails |
Good prompts
Section titled “Good prompts”Return the customer's full name, trimming extra spaces.Use Let to calculate the invoice age in days, but return blank when PaidDate is set.Build a JSON object with customer id, email, and active status.Flag records where the due date is past and status is not Closed.
Name fields exactly when you know them. If you are unsure, describe the intent and review the generated references before accepting the draft.