A Data Source Reference in Quixy is a configuration that allows an application to fetch and display data from an existing Data Source based on a defined condition. It acts as a lookup mechanism, enabling applications to retrieve relevant records or values dynamically without duplicating data.
Data Source References are commonly used to:
A Data Source Reference works by linking:
When a user enters or selects a value in the input field, Quixy applies the configured Condition Operator to fetch matching records from the data source and returns the corresponding output fields.
A Data Source Reference can be created in two ways:
The Create Reference page is the main configuration screen used to create a Data Source Reference. It allows users to configure input fields, condition operators, output behavior, and additional reference settings.
Assume a data source in which we have a data record with data fields as Employee ID, Employee Name, Employee Email, Employee Phone Number:
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
|---|---|---|---|
| 0011 | Xing Long | xing@gmail.com | 9876785432 |
| 0012 | Rama | rama@gmail.com | 0989087654 |
If the Condition Operator is selected as Equal and the input value for Employee ID is 0011, the system retrieves the matching record.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
|---|---|---|---|
| 0011 | Xing Long | xing@gmail.com | 9876785432 |
If the Condition Operator is selected as Not Equal and the input value for Employee ID is 0011, the system retrieves records that do not match the selected value.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
|---|---|---|---|
| 0012 | Rama | rama@gmail.com | 0989087654 |
Note
The configuration to determine whether the output values are displayed as Single or List is available in the Reference form field settings within the application.