Perform Find by Natural Language

Intermediate

Use natural language prompts to generate FileMaker find requests, found sets, or debug JSON.

What you'll learn

Why the current layout controls which fields the model can use
The three Get options and what each returns
How context_prompt helps with dates like today and this quarter

Perform Find by Natural Language sends a prompt and the fields on the current layout to a model. The model returns a FileMaker find request, and the script step either performs it or returns JSON for inspection.

Stuck is a valid status

Need a second brain on this one?

If this lesson just collided with your real schema, script stack, or deadline, book consulting and turn the confusion into a concrete plan.

Book consulting

1/3

Put searchable fields on the current layout

The step identifies fields accessible by a find on the current layout. If a field is not available to that layout context, the model should not rely on it.

FileMaker Script

Go to Layout [ "Contacts List" (Contacts) ]
Perform Find by Natural Language [
  Account Name: "main-ai" ;
  Model: Global::ModelName ;
  Prompt: "Find active customers in Oregon created this year" ;
  Get: Found Set
]

Generate Response from Model and agentic mode Perform SQL Query by Natural Language