Random "number assignment"
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 t...
Forum Discussion
I think this is the proper result . Each record is random ,
What you are looking for is a list of unique random numbers between 1-100
I think excel might be an easier feature here.Export a CSV in excel with
Record ID# | DrawTest
In Drawtest you can put the formula =SORTBY(SEQUENCE(100),RANDARRAY(100))
Then import it back into QuickBase
PS : This is in excel 365
------------------------------
Prashant Maheshwari
------------------------------
What you are looking for is a list of unique random numbers between 1-100
I think excel might be an easier feature here.Export a CSV in excel with
Record ID# | DrawTest
In Drawtest you can put the formula =SORTBY(SEQUENCE(100),RANDARRAY(100))
Then import it back into QuickBase
PS : This is in excel 365
------------------------------
Prashant Maheshwari
------------------------------
I'm trying really hard to stay out of excel.
------------------------------
Renee Hansen
------------------------------
------------------------------
Renee Hansen
------------------------------
- Yeah , I understand , I would also love to have QuickBase only solution . If you do manage to figure this out , let me know I would also love to know
------------------------------
Prashant Maheshwari
------------------------------
