To pick a random row of data from a table, the ANY() function will not suffice. Here’s a simple pattern to do this:
index(Test Score[Key], randbetween(1, count(Test Score[Key])) )
Where “Test Score” is your table name and “Key” is that table’s key.
This sample app shows this in two ways:
We format a row randomly. When you resync the app, a new random row will be selected each time (in bold red)
We have an icon on the left side of the table which will assign a “person” to the “test score” randomly.
This comes up from time to time in various situations and I didn’t see an existing forum post. As usual, chime in if you have a better version!