How to display 40 random numbers on one screen

Hi everyone,

I hope you are well. I have seen this post on random numbers and I hoped someone could help me with my problem. I am trying to get 40 non-repeated random numbers that will corresponds to the households that will be sampled. Once these numbers are calculated, I would like to display them on the same ODK page, so that I don't have to scroll through 40 pages. I currently have the calculation as shown in the attached excel file. Does anyone know how to solve this problem?

Thank you in advance for your help

Test_villagesampling .xlsx (10.1 KB)

I think there are several strategies you can try:

  • Generate the random numbers in advance and display 40 numbers each time in a select-1 question
  • Generate 40. numbers each time the form is open and display them in a select-1 question