The LOOKUP LIST enables you to search and display the contents of a list data that is organized in rows.
A lookup list returns a list values on the target form by associating with source data. Similar with a lookup, you can use it with any type of data source, so long as both the source and lookup datasets have a field that shares the same data type.
The lookup list is one of the most powerful functions in Form Builder of Yeeflow. There are many ways to exploit these features to accomplish some truly incredibly values.
To demonstrate this function, we will also take the same use case in LOOKUP function, which will show what's differences between "LOOKUP" and "LOOKUP LIST".
Step 1. Create or manage a data-list as "source data"
Firstly, you need to make your data list of "Machine List" in Applications, which says "source data".
E.g. we have a source list with properties: Status(option text), Type(option text), Name(text), model(text), active service date(date).
Add or upload items for this source list.
Please Note: If any field will be used for filter, please add this list-field to index. As exampled, the "Status" is an index field.
Step 2. Add associated list in your "target form"
Now let's move to "Form Designer", which says "target form".
You need have or add a "List" control and set with associated columns according to the list-field types in source list.
Step 3. Set properties of Lookup List
Add the "Lookup List" and manage its properties.
- Source data Binding: Bind the source data while you created in Step 1
#1- Set the number of "Max Selection", which will restrict the number of rows in associated list.
#2- The "Display Field" is a must, as it will be displayed on this field after you looking for.
#3- Manage "Additional Fields". You need pick an associated list and associated fields while you created in Step 2. The checked field(s) will be listed in lookup windows.
#4- Optionally, You may add some conditions to "Filters". E.g. If you set the Status is equal to Active. In that case, you will get these items that meet criteria.
- Validation: Custom validation or event rules if any.
Step 4. Manage the layout and publish
Preview and check the function before it publishes.
When clicking on the search icon and we will get the pop-up window; We will see all items listed for multiple selection.
The following image shows the effect of example.
Additionally, You can also use it in property value expressions and calculated field expressions in associated list. It means that if we can force a calculation to be a field calculation, we can get the a result when every item/row is calculated.
As you can see, the LOOKUP LIST can be a great reference for multiple items selection. Comparatively the LOOKUP is good to be used to single item.