The form picker

The form picker finds rows and fills referenced fields. It is the picker overlay specialized for forms.

Opening

Binding	Scope
`Space p`	The current table — shows the latest rows immediately
`Space f`	The whole profile — type to search

Query language

Type a query to filter. Commands can be combined:

Command	Meaning
`%target <column>`	Restrict to rows that can fill the active reference field
`%table <name>`	Restrict results to one table
`%column <name> <value>` (alias `%col`)	Match rows where a column equals a value
`%<column> <value>`	Short form of the column filter
`%data <text>`	Free-text search across row data
`%order_by <column> <asc\|desc>`	Override result ordering

Examples:

%data acme
%table customer %data acme
%column city bratislava
%city bratislava
%target customer_id %data acme
%order_by created_at desc

Tab completes the current command, Up/Down move the selection, Enter selects, and Esc closes.

Ordering

The default ordering for the current-table picker comes from [picker] default_order_by in config.toml. %order_by overrides it for the current query.

Filtering the form

When the current-table picker’s query is a plain filter (no target or table scope), selecting it applies that filter to the form, and the form title shows [filtered].

Selecting a reference

On a field that references another table, the picker is used to choose the linked row. %target <column> limits results to rows that can fill that reference; selecting one writes the reference into the field.