Introduction
A Lookup field links a record in your data list to a record from a source. In this guide, a purchase item uses a product number to select a product from the Products list. You can also show the product name in the picker and map its name and price to fields in the purchase list.
For a lookup configured directly in a form, see the Lookup control.
1. Adding a New Field to Your Data List
Navigate to your data list within Yeeflow.
Click on the "+ New column" button, located at the end of the header.
A slide-in window will appear from the right side of your screen.
2. Choosing the Field Type
In the new field configuration window, locate the 'Field type' dropdown list.
Select 'Lookup' from the list of available field types.
3. Setting Up the Lookup Field
Enter a 'Display name' for your field in the provided textbox.
Decide if this field should be unique by selecting the 'Unique value' option.
Add a custom placeholder in the provided space if necessary.
Choose whether this field will allow multiple values by toggling the 'Multiple' option on or off.
4. Configuring Display and Source Settings
In the 'Display style' dropdown, select your preferred control type—either 'Data picker' or 'Dropdown list'.
Choose your data source: this can be from the current application or another application within your Yeeflow account.
From the 'Data source' dropdown, select the desired data list, document library, or form report.
In the 'Display field' dropdown, choose which field value will be displayed when a user selects an item.
If you wish to use another field for the Tooltip, select it from the 'Tooltip' dropdown list.
For the purchase example, select Purchase management as the application, Products as the data source, and Product Number as the display field.
5. Additional Fields Configuration
Prepare a text field for Product Name and a currency field for Product Price in the purchase list. Open Additional Fields and select Settings.
In the Associated fields column, map Product Name to Product Name and Price to Product Price. Each target field should have a compatible type.
For a data picker, use the checkboxes to choose which source fields users see in the picker. Use Order to set their display sequence. The Associated fields column controls which values are copied when users select an item.
6. Sorting and Filtering Options
Under 'Primary order' and 'Secondary order', choose the fields by which you want to sort the data.
Use the 'Condition' button under 'Filter settings' to establish any necessary filtering conditions for the data.
Determine if the field is mandatory by toggling the 'Required' option on or off.
7. Saving the Field Settings
Select Save to create the field. Open a test purchase record, select a product, and check that the lookup shows its number and that the mapped fields show its name and price.
Change or clear the product and verify the result. If this field allows multiple values or draws from another application, test those cases with a user who has the intended access. See data list permissions.

