topic Re: Having Survey123 Randomly Select Questions from a Pool in ArcGIS Survey123 Questions

Having Survey123 Randomly Select Questions from a Pool

BrianTruong — Tue, 23 Jan 2024 15:31:42 GMT

Hey All,

Need some help seeing if something like this is possible on Survey123. Looking to see if I could see 3 random questions from a pool of 15 questions each time I open up survey123.

So if anyone has any ideas or suggestions it would be greatly appreciated.

Thank you!

Re: Having Survey123 Randomly Select Questions from a Pool

DougBrowning — Tue, 23 Jan 2024 16:02:30 GMT

Maybe my idea from this post would work? https://community.esri.com/t5/arcgis-survey123-questions/designing-a-survey-with-random-fields-from-a-list/m-p/1360601

Re: Having Survey123 Randomly Select Questions from a Pool

IsmaelChivite — Tue, 23 Jan 2024 17:14:26 GMT

One more suggestion in the attached Random12.xlsx

The random function in XLSForm generates random numbers. For example: int(12*random())+1 will generate a number between 1 and 12 (included). You can then use that number to show/hide questions.

With the logic in the attached XLSForm, there is a small chance you could potentially get fewer than 3 questions if random picks the same number twice. I added a simple check, but it is not bullet proof.