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 of the product management app.

  1. Open the "Order management" app.

  2. Click the New 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

  3. 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 settings dialog. Screenshot: The record picker dialog for the product management app

  4. 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 settings dialog, 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.

  2. Click the New 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

  3. 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 settings dialog, 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. Screenshot: A link is attached to the field retrieved by lookup

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