With Lookup, an app can reference another app to copy necessary data.
For example, an Order Management app can have a Lookup field that references a Product Management app. This enables users to copy product information from the Product Management app to the Order Management app. Lookup removes effort to re-enter the same data and prevents typing errors.
See What Is Lookup?
Procedure to Set Up a Lookup Field
This section uses an Order Management app and a Product Management app to describe how to set up a Lookup field as shown in the figure above.
Adding Product Records to the Product Management App
The Product Management app must already have some records registered to it before the Order Management app can get data from the Product Management app.
In this example, we will create records that contain the Product Code, Product Name, Unit Price, and other fields.
Adding a Lookup Field to the Order Management App
Next, add a Lookup field to the Order Management app.
Click Settings in the upper right of the record list screen of the Order Management app to open the settings page.
Opening App Settings Page
On the screen to set forms, place a table on the form.
Drag and drop a Lookup on the table.
In this example, we configure a Lookup field which will obtain information based on the Product Code.
Add other fields to obtain information from the Product Management app to the table.
In this example, add the following fields:
Product Name: Text field
Unit Price: Number field
Quantity: Number field
Subtotal: Calculated field
Hover the mouse pointer over the Lookup field and click Settings to open the settings screen.
Configure the following settings.
Set Field Name.
In this example, enter "Product Code".
Set Datasource App.
Select an app from which you want to copy data. In this example, select the Product Management app.
Set Key Field.
Select a field that will work as a key to find a corresponding record. In this example, select the Product Code field.
Set Field Mappings.
Other fields can be copied at the same time from a record in the datasource app.
In this example, add the following pairs: Product Name < [Product Management]Product Name, and Unit Price < [Product Management]Unit Price.
Click the plus sign (+) to add as many as fields as you want to copy data from.
Set Fields Shown in Lookup Picker.
Select the fields that will be displayed to help users select a record appropriately. Select the Product Name and Unit Price fields. For details on how the fields work, see Using Lookup.
Set Initial sort setting.
Specify how to sort found records. Select the Product Code field and Ascending.
Click Save on the settings screen of the Lookup field.
Click Table Settings from Table settings menu located at the upper right of the table, and specify a table name.
Enter a table name and click Save.
This example uses "Product Information" as a name.
Click "Update App" on the upper right side of the screen.
Now, the Lookup field is ready.
Other Lookup Example
When you set Lookup, you can also copy data from multi-choice fields or check box fields.
This section describes the way to copy the following data created in the Customer List app to the Project Management app.
- Products (Multi-choice field)
- Options (Check box field)
Since both the Customer List app and the Project Management app use company names, associate these company names to copy products and options.
Place the lookup field as a company name in the Project Management app, and set the field as shown below.
Now, by entering a company name in the Project Management app and clicking Lookup, you can copy products and options from the Customer List app.
Video on How to Set Up Lookup
The following video explains how to set up Lookup using a Customer Management app and a Project Management app.
Notes on Lookup
Once users copy data through a Lookup field, changes to records in the datasource app do not propagate to copied data in the Lookup field.
Users need to click Lookup again to overwrite existing data with the latest data.
To update existing records, it is more efficient to update them in bulk by importing a CSV file.
However, you can use the lookup feature to update the entered values in fields in bulk only if the following conditions are met:
- If there are no overlapping values in the fields that are selected for "Key Field" in the existing record.
- If "Prohibit duplicate values" is selected for the setting in the fields that are selected for "Key Field".
The Key Field can be any of the following fields:
- Record number
Any field that is set in a table cannot be specified.
Even if you modify the setting in the lookup field, values in the following field for the entered record do not change:
- The field that is selected for "Field Mappings" in the setting of the Lookup field.
For details on how to use Lookup, see Using Lookup.