Saw this question in our support channel and thought it might be worth sharing here.
Randomly select a row when pressing a button?
mallika
#2
@Moriah has a solution to this one 
There is a way to do this! The formula for it is a bit complex at the moment so I’ll explain it to you. To select a random row from a table, you would have a formula that looks something like this (where tableName
is the name of your table):
tableName.nth((random() * tableName.count()).roundUp(0))
Here’s how it works:

random()
grabs a random decimal number between 0 and 1  multiply this by the number of rows in the table (we find this using
tableName.count()
), and then round up to the nearest integer so that you end up with a random integer number from 1 to the size of the table, representing a random row 
tableName.nth()
looks up a row based on its row number. So, we insert the random number we found into thenth()
formula to get a random row.
If you wanted to, say, show the text of a random row when pressing a button, you might do something like:
 On button press, modify the row of a table to hold the result with the row lookup we used here! then you can grab the data off of that row there. Something like this:
5 Likes
Dungeons and Dragons Template