I'm trying to set up a form in Survey123 Connect to have two questions:
When the second question type is set as "select_one_from_file PBSData.csv", the responses shown have radio buttons and the user is able to select just one of the tank names. However, if it's set as "select_multiple_from_file PBSData.csv", the radio buttons do become checkboxes but clicking on one checkbox causes all of the checkboxes to be ticked.
Has anyone run into this issue previously? It seems like I'm missing something basic.
Solved! Go to Solution.
How to create an external choice list
External choice lists are stored as CSV files. Unlike the choices worksheet in your XLSForm, which can contain multiple lists in a single worksheet, a CSV file can only contain one list. The rules to create the CSV file are:
The filename cannot contain spaces. The name of the file, becomes the name of your list.
You must include at least two columns: name and label (just like in the choices worksheet):
The name column includes the choice codes. No special characters, spaces or duplicates allowed.
The label will be used to present the choice to the user.
The CSV has no 'name' column. It won't work without a name column.
Not sure why there is a regex function in the choice filter column. It would return 'true' if the input was correct but I don't think it applies an actual filter?
I would recommend reading the blog post above. To achieve what you are after you would:
Can you share the spreadsheet?
I would guess that it's not formatted quite right. Check the fields/columns are named correctly and the values within are correct
Apparently I can't upload CSVs but here are screenshots of the CSV, the xls form, and the form itself. I'm fairly positive it's formatted correctly since it's a really basic form.
How to create an external choice list
External choice lists are stored as CSV files. Unlike the choices worksheet in your XLSForm, which can contain multiple lists in a single worksheet, a CSV file can only contain one list. The rules to create the CSV file are:
The filename cannot contain spaces. The name of the file, becomes the name of your list.
You must include at least two columns: name and label (just like in the choices worksheet):
The name column includes the choice codes. No special characters, spaces or duplicates allowed.
The label will be used to present the choice to the user.
The CSV has no 'name' column. It won't work without a name column.
Not sure why there is a regex function in the choice filter column. It would return 'true' if the input was correct but I don't think it applies an actual filter?
I would recommend reading the blog post above. To achieve what you are after you would:
That worked - much obliged.