Lookup
You can place a Lookup field and use that field to refer to (copy) record information stored in another app.
Because you do not need to input the same data repeatedly, you can avoid inputting errors and shorten the time to input.
For example, you can place a Lookup field in a project management app, and specify a customer management app as a datasource app. By doing so, you can import data stored in the customer management app, when registering records in the project management app.
Fields and Features That Are Often Combined
-
Related Records fields
You can list records that match the condition specified, by using a Related records field.
This field is useful when you want to put together related information into one record, since you can display records stored in another app or in the same app.
-
App Actions
You can use the App Actions feature to copy record data to another app or to the same app, to create a new record.
By combining the Lookup field, the Related records field, and the App Actions feature, you can integrate data across multiple apps, thus enabling more efficient use of kintone.
Using Lookups
For details on how to set and use lookups, refer to the following pages.
Usage Examples
If you need to input the same information in multiple apps, you can do the same task more efficiently by using a Lookup field.
For example, when inputting data in a project management app, you can refer to a company name that is already registered in a customer management app.
Steps Taken by Users
After a Lookup field is placed, users follow the steps described below.
- Click Lookup to select a record that is stored in another app.
- If you enter texts before clicking Lookup, data matching the text appears. You can also click the filter button
to specify additional filter condition or sort order.
Setting Options for Lookup Fields

- Field Name
- Specifies the header for the entry item.
- Hide field name
- Hides the field names on the screens to add, edit, enter details of, and print records.
- Required field
- Sets a field where a value is required to be entered.
- Datasource App
- Select an app to refer to.
As you enter an app name, apps matching the text appear.
After selecting an app and saving the form, you cannot change this setting.
- Select an app to refer to.
- Key Field
- Select a field that will work as a key to retrieve data from the datasource app.
You can set Record number, Text, Number, Calculated, Lookup, or Link field as a key field.
After selecting an app and saving the form, you cannot change this setting.
- Select a field that will work as a key to retrieve data from the datasource app.
- Field Mappings
- You can get data in other fields from the datasource app at the same time. Specify the mapped field in the datasource app to the field in this app.
Refer to Fields That Can Be Specified for "Field Mappings"
- You can get data in other fields from the datasource app at the same time. Specify the mapped field in the datasource app to the field in this app.
- Fields Shown in Lookup Picker
- Select the fields to show on the record selection screen.
Drag and drop the arrow icon to change the order of fields.
- Select the fields to show on the record selection screen.
- Initial filter setting
- Specify conditions to filter records on the record selection screen.
- Initial sort setting
- Specify the display order of the records on the record selection screen.
- Field Code
The text string to specify this field (in a formula or an API).