Differences Among Select Data, Query Data, Data Linkage, and Lookup

Introduction

In Jodoo, you can retrieve records from other forms through Select Data, Query Data, Data Linkage, and Lookup. This article will review the differences among the four features in terms of application scenarios, feature types, record storage, available record filter options, and multi-records display.

Application Scenario(s)

Select Data: It can retrieve multiple records from different forms at one time. The retrieved records can be submitted to the system directly.
Query Data: It is suitable for just querying or checking related records. You do not have to submit them to Manage Data.
Data Linkage: It refers to the linkage with conditions. It can be applied to link the options of multiple Single Select and Multi Select fields, auto-fill the fields, and so on.
Lookup: It refers to the linkage without conditions. It can be applied to generate selectable options for the Single Select or Multi Select fields.

Feature Difference(s)

The differences among the four features are shown below:

Feature	Select Data	Query Data	Data Linkage	Lookup
Feature Type	Field	Field	Field Properties	Field Properties
Adding Condition for Filter/Linkage	Supported	Supported (required)	Supported (required)	Not supported
Record Storage	Supported	Not supported	Supported	Supported
Record Storage	Record storage refers to submitting the records to Manage Data. Submitted records will be displayed on the Manage Data page and can be used in the calculations such as formulas. Data that is not stored in Manage Data can update in real-time. Select Data: Data in the display fields will not be submitted to Manage Data. If you expect it to happen, you have to set Data Filling.
Retrieving Image/Attachment	Supported	Supported	Supported	Not supported
Displaying Multiple Records	Supported	Supported	Not supported	Not supported
Displaying Multiple Records	Select Data: Add the Select Data field to a subform to generate multiple sub-records. Query Data: Tick Multiple in Show Records.
Retrieving Fields from Other Subforms	Supported	Supported	Supported	Not supported
Retrieving Fields from Other Subforms	If Select Data and Query Data fields are in a form, you can query subfields from other forms. If Select Data and Query Data fields are in a subform, you cannot query subfields from other forms. Data Linkage: You can retrieve all the fields from a subform. For details, see Data Linkage for the Whole Subform.
Retrieving Data from Aggregate Tables	Supported	Supported	Supported	Not supported
Retrieving Data from Output Tables of the Data Factory	Not supported	Supported	Supported	Supported
Retrieving Data from Output Tables of the Data Factory	For details, see Retrieving an Output Table in a Form.
Adding Records to the Related Form	Supported	Supported	Not supported	Not supported
Adding Records to the Related Form	When the related form is a form, you can create records for the form (you should have the corresponding permission). If the related form is an aggregate table or an output table, you cannot create records.