Lists and Random Functionality
Hi everyone, I am new to QB so these questions could have simple solutions so I figured I would post them. I am currently uploading 100K+ in entries from excel and want to select a random 1000 from th...
Forum Discussion
I do not believe there is any way to generate random values in QuickBase natively. You could probably do this using some javascript and a code page, but that's a bit more of an advanced function.
------------------------------
Jeff Peterson
------------------------------
------------------------------
Jeff Peterson
------------------------------
- MarkShnier__You
Qrew Legend
I have this in my bag of tricks to generate a Random number. If you really cared how random it was you would have to run your own statistical test I suppose. Since it is based on the record ID then you have to decide if that works for your process because of course this pseudo-random number will never change for a particular Record ID
ToNumber(Right(ToText(Int([Record ID#]*9973/127)),4))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thank you for the formula, it's getting me one step closer to solving this issue!
------------------------------
Anthony McIntyre
------------------------------
