Random "number assignment"

Question

Hi! 
I built a junior rodeo app and I'm wondering if there's a way I can do a "random draw" for scorecards.
We have to generate a random sequence of numbers depending on how many players are in that event. Right now we're using a random number generator, and just taking whatever number order they generate and assigning it manually for over 1,000 scorecards. We have a report, and it's okay to type the number down the list, but it would be great if QB could generate a random draw for us! 
Here's how it works: The "draw" determines when they come out of the gate - when it's their turn.
Event A has 14 players, they need to be assigned random numbers.
Event B has 12 players and need a random number assigned. etc and so on.
Does anyone have any ideas?------------------------------Renee Hansen------------------------------

PrashantMaheshw · Answer

If you are ok with a slow pipeline/jinja solution (although it would be still faster than you manually copy pasting) ,It can generate random ID

I tried updating a record with following formula and it works great

{{ range(1, 10000) | random }}

------------------------------
Prashant Maheshwari
------------------------------

Sign up

Login to the community