Using Lookup

Article Number:040548

There are two ways to retrieve data using a "Lookup" field: displaying a list of records contained in the source app and selecting the record you want to retrieve data from, or using a keyword to pick the record.
This article describes the two ways mentioned above, using an example of retrieving product information from a product management app.

For details on how to set up a "Lookup" field, refer to Configuring Lookup.

Retrieving data by selecting a record from a list of records

The steps are explained based on an example scenario where an order management app and a product management app are used. In this section, you will use a "Lookup" field in the order management app to retrieve data from the product management app.

  1. Open the order management app, then click the Add Record icon (the plus sign-shaped icon at the upper right of the screen). Screenshot: The "New Record" button on the order management app is highlighted

  2. Click Lookup on the "Lookup" field without entering any value into the field. Screenshot: The "Lookup" button on the "Lookup" field is highlighted
    A record picker dialog appears for you to select a record of the product management app.
    The dialog displays the field set as Key Field and the fields set as Fields Shown in Lookup Picker in the "Lookup" field setting. Screenshot: The record picker dialog for the product management app

  3. On the record picker dialog, click Set for the record whose data you want to retrieve. Screenshot: "Set" in record picker dialog for the product management app is highlighted
    The product code specified in the selected record is entered into the "Lookup" field.
    In addition, the product name and unit price, which are set for Field Mappings in the "Lookup" field setting, are also retrieved.
    Screenshot: Data of the selected record is retrieved

Retrieving data using a keyword

When you enter a keyword and click Lookup, you can narrow down the records to only those that match the keyword.
If there is only one matching record, the data of the record is retrieved directly, without any other operations. If there are multiple matching records, a list of matching records appears.

  1. Open the order management app, then click the Add Record icon (the plus sign-shaped icon at the upper right of the screen). Screenshot: The "New Record" button on the order management app is highlighted

  2. Enter a product code into the "Lookup" field and click Lookup. Screenshot: A product code is entered in the "Lookup" field and the "Lookup" button on the field is highlighted
    Based on the entered product code, the product name and unit price, which are set for Field Mappings in the "Lookup" field setting, are retrieved.
    Screenshot: Data is retrieved based on the product code entered in the "Lookup" field

Viewing records in the source app

When data is retrieved via "Lookup" fields, links to the source are automatically generated. Clicking on a product code link will display the source record in the product management app. A link is automatically generated

For points to note when setting up lookups, refer to Notes on Lookups.