Generate Random Whole Number

#1

Hi again

How do I generate a random whole number between, say, 8 and 20?

I’ve played with regular expressions, json and formulas but can’t figure it out.

I’ve found this in JavaScript “Math.floor(Math.random() * 20) + 1” but don’t know how I can use it.

Any ideas?

Regards
Martin

#2

Hi @themartincotterill - it’s much simpler than that. Select the Number data type, set your minimum, maximum and leave decimals at 0.

#3

Ye Gods! The words “stupid” and “idiot” spring to mind! Trust me to overcomplicate things!

Many thanks for the help.