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
Solved! Go to 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:
This second one has an ingenious solution from @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:
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
Please detail what you did, with screenshots if possible.
I just followed what @Kirk_Masden had done
@Kirk_Masden
Maybe Kirk has a solution? I think he is into this sort of thing?
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:
This second one has an ingenious solution from @Steve.
Thank you. Your solutions does the treat. Itโs everything I wanted.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |