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…

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 …

I choose "sort -> randomly[Screen Shot 2020-09-27 at 12.27.06 PM] "

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.

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.

Are the informations displayed different in the whole list?

Not sure what you mean @Lucas_Pires , please clarify

Yes, they are different, let’s assume that.

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 rela…

I’ll give this a try! Thank @ThinhDinh :pray::pray::pray:

It’s not a bug, it’s a feature but just not a very well thought of feature :joy:

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…

Real random list

Ask for Help

ThinhDinh September 29, 2020, 2:05am 17

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.

Topic		Replies	Views
How to refresh RAND()? Ask for Help	5	632	April 6, 2023
🔀 Random Sort! General	9	1637	November 3, 2020
Random sort Ask for Help	5	764	May 5, 2020
Random is not really random Ask for Help	1	454	August 26, 2020
Shuffle images in row cells Ask for Help	9	1391	May 5, 2020

Real random list

Related topics