Reference

A reference form field allows data stored in the database (such as a data table or data source) to be retrieved and displayed within the application. It essentially serves as a gateway through which data can be accessed and utilized within the app.

There are two types of Reference:

1. Data table
2. Data source

Although both data table and data source reference serve similar purposes in an app, they require different prerequisite configurations before they can be set up in an app.

Data table Reference

Referring data from a data table onto an app necessitates that the data table(s) have the Get (CRUD) function.

Configuration

• On the form builder, under references section, drag the Reference form field and place it on the canvas.
• In the Reference field properties, select the category as Data table Reference.
• Select the intended data table whose data you want to fetch into the application.
• Select the Get function with definitive input and output values.
• Function type (Single/List) would be auto-fetched as defined in the Get Function.
• Reference Element (Input Element) would be auto fetched as defined in the Get Function.
• Choose the referenced output elements that you want to view. These elements are specified in the Get Function and will be displayed here. Select the desired elements for which you require data.
• Provide a name to the field and save the details.
• You will see the output fields appear on the form builder, re-arrange the fields to your desire.

End-User Experience

Data source Reference

Referring data from a data source onto an app necessitates that the data source have the Data source-Reference.

Configuration

• On the form builder, under references section, drag the Reference form field and place it on the canvas.
• In the Reference field properties, select the category as Data source Reference.
• Select the intended data source-reference whose data you want to fetch into the application.
• Function type (Single/List). Please choose the type of output format you prefer: Single or List. If you select Single, the output fields will be displayed individually. If you select List, the output fields will be displayed in a grid format.
• Reference Element (Input Element) would be auto fetched as defined in the data source-reference.
• Choose the referenced output elements that you want to view. These elements are specified in the data source-reference and will be displayed here. Select the desired elements for which you require data.
• Provide a name to the field and save the details.
• You will see the output fields appear on the form builder, re-arrange the fields to your desire.

End-User Experience