QuickAppFlow Lookup
Lookup
A lookup field is used to show a list of items or the value from another database.
Drag and drop field type as Lookup.
You can change the name of the field: click on the field, check the display name, and enter the text you want.
You have to select the repository name where you store all values and the field name you want to show in the list (e.g., City list).
If you want to show city, state and country in single field then configure city field in field1, state in field2 and country in field3.
Example: Once your configuration is done, save form and check city field.
You can add placeholder for lookup field.
Example:
You can add instructions on lookup field.
If you want to make lookup field (City) required then enable “Required” setting.
Example:
You can add unique only validation on lookup field (City).
Example: if selected city is already exist in any record then it will show unique value validation.
If value (city) you want not present in the list then you can enable “Allow to add new”
Example: 1. On form you can see “Add New” option, Click on “Add New”.
2. You can see form where you can enter new city name.
3. Click on save.
4. You can see added value (City) in the list.
If you want to add any separator between two field value, you can add in lookup separator section.
Example:
If you want set default value for lookup field (City) then select value in default setting.
Example: As we set default value as “Delhi”, its showing “Delhi” city in form when we fill up.
If you want to select multiple values in single field then enable “Is Lookup Multiselect” setting.
Example:
If list has same value multiple times then enable “Consider Unique Only” setting to show value in one time.
Example:
Auto Populate:
If you want to populate value from another repository then configure auto populate.
First you need to add fields which you want to auto populate.
Enable “Auto populate” setting which is on Lookup field (City), once user select city its state automatically populates in state field.
You have to add RepositoryName.FieldName on fields which you want to auto populate.
If you select city its state will populate automatically.
Parent Child
Add two field as Parent(Category) and child (Sub Category).
If you want see only sub category of selected category then configure parent child.
Click on child field (sub category) and go to filter result section
Select common field (Category) from child field repository in field and select source field as Category.
Check in form when we select category it will show its sub category only.
Visibility Configuration
If you want hide any field on any value then you can set visibility configuration.
Click on lookup field (City) and enable “Set Visibility Configuration”.
Select a value from the left dropdown for which the value field should be hidden.
Example: We have configured it so that when Indore city is selected, the Name field should be hidden.
You can configure more than one field on click on + icon.
Let’s see how it works
We hide two fields on different value.
You can see when we select Indore city, Name field is hidden and when we select Pune city, Address field is hidden.
If you want to add a filter on the value, we added a filter that shows only cities from the state of Maharashtra.
