⟵ hearthere ⟶
  • Training course
  • Creating simple tables and fields
  • Codes base level
  • Selects and links between tables
  • Select field creation and how this field works
  • Code for generating a select
  • Different select a content depending on other fields
  • Strikethrough selects and what it may be caused by
  • Single or multiple select
  • How do I replace the id with a different identifier?
  • How do I take the value of a select?
  • Additional information in the context panel for Select and sections in the drop-down menu
  • Editing a source
  • Table settings basic level
  • Prefilters base level
  • Conditional formatting basic level
  • Action codes base level
  • Using pop-up windows
  • Cycles base level
  • Roles and users on the web
  • Codes advanced level
  • Action codes advanced level
  • Prefilters advanced level
  • Field and table settings advanced level
  • Cycles advanced level
  • Formatting advanced level
  • Select-Tree
  • Executing a scheduled action code
  • Printing and emailing
  • Notifications
  • API interaction
  • Adaptivity and Sections
  • Code for generating a select

    selects_table

    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?

    selectRowListForSelect

    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.