Quickbase Discussions

 View Only
  • 1.  Lists and Random Functionality

    Posted 8 days ago
    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 the data set. Is there a way to do that? I looked into the report formulas and pipelines and nothing stood out, but doesn't mean it's not there. 2nd - If not, I know how to randomize it based off sorting the data a particular way, but didn't know if I am able to limit the output of the table to only 1000 rows? Either would work, but a random function would be more idea.

    Thank you
    Anthony

    ------------------------------
    Anthony McIntyre
    ------------------------------


  • 2.  RE: Lists and Random Functionality

    Posted 8 days ago
    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
    ------------------------------



  • 3.  RE: Lists and Random Functionality

    Posted 8 days ago

    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
    ------------------------------



  • 4.  RE: Lists and Random Functionality

    Posted 8 days ago
    Thank you for the formula, it's getting me one step closer to solving this issue!

    ------------------------------
    Anthony McIntyre
    ------------------------------



  • 5.  RE: Lists and Random Functionality

    Posted 8 days ago
    Edited by Marguerite Keating 8 days ago
    Mark and Jeff both mentioned some potential solutions. Agreed there isn't an easy answer to this specific issue in QB.

    Another option would be to use the Jinja Random function in a pipeline based off the Rec ID#, limit the result to 1k records, and then have the pipeline mark those 1000 random records with a checkbox. That way the report could be filtered to only show 1k records and be random.

    ------------------------------
    Marguerite Keating
    Quickbase Developer
    Synctivate Inc
    marguerite@synctivate.com
    www.Synctivate.com
    ------------------------------



  • 6.  RE: Lists and Random Functionality

    Posted 7 days ago
    Could you elaborate on Jinja Random function ? 

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