Configuring a "Related Records" Field
To display a list of related records, place a "Related records" field in an app and specify the following:
- An app to be referenced (You can specify either a different app or the same app.)
- Fields to be used as a fetch criteria (When the values of the specified fields match, the source app's records with a matching value are displayed in the list of related records.)
- Fields to be displayed in the list of related records
This article provides an example of how to retrieve information from the "Lead Management" app and display the information in the list of related records in the "Customer Management" app. In this example, you will associate "Company Name" fields included in the two apps and display lead data (e.g. "Lead Title" and "Estimated Purchase Date") for the company with a matching name in the list of related records.
-
Open the "Customer Management" app (the app on which you wish to display related records).
-
Click the App Settings icon (the gear-shaped icon) at the upper right of the "View" screen.
-
On the "App Settings" screen, click Form tab.
-
Place a "Related records" field on the form.
-
Hover your cursor over the Field Settings icon (the gear-shaped icon) at the upper right of the "Related records" field that you placed, then click Settings.
-
Enter the field name.
In this example, enter "Leads" as the field name. -
For Datasource App, select an app to be referenced.
In this example, select the "Lead Management" app. -
For Fetch Criteria, select a field in the current app and the corresponding field in the source app. When you enter a keyword, relevant fields appear as options.
Since you want to display lead information for a customer whose name appears in both apps, set the criteria as follows: "Company Name" (in the current app) = "Company Name" (in the source app). For information on the types of fields that can be specified, refer to the following page.
Field that Can Be Specified for the "Fetch Criteria" Setting in Related Records
Records with a matching "Company Name" field value are displayed in the list of related records. -
If you want to add more conditions, specify them in Filter.
In this example, leave All records selected. -
In Datasource App Fields to Display, select the fields you want to display in the list of related records.
In this example, select "Lead Title," "Probability," "Estimated Purchase Date," "Total Price," and "Sales Representative."
Some fields cannot be selected under Datasource App Fields to Display. For details, refer to the following section.
Fields that cannot be displayed in lists of related records -
Select a sort order in Display Order, and then select the number of records you want to display at a time in Max Records to Display at a Time.
-
Specify Field Code as needed.
-
Click Save.
-
Click Save Form on the upper left side of the screen.
-
Click Update App at the upper right of the screen.
-
On the confirmation dialog, click Update App.
The following field types cannot be set under Datasource App Fields to Display in the settings of "Related records" fields.
- Related records
- Table
- Field group
- Label
- Blank space
- Border