Sort an External Choice List in the Survey123 Form

Question

I have a few CSVs that I am using for multiple surveys, they're only a few hundred rows but because they're used in multiple places this makes my life way easier updating one list instead of several.

My question is, is there a way to have this list sort differently in each of my surveys so the most relevant answers appear at the top on each survey?

Thanks!

DerrickFreseADF · Answer

@IsmaelChivite, is it possible to sort external choice lists at all? We have a csv in Portal that we're using to pull a list from and every time the survey is opened the list is in a different order.

RobertAnderson3 · Answer

Thank you for the suggestions @beachcamp !

Was trying to avoid the clutter of copies, but the scripting it is a good idea. And I have been using the autocomplete for it anyways but still want to make it as simple as I can for users. There's like 5-10 options they use daily and then 100 more that might get used once a month.

What I've ended up deciding to do is, I had an "Other" option in my pick list that opened up a text question for free entry, I've set up a choice filter that will show the most relevant + Other for the first question, then changed the free text to a select one that just shows ALL of them for the secondary question if they pick other.

RobertAnderson3 · Answer

I had a feeling it wasn't but wanted to double check, thanks!