Article summary
Did you find this summary helpful?
Thank you for your feedback
An overview of data source reference
After reading this article you will know:
- What is a data source reference
- How to create it
The sole purpose of a data source-reference is to fetch data in to an application from the data source with selective Input fields and related Output fields.
How to configure data source reference?
NOTE
To create a DS-Reference, you must have a data source. Learn to create a data source...
- Once you have a data source ready, simply click on the data source to see the Actions & Adoption Types, as shown below.
- Click on the "+" corresponding to the References option to start creating a data source reference.
- On the Create Reference page, do the following configurations:
- Give a name to the reference
- Select an Add-on, if required, to diversify the data visualization.
- Select an Input Field. The data field you specify here will be the primary identifier/condition for fetching the entire data record/selected output fields, in an app. However, the data fetching depends on the Condition Operators.
- Equal: This operator will fetch the relevant info of the selected input value.
- Not-Equal: This operator will fetch the irrelevant info of the selected input value.
- Greater Than: This operator will fetch the data of the input value which is greater in value to the selected input value (Number or Date)
- Less Than: This operator will fetch the data of the input value which is lesser in value to the selected input value (Number or Date)
- Greater Than or Equal To: This operator will fetch the data of the input value which is greater or equal in value to the selected input value (Number or Date)
- Less Than or Equal To: This operator will fetch the data of the input value which is lesser or equal in value to the selected input value (Number or Date)
EXAMPLE
Assume a data source in which we have a data record with data fields as Employee ID, Employee Name, Employee Email, Employee Phone Number.
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.
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.
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.
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.
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.
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.
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 |
Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
0011 | Xing Long | xing@gmail.com | 9876785432 |
Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
0011 | Rama | rama@gmail.com | 0989087654 |
Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
0012 | Rama | rama@gmail.com | 0989087654 |
Employee ID (Input Field) | Employee Name (Output Field) | Employee Email (Output Field) | Employee Phone Number (Output Field) |
0011 | Xing Long | xing@gmail.com | 9876785432 |
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 |
0011 | Xing Long | xing@gmail.com | 9876785432 |
0012 | Rama | rama@gmail.com | 0989087654 |
- Order By: Use this option to arrange the list of output values either in Ascending or Descending order.
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.
Was this article helpful?