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 apps to retrieve relevant records or values dynamically without duplicating data.
DS References are commonly used to:
A DS 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.
To create a DS-Reference, you must have a data source.
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 |
Case 1: Keeping the Conditional Operator as Equal, if you select the input value for Employee ID as 0011 the resultant output values will be relevant, as given below.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
| 0011 | Xing Long | xing@gmail.com | 9876785432 |
Case 2: Keeping the Conditional Operator as Not-Equal, if you select the input value for Employee ID as 0011 the resultant output values will be irrelevant, as given below.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
| 0011 | Rama | rama@gmail.com | 0989087654 |
Case 3: Keeping the Conditional Operator as Greater Than, If you select the input value for Employee ID as 0011 the resultant output values will be, as given below.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
| 0012 | Rama | rama@gmail.com | 0989087654 |
Case 4: Keeping the Conditional Operator as Less Than, if you select the input value for Employee ID as 0012 the resultant output values will be, as given below.
| Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
| 0011 | Xing Long | xing@gmail.com | 9876785432 |
Case 5: Keeping the Conditional Operator as Greater Than or Equal To, if you select the input value for Employee ID as 0011 the resultant output values will be, as given below.
| 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 |
Case 6: Keeping the Conditional Operator as Less Than or Equal To, if you select the input value for Employee ID as 0012 the resultant output values will be, as given below.
| 0011 | Xing Long | xing@gmail.com | 9876785432 |
| 0012 | Rama | rama@gmail.com | 0989087654 |
Note
The configuration option to decide whether the output values a list or single is available in the apps under Reference form field's settings.