Advanced Search in a Lookup Field

Advanced search in a lookup field

When the Lookup field has large number of records then finding a particular record becomes cumbersome. Moreover, the basic search will display only 5000 results and manually scrolling down through these results to find the required record is tedious. The Advanced search option will enable you use the advanced search mechanism and zero down on the required records or field values in the lookup fields.

Note:
  1. The advanced search is available only for lookup fields with the display type set as dropdown or multi-select.
  2. If the lookup display field is either a user field or date-time field, then the basic search will disabled. And by default, the advanced search will be enabled.
  3. If there are more than 500,000 records in the lookup field, the the basic search will be disabled. And by default, the advanced search will be enabled.

Enable advanced search a lookup field

  1. Open the form builder.
  2. Select the required lookup field.
  3. Navigate to the Field Properties -> Choices section on the right.
  4. Check the checkbox next to Advanced Field Search option.

  1. Access the application.
  2. Navigate to the required lookup field.
  3. Click on the Advanced search button.

  4. The Advanced Field Search popup will appear.

  5. In the left pane of the popup, the lookup field(s) will be listed. Choose the required search operator and enter the appropriate search keywords.
    Note: The Is option will be default search operator.

  6. Click Search.
  7. The list of relevant search results will be displayed on the popup.

  8. Choose the required record and click Done.


  1. Understand Lookup field
  2. Configure bidirectional lookup
  3. Relationships between forms
  4. Unidirectional and bidirectional relationships