Trying to use Random() to filter rows

#1

Hey there!

I just discovered Random() and it’s fun.
But I’m struggling to do what I wish to do with a random filter.
I have a table with 113 rows. I would like to create a filter based on Random for each days.
But I can’t as the random changes every time. Is there a way to add a seed to random or change the random value on wish?
Thanks/

#2

again, could you post a picture?

So the problem is that random changes every time you log in?

When is random supposed to change?

My spontaneous though is playing around with modified() or time().

What is your output?

#3

Hey there @Philipp_Alexander_Asbrand-Eickhoff

The problem is that random changes continuously.

In my case, if I don’t edit the document, the random number will not change, but if I edit anything on the doc, the random number will change.
I would love to be able to freeze/record the random number for a period and that this random number would update every X time or once a day.
Here is a screenshot of my table and formulas:

#4

In that case just make yourself an alternative random function…

right(remainder(997,day(today())+1)*Power(7,hour(now())),2)

something like this will give you a “random” number between 0-99 every hour; not all numbers will be covered and they will not occur at the same frequency - but maybe this is at least something?

yes, twice a day it would be the same (I think coda uses 0-12 for hours, not the German 0-24 hour count?)

1 Like
#5

Nice, I love that!

When I do =hour(now()) I get a 0-24hrs syntax. Not sure if it has to do with local settings like browser lang or something, but I think it should be global for everyone