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.

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.

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

Add the "Lookup" and manage its properties.

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.

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

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

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.