Using Lookup List function to return rows of values

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.

Learn more about Lookup List field

Learn the differences of using Lookup

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".

Use Case

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.

mceclip0.png

<Return to Top> 

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.  

mceclip0.png

mceclip1.png

<Return to Top> 

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

Lookup10003.png

  • Appearance:   

#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. 

mceclip2.png

#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.

mceclip3.png

  • Validation:  Custom validation or event rules if any.  

Lookup10007.png

 <Return to Top> 

Step 4. Manage the layout and publish

Preview and check the function before it publishes.

mceclip4.png

When clicking on the search icon and we will get the pop-up window;  We will see all items listed for multiple selection. 

mceclip5.png

mceclip6.png

<Return to Top> 

Example Demo

The following image shows the effect of example.

mceclip7.png

<Return to Top> 

Furthermore

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.

<Return to Top> 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.