The Select (list from other table) column displays, in a dropdown field, the values coming from a column in a target table.
It supports several configuration options to refine the behavior of the field:

• Custom filters: restrict the proposed values according to defined criteria.
• Custom sorting: define the display order of values.
• Colors: apply background or text colors to the options.
• Free text: allow or prevent typing a value outside the predefined list.
• Cache results: store loaded values to improve performance.

This configuration allows precise control over the data presented to the user when selecting a value.

Configure the column

1. Workspace
   Select the book containing the target table.
   Tip: you must have read permissions on this book to view the proposed rows.

2. Table
   Choose the target table that will provide the values (repository, catalog, etc.).
   Impact: all filters and colors will apply to this table.

3. Column
   Choose the display column (the label shown in the dropdown list: often Name, Title, Reference).
   Best practice: use a short and unique label to avoid confusion.

4. Use custom filters instead of a view
   Check ☑️ to define local criteria for this column (without creating a view). Three configuration buttons then appear:

→ CUSTOM FILTERS to define your conditions in the filter window.

Example : → Status = Active → the list displays only eligible equipment.

→ CUSTOM SORTS

• Select the column from the target table you want to sort by (e.g., Unit price, Date, Priority).

• Choose the sorting order: Ascending (↑) or Descending (↓).

• You can add multiple sorting rules. Sorting is applied from top to bottom.

→ TEST 

Click TEST to open the preview window and verify the results of your filter and sorting configuration before applying.

Value counter : 7 rows found — number of rows matching the filter.

Response time : ⏱ 240ms — measured latency to help assess performance.

Values (dropdown list) → displays the values effectively returned after applying your filter and sorting rules.

7. View
   Instead of using Custom Filters, you may select an existing view from the target table to filter the list. This provides a centralized and reusable filtering logic.

8. Apply color
   Apply a background color to the options displayed in the dropdown list.
   Accessibility note: ensure sufficient contrast if combined with a text color.

9. Apply text color
   Apply a label text color in the dropdown list for better visual identification.

10. Free text
    Allow the user to type a value outside the predefined list. Disable this option to enforce strict data consistency.
11. Cache results
    Store previously loaded results to speed up future openings of the dropdown. The first load may take slightly longer; subsequent loads are significantly faster.

Once all settings are configured, click APPLY to save the column configuration.