Sheet Mode / Features Overview / Field Types / Related Records
In This Topic
    Related Records
    In This Topic

    The records of an app that is associated in the Form tab of the Kintone app can be displayed in the view of krewSheet. Records can't be edited or added.

    Configuring Related Records

    (1) Set the Related Records field in the same steps as kintone.

    (2) Drag the set related record list from the field area of krewSheet to the sheet area to place it, as shown in the figure below.

    (3) The related record list view is displayed in krewSheet.

    (4) To create a list, drag the Related Records field to the Related Sheets area.

    Setting Items

    The table shown below shows whether or not the same setting or display of setting items of the Kintone Related records field are available in krewSheet.

    Kintone krewSheet Remarks
    Field name
    Do not show the field name -
    Field Code
    App to Refer
    Conditions of record to be displayed
    Field to be displayed
    Sorting records
    Maximum number of records to be displayed at once
    Initial setting for filtering
    Initial setting for sorting

    Operation of Related Records

    Multiple Related Records lists can be displayed by switching tabs. They can be deleted by right-clicking on the tabs.

    When a Related Records list is selected, the ribbon menu works on the selected Related Records list sheet. The available ribbon menu items depend on which sheet is selected. For details, see "Ribbon Menus" in "krewSheet Functions". The field specified in the Setting Field of the Form tab of Kintone app will be displayed as a list of related records in the field area.

    • Records with focus within a main list in the sheet area will be displayed in the Related Records list.
    • Up to the top 10,000 records that fulfill the related records acquisition conditions will be displayed. Please review the filtering/sorting conditions if necessary.
    See Also