Random List - XLS Advanced Form

[CraigMcIntyre1]

Hello,

I am somewhat new to Surey123 and I'm beginning to create a new survey using the XLS advanced form.

In a nut shell I am creating a cleaning audit, the user will select which unit they are at then score rooms based on cleanliness.

However I am having trouble with being able to show a random sample of rooms to be checked. I know what rooms are in each unit. 

For example:
I enter Unit A, upon selecting Unit A on my survey the next 5 questions should be the rooms that are to be audited. Which should be randomly populated from the master list of rooms. i.e Room G1, Room 3.4, Room 5.6 etc

I'd appreciate any help in regards to this.

Thanks Survey123 for ArcGISsurvey123 app#

[MarikaVertzonis]

Definitely not - that's just in the example to give visual confirmation that its working.

[CraigMcIntyre1]

Hi Marika,

I think your method on how to solve this would work! However, is it possible to take it even a step further. Ideally when I select a school the random 'activity' would only show those for that specific school. 

We have 50+ schools, meaning I would need to write 50+ lines in the 'relevant' column, dependent on what school was selected. 

Thanks for your suggestions!

[MarikaVertzonis]

Adding the school choice leads you down the path of needing a cascading select ie: choose school and then from a reduced list of activities, choose an activity. If you haven't already tried the cascading select sample, do have a look at it. Saying that, I tried using a choice_filter on the question that does the pulldata from the csv (to limit the list to activities that are relevant to a school that was chosen in a previous question), but it doesn't work - nor is it really designed to. The choice_filter is really about limiting the list in a second select_one question.

So does each school have a different list of random activities? Or can you arrange your information so you use the same list of random activities for each school? I think this would be the best way to do it. Or can you organize groups of lists? eg: schools 1,5,6,7 use list 1 and schools 2,3,4,8,9 use list 2? Then you could use the random choice generator as above, just apply it to different questions.