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.

• Setting Lookup
• Using Lookup

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.
• 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.
• 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"
• 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.
• 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).