Skip to main content
Question

Lists and Random Functionality

  • June 23, 2022
  • 0 replies
  • 365 views
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
------------------------------
This topic has been closed for replies.

SSNJeffP
Forum|alt.badge.img+11
  • SSNJeffP
  • Registered
  • June 23, 2022
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
------------------------------
MargeinCharge
Forum|alt.badge.img
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
------------------------------
    Terms & ConditionsAccessibility statement