Skip to content

Lookup List ​

Description ​

ItemContent
CategoryAssociation Relationships
SortableYes
FilterableYes
Supported Filter TypesContains, Does Not Contain, Equal, Not Equal, Empty, Not Empty, In List, Not In List

Settings ​

SettingDescription
Associated TableSet the table associated with the lookup list
Display FieldSet the field in the associated table that will be displayed when selecting records
Returned Field ListAfter successfully setting the associated table, you can set the fields in the associated table that will be returned to the current table
Placeholder in Form When EmptyText displayed in the input box when no information is entered in the field
Max Number of Displayed RecordsSet the maximum number of records that can be displayed when selecting data
Display Search BoxWhether to display the search box when selecting records
Display Add Record ButtonWhether to display the "Add New Record" button in the list popup when selecting records
Use Automation to Set Candidate ListSupport using automation to filter the set option values
Automation Input ParametersParameters passed to automation based on context when calling automation candidate values

Notes

  • When the associated table and display field are modified at the same time, the data in the current table may be lost

  • When the lookup list is used as a filter condition, only the display field will be returned

  • Returned fields from associated tables are not editable, but they will be updated automatically when the associated table data changes

  • When using automation to set the candidate list, the automation must return a list of record IDs from the associated table

  • When the lookup list is used in a multi-data source table, the lookup list only supports returning the ID of the associated table, and does not support returning other fields

Settings for Associated Table Return Fields ​

SettingDescription
Field Return NameWhen a field from the associated table is returned to the current table, the identifier of the returned field in the current table
Display NameThe display name of the returned field from the associated table in the current table
Field TypeThe field type of the returned field from the associated table
Sorting MethodWhen setting the associated table, the field in the associated table used for sorting the candidate list
Sorting DirectionThe sorting direction used by the sorting field
Options: Ascending, Descending

Database Storage Format ​

The lookup list field itself does not store data; it only stores the ID of the associated table, and the storage type is determined by the ID field type of the associated table.

Usage Examples ​

Basic Usage ​

Data Association ​

Data Association

Returned Fields ​

Returned Fields

Data Display ​

Data Display

Advanced Usage ​

Set Maximum Display Records ​

Set Maximum Display Records

Display Search Box

Display Add Record Button ​

Display Add Record Button

Use Automation to Set Candidate List ​

javascript
/**
 * Set the candidate list for the lookup list
 */
return ["10000", "10001", "10002"];

Execution Effect ​

Execution Effect