Random order capping results at 9999

[Awbrey]

When I select "Random Order" on the Results Page Options, it automatically sets "Total Records Returned" to 9,999. And it won't allow me to set the number higher than 9,999, or to have "All Matching."   How can I have Random Order and All Matching?

[MickyMartian232]

If you want numbers from 1000 to 9999, that means you want values from a range of 9000 numbers. So that value needs to be your modulus, not 9999.Click Here

[Wikiwi]

I think the 9999 limit with Random Order enabled is a limitation set by Caspio. I also tried enabling Random order and I was able to check "All matching" on my DataPage.