Random number in cells

[Vladimir]

Hi guys. The following question arose: how to make sure that random numbers are generated once a minute, say from 10 to 90?

[Eric_Penn]

So you want one random number generated every minute… and that number should be between 10-90…. or did you want something else?

[Vladimir]

Yes, this is exactly what I need for the assignment, but I just can’t do it.

[Darren_Murphy]

• Create a Math column using the following formula:

Year(Now)*10^8
+ Month(Now)*10^6
+ Day(Now)*10^4
+ Hour(Now)*10^2
+ Minute(Now)

• Create a Template column that concatenates the Math column with a RowID column.
• Use that template column as the seed for a Roll Dice column with 80 sides.
• Use another math column to add 10 to the Roll Dice column

[Eric_Penn]

Another way is like this…

1.Add a math column with minute(now)

2.Add a roll dice column with sides 80 and use the math column for the seed.

[Robert_Petitto]

@Eric_Penn

Add a roll dice column with sides 80 and use the math column for the seed.

I like this. Math column is roll+10, no?

[Darren_Murphy]

ooops, I misread. I thought it was supposed to change every ten minutes. I’ll update my response.

Your solution is okay, except that:

• the numbers will repeat every 60 minutes
• it will give the same result on every row

The above may or may not be a problem.

[Eric_Penn]

Ya i just realized that will only give me 60 numbers and they could be predicted

[Vladimir]

Thank you very much! Your answers helped me and I learned some things that will be useful to me soon!

[Eric_Penn]

Here’s my final approach

1. Math column configured → Minute(Now)

2. JS Column grabs timestamp when user opens app

date = new Date();
return date;

3. Template column to join Math column and JS column

4. Roll dice sides 60 with the template from step 3 for the seed

In my mind this approach was for a one row table