What code creates a link to the source table?
Select code. It is available only for fields of type Select and Select-tree.
What function is used to automatically generate the data for the select to work?
At what moment are the selection codes calculated?
The order of code calculation is as follows:
codes
action-codes
select displays
formatting
What is the field of the source table used for matching by default?
By default, the id
of the row in the source table is used for matching.
Is it possible to select hidden fields as a display?
Yes, you can select a hidden field in any way.
Can I use more than one field as a display?
No. But there is a trick:
In the source table, create a hidden field of type string where you concatenate the values of the fields you want to see in the select display using code
=: str`#field_1 ++ "—" ++ ##field_2`
Recalculate the rows if necessary (for example, if you are in a simple table).
Use this hidden composite field for the display.