A Lookup List is also a data relationship control that enables you to create a relationship between two forms. Using it you will be able to "lookup" and return a list of data from the related source data form in Yeeflow.
The lookup list field is NOT applicable in data list of Applications.
The lookup list enable you to return any type of fields and it will display the value(s) of the related field that you have picked. Different than a lookup, A lookup list applies to return values to an associated list that displays in a table.
Each item(or saying "record') that you add in data list form will generate an item ID. The lookup field will be recognized as its source item ID(s).
The source data/form is the database from which the lookup are coming. A source data/form can be any data list in Application of Yeeflow.
The target data&form is the to which you are using "lookup list" to return the value(s). The target form is applicable to the form builder in Forms.
Source Binding & Display
You need bind the source data to define their relationships, basically a data list in Application.
You MUST pick any field of source list as "Display field" that will display its value on this field. There is a default tooltip to display its name also.
Yeeflow offers "Additional Fields" to return a number of associated fields. In most scenarios, you need add conditions to "Filter" these data items from source data.
To do this, you should have a list field firstly. Both associated fields share the same data type. E.g. A user field in this list field should be associated with a user field in source data.
Basically the associated fields in this list or the full list field will be set as Readonly.
At the window of Additional Fields, you should pick an existing list to bind; The checked field(s) will be listed as order and displayed in lookup window.
A lookup list enables user to pick multiple items from source data list, then it returns and reflect a table list according the association.
Conditions and Filters
By default, the lookup list displays all the items present in the source data. In some scenarios, you may apply some filters based on data in the source data form.
When setting filter for a lookup：
- Only index fields can be selected from your source data. Learn how to set the index of a field.
- Yeeflow offers an Expression Editor to meet the criteria for that filter field.
- You can add multiple conditions for criteria. The data will be returned only if all conditions are met.
Label & Binding
The label will display as the title of this field. You can define the name for this field.
In Form builder, You also can switch off "Display Title" to hide the label on the form.
Binding is also only applicable for form builder. A lookup field can be reset to bind with any other lookup/lookup list controls on this form.
Define the appearance of this field to change the styles.
Placeholder is a text input that provides a short prompt that describes the expected value of user input. The prompt is displayed in the field before you enter a value, and disappears when you begin typing.
Dynamic Display Rules
When you set a dynamic display rule for this field, It behaves differently based on specific conditions and rules. There are seven actions(Hide/Show/Read-only/Editable/Set Background/Set Border color/Set Font color) for lookup controls.
You can enable/disable comments on this field after the form is submitted. There are two options to trigger comments entering: On Click and Mouse Hover.
For a bound control, the comment key will be auto-bound with this control/field.
Validation will verify that the data users enter in this form meets the standards you specify before the form can be submitted.
Set this field as read-only to create variable form pages of your workflow(or application versions) . All bound controls (fields) can be made read-only, with the exception of fields that are already read-only by default. E.g. Calculation.
Required field will make sure the user provides a response. When a field is required, an error message will display under this field and at right top of the form. The form cannot be submitted until a value has been added to the field.
Required fields are indicated by a red asterisk(*) next to the label. By default, fields are never required.
Please Note: Only a required field in visible of this form will trigger the validation action.
You can set a custom error message that will display under your field when specified conditions become true. It will allow you to add any number of rules for validating your field.
Learn more about the Custom Validation.
Event Rules (only applicable for Approval Form and List Form)
Event rules allow you to set actions that should be taken on events that meet your designated rule criteria. You can create event rules to execute any number of actions based on this field.