You can use the contents of a data source to generate the response list of an existing Multiple Choice or Radio Button Group question.
Implementation:
- Switch to the Definition tab.
- Double-click the intended question to access its Properties tab.
- Click Data Source.
- Tick the Use the Data Source Below For This Question check box, then use the drop-down menu immediately below it to select the intended data source.
- Using the Field To Display To the End-user drop-down menu on the left, select the data source field whose values you want to provide as potential responses to the question - also known as the Display Field. As the name suggests, this field is used for display purposes only and does not pass a value to the question itself.
- Using the Field To Use For the Value drop-down menu on the right, select the data source field whose value you want the question to store when the user selects a response - also known as the Value Field.
You can select the same field in both drop-down menus, if needed.
- (Optional) By default, responses drawn from a data source are displayed in the same order they appear in the source table. If you would rather sort the responses in descending alphanumeric order, tick the Sort Descending check box.
- If the selected display field contains multiple instances of the same value, you can tick the Show Unique Values Only check box to limit each value to a maximum of one appearance in the multiple choice response list.
- (Optional) If you want to apply a filter to the response data, click the Choose a Filter button. Select a filter and press OK.
- (Optional) You can control when the question will connect to the chosen data source by ticking the Only Connect To Data Source When the Following Condition Is Met check box, and typing an expression into the field provided. This will assign a Data Source Connect Expression attribute to the question, preventing it from fetching data unless the expression returns True. You can remove this limitation by either unticking the check box or manually deleting the attribute. For more information about this specific attribute, refer to Appendix: Attribute Types.
- Click OK to apply your changes to the question.