Update on this question. Adding a hidden question to serve as a placeholder for filtering a select_one_external is the right approach; however, there are some pitfalls that can occur when updating the itemsets.csv which will cause the select_one_external dropdown to not load. This is only occurring in the native application, no issues on the web app. To inspect how the csv is storing the values, use a text editor instead of excel. Here are two options for getting the filter to work:
- Quote all non-numeric columns in itemsets.csv. When modifying the data from excel and saving as a csv or by doing it programmatically with python, the default export settings does not wrap quotes around data elements. When Survey123 connect exports the itemsets.csv it wraps the _EXTERNAL data elements as “_” but when modified from excel or python the value ends up as unquoted. This can easily have modified and solve the issue as follows:
WRONG (QUOTE NONE):
list_name,name,label,_EXTERNAL
facility,2.0,ABINGDON AREA HEADQUARTERS AND SHOP,_
facility,85.0,ABINGDON RESIDENCY COMPLEX,_
facility,111.0,ACCOMAC RESIDENCY COMPLEX,_
CORRECT (QUOTE ALL):
"list_name","name","label","_EXTERNAL"
"facility","2.0","ABINGDON AREA HEADQUARTERS AND SHOP","_"
"facility","85.0","ABINGDON RESIDENCY COMPLEX","_"
"facility","111.0","ACCOMAC RESIDENCY COMPLEX","_"
CORRECT (QUOTE NON-NUMERIC):
"list_name","name","label","_EXTERNAL"
"facility",2.0,"ABINGDON AREA HEADQUARTERS AND SHOP","_"
"facility",85.0,"ABINGDON RESIDENCY COMPLEX","_"
"facility",111.0,"ACCOMAC RESIDENCY COMPLEX","_"
- Quote nothing, but include an additional column following the choice filter or move the choice filter so it is not in the last position:
WRONG (CHOICE FILTER IN LAST POSITION):
name,facility,label,list_name,image,label::language1,_EXTERNAL
1.0,,ACCOMAC RESIDENCY COMPLEX,facility,,,_
2.0,,AIRPORT AREA HEADQUARTERS,facility,,,_
3.0,,AMISSVILLE STORAGE AREA,facility,,,_
CORRECT (CHOICE FILTER NOT IN LAST POSITION):
name,facility,label,list_name,image,label::language1,_EXTERNAL,EMPTY
1.0,,ACCOMAC RESIDENCY COMPLEX,facility,,,_,
2.0,,AIRPORT AREA HEADQUARTERS,facility,,,_,
3.0,,AMISSVILLE STORAGE AREA,facility,,,_,
CORRECT (CHOICE FILTER NOT IN LAST POSITION):
name,facility,label,list_name, ,_EXTERNAL,image,label::language1
1.0,,ACCOMAC RESIDENCY COMPLEX,facility,_,,
2.0,,AIRPORT AREA HEADQUARTERS,facility,_,,