Random number generator

Hi,

Would anyone know if there’s a way to do a random number generator in Rows?

In gsheets, or excel, I’d use RANDBETWEEN to generate a value between two values.

Appreciate the help.

1 Like

Hey @Mikm :wave:t4: — thanks for reaching out. We don’t have a function that allows for randomization at the moment but here are a few workarounds that I could think of (there could of course be more than this as well) -

  1. running a =RIGHT(UNIXTIME(NOW()),1) every X minutes/hours & get the last few digits of the output
  2. using external services (like this one) via our GET/PUT/POST functions to generate & fetch random numbers
    Note: with this method though, you’d be consuming your integration tasks quota

I’ll also make sure to add this to our internal feature request list :slight_smile:

Hope these help!

All right!

Thanks for the suggestions, I’ll see if I can tinker a solution together with the UNIXTIME method :+1:

1 Like