pull a random record?

Mitch

Hi there,

Is there a simple way to pull a random record from a table?  I know I can do it in a few steps... counting the total records, choosing a random number equal or less than that total, and searching by ID.....  but in this case, I'm pulling quite a few variables, so I'm trying to be as lean as possible.....

Thanks!

Michael Udinski

You can do this in one line: Use the Query All Records function. Change the return type to single and add a random sort.

Mitch

duh...... 

thank you, Michael 😄

Sunday

 I don't understand how to add a random sort to the record. 

Michael Udinski

 (Query All Records > Output > Return > Add Sort > Select a field and "random")
[CleanShot 2022-08-08 at 10.30.08.png][CleanShot 2022-08-08 at 10.30.30.png]

Sunday

 Thanks a lot.