Fields that Can Be Specified for the "Fetch Criteria" Setting in Related Records

Combinations of fields that can be specified for "Fetch Criteria" in the Related Records field differs depending on the field type.
If you specify a field in "Field in This App" (the dropdown on the left), fields that can be combined with the specified field are displayed in "Field in Datasource App" (the dropdown on the right).

Refer to the following table for the combination of fields that can be specified.

Field in This App Field in Datasource App
  • Text
  • Lookup: The Key field is a Text field
  • Text
  • Link
  • Lookup: The Key field is a Text field
  • Number
  • Calculated
  • Lookup: The Key field is a Number/Calculated field
  • Number
  • Calculated
  • Record number
  • Lookup: The Key field is a Number/Calculated/Record number field
  • Link
  • Lookup: The Key field is a Link field
  • Link
  • Lookup: The Key field is a Link field
* When setting a Link field, you must match the Type.
  • Record number
  • Lookup: The Key field is a Record number field
  • Number
  • Calculated
  • Lookup: The Key field is a Number/Calculated/Record number field