Using Lookup to return multiple values

  • Updated

The Lookup field allows you to search and return related values that organized source data in Yeeflow.

At its most basic, a lookup field returns values by the field associating. You can use it with any type of data source, so long as both the source and target datasets have a field that shares the same data type.

Learn more about Lookup field

Learn the differences of using Lookup List

The Lookup is one of the most powerful functions in Yeeflow. There are many ways to exploit these features to accomplish some truly incredibly values. 

Use Case

Step 1. Create or manage a data list as "source data"

Firstly, you need to make your data list of "Machine List" , which says "source data".  

E.g. we have a 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 filtering, please add this list field to index. As exampled, the "Status" is an index field.


<Return to Top>

Step 2.  Add associated fields in your "target form"

Now, let's build the form (which says Target form ) that references the source data.

Add four fields to your target form according to the column(field) types in source data.  

E.g.  Text Box controls for "Type","Name","Model" and Date Picker control for "Active service date" .


 <Return to Top>

Step 3.  Set properties of Lookup 

Add the "Lookup" and manage its properties.

  • Source Data Binding: Binding the source data while you created in Step 1


  • Appearance:  Select any field of source data as the "Display Field" that will be displayed on this field after you looking for. 


Then, you can manage the associated fields while you created in Step 2;

The checked field(s) will be listed in lookup windows. 


Optionally, You may add some conditions to "Filters", e.g. Status is equal to Active.  In that case, you will get all data items under conditions.


  • Validation:  Custom validation or event rules if any more logic required.  


<Return to Top>

Step 4,  Manage the layout and preview

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 the items listed under condition of "Active". 


<Return to Top>

Example Demo

After the form published.  The following image shows the effect of example.


<Return to Top>


You can also use it in property value expressions and calculated field expressions. It means that if we can force a calculation to be a field calculation, we can get a result when it is calculated. This is extremely important in more complex scenarios. 

<Return to Top>

Was this article helpful?




Please sign in to leave a comment.