A Lookup List field control enables you to select multiple items from a data list in the same application or in another application, then add those selected items to an associated List control as multiple rows.

The lookup list enable you to return any type of fields and it will display the value(s) of the related field that you have picked. Different than a lookup, A lookup list applies to return values to an associated list that displays in a table.

Let's assume you have a purchase order form which allow users to select multiple products from your products data list, which includes the product name, category and unit price. Users can select products with the Lookup List control. Once the products are selected, those items will be added to the below associated List control. Users than can input the quantity of each product, and calculate the total price with the calculation field in the list.

The Lookup List field control itself will also save the selected items IDs in it's associated variable. You can decide to display or hide the selected items on your form.

The Lookup List field control is only available on Approval form, and NOT applicable in data list of Applications.

Each item(or saying "record') that you add in data list form will generate an item ID. The lookup field will be recognized as its source item ID(s).

The Data source is a data list from which the lookup are coming. The data list can come from any application in your Yeeflow account.

The target List field control which you added on your current form.

Firstly, find the Lookup List control in the controls add panel. Then, drag and drop it into a section or container on your form.

Open the Content > Basic block and set the Title's text of this Lookup List control. For more information about Title for field control, please refer:

Understand the Title of field controls

Set the Associated variable for this Lookup List control. When you add a new Lookup List control, a default variable will be generated automatically. You can click the Edit Button to change the ID and name, or click the Reset button to bind this Lookup List control to other existing variables. For more information, please refer:

Understand form controls and the associated variables / fields

In the Application section, select current application or a different application from the dropdown list.

Afterward, move on to the List section. Select the data list under the selected application.

In the Data Filters section, click the condition button to filter the data from the selected data list.

Set the Primary Order and Secondary Order to sort your data properly.

Text: Set the text of Lookup List button control.

Tooltip: Set the tooltip text of Lookup List button control.

Align: Set the alignment of the button as Left, Center, Right or Justify.

Size: Set the size of Lookup List button from small to large.

Icon: Choose whether display icon or not on the Lookup List button.

Position: Choose display the icon before or after the text on the Lookup List button.

Space: Set the space between the icon and the text on the Lookup List button.

Max Selection: Set how many items are allowed to be selected.

Display Field: Select the field which will be displayed as the value of selected items.

Additional Fields: Click "Settings" button to set the fields which will be displayed from the list items picker window.

For example, the associated list is set to "Selected Products" which is a List field control on the current form, which includes 5 columns: Product, Category, Price, Quantity and Sub Total. You can set the mapping relationship from the pop-up window:

When users select items from the source data list "Products", the selected items will be added to the associated list "Selected Products" by auto-fill the values of those associated fields: Product, Category and Price.

Display selected items: Turn on to display the selected items after the Lookup list button.

Display Title: Choose display or hide the label of this control. For more information, please refer: Understand the label of field controls

Allow comment: Turn on this option will allow users to add comments on this control.

Dynamic Display Rules: When you set a dynamic display rules, It behaves differently based on specific conditions and rules. Learn how to create dynamic display rules for a control

.

Open the Content > Validation block to set the properties of this User field control.

Readonly: Turn this ON will make this field control as view only status.

Required: Make this field as required. Users cannot leave the content as empty.

Custom Validation: Set the custom validation rules. An error message that will display under your field when specified conditions become true. It will allow you to add any number of rules for validating your field. Learn more about the Custom Validation

.

Open the Content > Action block to call a pre-defined action from the dropdown list. This action will be triggered once the value of this image field is changed.

Learn more about Actions.

Open the Style > Field block to set the styles of the field control.

Set the Title of field controls that are applicable to this control.

Set the Advanced options that are applicable to this control.

​