View Options - Sort by random

[Arthur_Siloka]

It would amazing if the list of my products in the app would be displayed randomly when ever the app is opened. At this moment I can only choose sort by ascending or descending and its boring as the app seems static.

AppSheet team kindly look into this please or if there is a way to achieve what I want let me know. Thanks

[Steve]

This is entirely possible now, you just have to know how to do it: add a virtual column to the table you want randomly sorted. Give the column an App formula expression something like RANDBETWEEN(1, 999999). Sort by that that column. Give that a try. If that isn’t random enough (it may not be), we can adjust it.

See also:

help.appsheet.com

RANDBETWEEN()

Random integer from range

[Arthur_Siloka]

Hi Steve, thanks for the advice. I have tried as instructed but for some reason I don’t know it’s not working. Could there be something I’m missing or is there another way? Thanks

[Steve]

Please detail what you did, with screenshots if possible.

[Arthur_Siloka]

I just followed what @Kirk_Masden had done

[Lynn]

@Kirk_Masden
Maybe Kirk has a solution? I think he is into this sort of thing?

[Kirk_Masden · Accepted solution]

Thanks @Lynn! Yes, I’ve been interested in generating random orders that only change periodically – not every time a change is made in the app. @Arthur_Siloka, here are some posts on the topic that I have made in the past:

Randomize sort order every 3 hours Tips & Tricks 💡

I’m building an educational app to help students memorize vocabulary. For this app, I’d like the “cards” to be presented in an order that is randomized or shuffled occasionally. In Google Sheets I could use RAND() or RANDBETWEEN(), but those get recalculated whenever a change occurs, and that’s not what I want. I would like periodic (say, every three hours) shuffling of the order. By the way, in AppSheet, RANDBETWEEN() doesn’t seem to work for sorting because, in a virtual column at least, i…

Generating a random number and then one based on that number Questions

Hi! I’m using RandBetween() to make my app pick a quote randomly from a column. That’s easy enough. Let’s say I have 120 quotes and I want to make a slice that will pick out just one record to display in the detail view that is shown when the app is opened. I number the [Key] column from 1 to 120 and used this make the slice: [Key]=RANDBETWEEN(1,120) So far so good. Actually, though, I would like the slice to result in two records – the English quote and a corresponding Japanese translat…

This second one has an ingenious solution from @Steve.

[Arthur_Siloka]

Thank you. Your solutions does the treat. It’s everything I wanted.