Field that can be specified for the "Fetch criteria" setting in related records

The permanent link has been copied.

記事番号: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).
Screenshot: The settings for a "Related records" field are displayed
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

Supplementary information

Any field that is set in a table cannot be specified.
Values in the calculated fields are treated as a number, regardless of the display format that is set for the field. When the display format of non-number type is set, each value in the calculated field is treated as the following number values respectively:
- If the display is in hour format
  The value is treated as seconds.
  Example: 1 hour will be treated as "3600".
- If the display is in time format
  The value is treated as the number of seconds elapsed since 00:00 AM.
  Example: 1:00 AM will be treated as "3600".
- If the display is in date format
  The value is treated as UNIX time at 00:00 AM (UTC) of that day.
  Example: 2014-4-1 is treated as "1396310400".
- If the display is in date and time format
  The value is treated as UNIX time of that day. The time zone is applied to the date and time.
  Example: 2014-4-1 00:00 AM (UTC) will be treated as "1396310400".
  Note: UNIX time is the number of seconds elapsed since 1970-1-1 AM 00:00 UTC.