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