# Real random list **URL:** \ **Category:** Ask for Help\ **Created:** [September 27, 2020, 10:22pm UTC](https://community.glideapps.com/t/real-random-list/16429 "2020-09-27T22:22:45Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 10:22pm UTC](https://community.glideapps.com/t/real-random-list/16429/1 "2020-09-27T22:22:45Z")
Hello, I am trying to show random articles but the random sorting always shows me the same thing. I tried to do it by keywords but still showing me the same articles for those keywords. Looking for idea of how to show a REAL random list of anything, so that every time there’s a fresh list of random items. @ThinhDinh @Robert_Petitto would love your help. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 27, 2020, 10:24pm UTC](https://community.glideapps.com/t/real-random-list/16429/2 "2020-09-27T22:24:52Z")
How are you setting the random thing up? ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 10:28pm UTC](https://community.glideapps.com/t/real-random-list/16429/3 "2020-09-27T22:28:58Z")
I choose "sort -\> randomly ![Screen Shot 2020-09-27 at 12.27.06 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/18279d9142511727bbffeb32a95f3b086aee92f9.png) " ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 27, 2020, 10:30pm UTC](https://community.glideapps.com/t/real-random-list/16429/4 "2020-09-27T22:30:45Z")
So you just want the order of articles to be random and still showing them all? I displayed random rows in one of my apps but it was a case where I displayed just 1-3 rows of my data. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 10:33pm UTC](https://community.glideapps.com/t/real-random-list/16429/5 "2020-09-27T22:33:00Z")
It’s choosing the random articles and shows the same ones every time. So it’s only random the first time, then it’s just the same ones as before. So I think I need to be creative here somehow, maybe generate random numbers or something every few min. Not sure. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [September 27, 2020, 10:36pm UTC](https://community.glideapps.com/t/real-random-list/16429/6 "2020-09-27T22:36:18Z")
Are the informations displayed different in the whole list? ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 10:38pm UTC](https://community.glideapps.com/t/real-random-list/16429/7 "2020-09-27T22:38:03Z")
Not sure what you mean @Lucas_Pires, please clarify ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 10:43pm UTC](https://community.glideapps.com/t/real-random-list/16429/9 "2020-09-27T22:43:18Z")
Yes, they are different, let’s assume that. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 27, 2020, 10:54pm UTC](https://community.glideapps.com/t/real-random-list/16429/11 "2020-09-27T22:54:32Z")
I think an alternative way is to have a numerical order column. ``` =ARRAYFORMULA(IF(A2:A<>””,ROW(A2:A)-1,””)) ``` Then in the editor, make a single value column, take a random value from that numerical order column. Then set the sort to the single value, would it work? Not sure if we have to make a relation to get different numbers for each row. ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 11:04pm UTC](https://community.glideapps.com/t/real-random-list/16429/12 "2020-09-27T23:04:32Z")
I’ll give this a try! Thank @ThinhDinh 🙏🙏🙏 ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 27, 2020, 11:05pm UTC](https://community.glideapps.com/t/real-random-list/16429/13 "2020-09-27T23:05:01Z")
It’s not a bug, it’s a feature but just not a very well thought of feature 😂 ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [September 27, 2020, 11:17pm UTC](https://community.glideapps.com/t/real-random-list/16429/14 "2020-09-27T23:17:22Z")
I have an in-line list of users in cards layout in one of my apps…it is set to display the users randomly and it works well. It shows them in a different random order every time the app is launched, not if you visit a different tab and then return to the tab in the same session. Perhaps this is what makes it seem that it’s not working? ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 28, 2020, 4:13am UTC](https://community.glideapps.com/t/real-random-list/16429/15 "2020-09-28T04:13:22Z")
@Deena that won’t be enough for my needs. I want it to show them random items every time they read an article. Thank you 😍 ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 28, 2020, 10:31pm UTC](https://community.glideapps.com/t/real-random-list/16429/16 "2020-09-28T22:31:29Z")
Hi guys and anyone who is reading it. This is how I did it. I added a new column to my articles tab and added =RANDBETWEEN(1,1000) formula. This created a random number between 1 and 1000 for each article. In file-\>spreadsheet settings-\>calculation I set it to re-calculate every minute. On inline sort settings I set it to sort by order of the random number descending or ascending isn’t important in this case. And vualá! I have an actual random list of articles each time I load an article. Thank you for all your help!! More info: > **[How to Generate Random Numbers in Google Sheets](https://www.howtogeek.com/445056/how-to-generate-random-numbers-in-google-sheets/)** > > Google Sheets provides a simple function to generate random numbers inside your spreadsheet without having to leave the document or install an add-on. The function returns a random integer between two values. Here’s how to use it. ![Screen Shot 2020-09-28 at 12.30.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/48f62e0973152ffe0e72f4976b9c6bf6f6341203.png) ![Screen Shot 2020-09-28 at 12.30.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0b523f0f3004a5c3f07d876de72f0569c207d907.png) [Screen Shot 2020-09-28 at 12.31.09 PM|411x500](https://community.glideapps.com/uploads/short-url/jJA86m1YYlBUPGlBfqsBHYJ7xVV.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 29, 2020, 2:05am UTC](https://community.glideapps.com/t/real-random-list/16429/17 "2020-09-29T02:05:44Z")
In my experience when I used the single value random for my Chadwick app, it updates whenever the user makes an action while using the app. Pretty much instant. If you want to try it you can copy this back. > [@Copyable: A Tribute To Chadwick Boseman & The World Of Randomness](https://community.glideapps.com/t/copyable-a-tribute-to-chadwick-boseman-the-world-of-randomness/15768): > > Hi Gliders, it has been a while since I shared my last tutorial and I plan to do this once in a while, so here’s my next one. You can view my previous post here: Techniques used in this app: Tab visibility for sign up process Random value from single value column to change image & quote on homepage Combining multiple random values and use split text for gamification Conditional visibility + Cloudinary for a quiz-like experience App link: For this post, I make an app to pay tribute to M… ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [September 29, 2020, 8:08am UTC](https://community.glideapps.com/t/real-random-list/16429/18 "2020-09-29T08:08:09Z")
Wouldn’t this cause the entire sheet to reload every minute? ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 29, 2020, 5:55pm UTC](https://community.glideapps.com/t/real-random-list/16429/19 "2020-09-29T17:55:05Z")
The sheet doesn’t reload, the random numbers just change… ---
**Author:** ![SuperMerabh](https://avatars.discourse-cdn.com/v4/letter/s/8491ac/32.png) [@SuperMerabh](https://community.glideapps.com/u/SuperMerabh)\ **Post date:** [September 29, 2020, 5:57pm UTC](https://community.glideapps.com/t/real-random-list/16429/20 "2020-09-29T17:57:37Z")
Thank you @ThinhDinh, not sure why in my case it kept showing the same articles. I’ll check out your Chadwick app! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 29, 2020, 10:16pm UTC](https://community.glideapps.com/t/real-random-list/16429/21 "2020-09-29T22:16:00Z")
Let me know if I can help more 😄 ---
**Author:** ![Izhar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/izhar/32/21308_2.png) [@Izhar](https://community.glideapps.com/u/Izhar)\ **Post date:** [April 3, 2021, 9:01am UTC](https://community.glideapps.com/t/real-random-list/16429/22 "2021-04-03T09:01:51Z")
how about new record coming? should it be automatic created or need to do manual? [Next page](https://community.glideapps.com/t/real-random-list/16429.md?page=2)