Forum Discussion

PrashantMaheshw

Qrew Captain

Re: Random "number assignment"

Create two fields on your records you wish to generate random number

checkbox - GenerateRandom
text - RandomScore

Create a pipeline

Trigger- When records are updated , when GenerateRandom=True
Update field RandomScore
Value {{ range(1, 10000) | random }}

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

5 Replies

ReneeHansen
Qrew Member
3 years ago
Thanks! I'll give that a try!

------------------------------
Renee Hansen
------------------------------
ReneeHansen
Qrew Member
3 years ago
It seems to be working, however, I am getting repeated numbers. Is there a way to not have that happen?

------------------------------
Renee Hansen
------------------------------
- PrashantMaheshw
  Qrew Captain
  3 years ago
  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
  ------------------------------
  - ReneeHansen
    Qrew Member
    3 years ago
    I'm trying really hard to stay out of excel.
    
    ------------------------------
    Renee Hansen
    ------------------------------