 # Randomly select a row when pressing a button?

Saw this question in our support channel and thought it might be worth sharing here.

@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 the `nth()` 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