Field that Can Be Specified for the "Fetch criteria" Setting in Related Records
The permanent link has been copied.
Article Number:040551
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 or Calculated field
Number
Calculated
Record number
Lookup: The Key field is a Number, Calculated, or Record number field
Link
Lookup: The Key field is a Link field
Link
Lookup: The Key field is a Link field
Note: 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, or Record number field